{"id":186480,"date":"2014-08-05T16:53:28","date_gmt":"2014-08-05T07:53:28","guid":{"rendered":"https:\/\/ja.wordpress.org\/support\/2014\/08\/05\/%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e3%81%8b%e3%82%89%e5%80%a4%e3%82%921%e3%81%a4%e3%81%9a%e3%81%a4%e5%8f%96%e5%be%97%e3%81%97%e3%81%9f%e3%81%84\/"},"modified":"2014-08-05T16:53:28","modified_gmt":"2014-08-05T07:53:28","slug":"%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e3%81%8b%e3%82%89%e5%80%a4%e3%82%921%e3%81%a4%e3%81%9a%e3%81%a4%e5%8f%96%e5%be%97%e3%81%97%e3%81%9f%e3%81%84","status":"closed","type":"topic","link":"https:\/\/ja.wordpress.org\/support\/topic\/%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e3%81%8b%e3%82%89%e5%80%a4%e3%82%921%e3%81%a4%e3%81%9a%e3%81%a4%e5%8f%96%e5%be%97%e3%81%97%e3%81%9f%e3%81%84\/","title":{"rendered":"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u5024\u30921\u3064\u305a\u3064\u53d6\u5f97\u3057\u305f\u3044"},"content":{"rendered":"

\u3044\u3064\u3082\u5927\u5909\u304a\u4e16\u8a71\u306b\u306a\u3063\u3066\u304a\u308a\u307e\u3059\u3002<\/p>\n

\u30d7\u30e9\u30b0\u30a4\u30f3Contact Form DB\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5024\u30921\u3064\u305a\u3064\u53d6\u5f97\u3057\u305f\u3044\u306e\u3067\u3059\u304c\u3001\u65b9\u6cd5\u304c\u5206\u304b\u308a\u307e\u305b\u3093\u3002
\n\u73fe\u5728\u3001\u9001\u4fe1\u65e5\u6642\u3092\u4e0b\u8a18\u306e\u3088\u3046\u306b\u53d6\u5f97\u3057\u3066\u304a\u308a\u307e\u3059\u3002<\/p>\n

<?php\n$user_id = get_current_user_id();\n$cfdbs = $wpdb->get_results( "\nSELECT *\nFROM {$wpdb->prefix}cf7dbplugin_submits\nWHERE field_name = 'your-id' AND field_value = {$user_id}\n" );\nforeach ($cfdbs as $cfdb) {\n$cfdb_time = $cfdb->submit_time;\necho "<td>".date("Y-m-d H:i:s", $cfdb_time ). "<\/td>";\n}\n?><\/code><\/pre>\n
Contact Form DB\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u306f\u3001submit_time,form_name,field_name,field_value,field_order,file\u3068\u3042\u308a\u3001field_name\u306b\u5404\u5165\u529b\u9805\u76ee\u304c\u3042\u308a\u3001\u305d\u308c\u306b\u5bfe\u3059\u308b\u5024\u304cfield_value\u306b\u3042\u308b\u306e\u3067\u3001\u5358\u7d14\u306b\u884c\u3054\u3068\u306b\u53d6\u5f97\u51fa\u6765\u306a\u3044\u306e\u3067\u3059\u3002<\/p>\n
\u4e0a\u8a18\u30b3\u30fc\u30c9\u3067\u3001\u30ed\u30b0\u30a4\u30f3\u30e6\u30fc\u30b6\u30fc\u306e\u9001\u4fe1\u65e5\u6642\u3092\u53d6\u5f97\u3057\u3066\u304a\u308a\u307e\u3059\u304c\u3001\u305d\u306e$cfdb_time\u306b\u5bfe\u3059\u308b\u4ed6\u306e\u5024\u3082\u53d6\u5f97\u3057\u3066table\u306b\u53ce\u3081\u305f\u3044\u306e\u3067\u3059\u3002<\/p>\n
\u4e0a\u8a18\u30b3\u30fc\u30c9\u3067\u306f\u3001\u9001\u4fe1\u65e5\u6642\u304c\u3001
\n<td>2014-07-24 09:19:42<\/td><td>2014-08-05 14:33:18<\/td><\/code>
\n\u3068\u3044\u3046\u3088\u3046\u306b\u53d6\u5f97\u3055\u308c\u307e\u3059\u304c\u3001\u305d\u306e\u5f8c\u306b\u3001\u540c\u69d8\u306bwhere\u6761\u4ef6\u306bsubmit_time = {$cfdb_time}<\/code>
\n\u3068\u3057\u3066\u4ed6\u306efield_value\u3092\u53d6\u5f97\u3057\u3066\u3082\u30011\u4ef6\u306e\u307f\u3057\u304b\u53d6\u5f97\u3055\u308c\u307e\u305b\u3093\u3002
\n\u305d\u308c\u3067\u3001\u914d\u5217\u306e\u3088\u3046\u306b\u30011\u4ef6\u305a\u3064\u53d6\u5f97\u3067\u304d\u308c\u3070\u30fb\u30fb\u30fb\u3068\u601d\u3063\u305f\u306e\u3067\u3059\u304c\u3001\u53ef\u80fd\u3067\u3057\u3087\u3046\u304b\uff1f<\/p>\n
\u3044\u3064\u3082\u6559\u3048\u3066\u3082\u3089\u3063\u3066\u3070\u304b\u308a\u3067\u7533\u3057\u8a33\u306a\u3044\u3067\u3059\u304c\u3001\u4f55\u5352\u3001\u3054\u6559\u793a\u306e\u307b\u3069\u3088\u308d\u3057\u304f\u304a\u9858\u3044\u81f4\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"template":"","class_list":["post-186480","topic","type-topic","status-closed","hentry","topic-tag-wpdb","topic-tag-14068","topic-tag-contact-form-7","topic-tag-contact-form-db","topic-tag-get_results"],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/ja.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/186480","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ja.wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/ja.wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/ja.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/186480\/revisions"}],"wp:attachment":[{"href":"https:\/\/ja.wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=186480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}