{"id":170,"date":"2013-10-09T00:00:00","date_gmt":"2013-10-08T15:00:00","guid":{"rendered":"http:\/\/taitan916.info\/blog\/?p=170"},"modified":"2014-05-22T21:04:04","modified_gmt":"2014-05-22T12:04:04","slug":"post-170","status":"publish","type":"post","link":"https:\/\/taitan916.info\/blog\/archives\/170","title":{"rendered":"PHP\u304b\u3089MySQL\u306b\u30b7\u30ea\u30a2\u30e9\u30a4\u30ba\u3057\u305f\u30c7\u30fc\u30bf\u3092\u683c\u7d0d"},"content":{"rendered":"<p>\u30a2\u30f3\u30b1\u30fc\u30c8\u30d5\u30a9\u30fc\u30e0\u307f\u305f\u3044\u306a\u306e\u304c\u3042\u3063\u3066\u3001<br \/>\n\u4eca\u5f8c\u3082\u5b9a\u671f\u958b\u50ac\u3057\u3001\u5c1a\u4e14\u3064\u8cea\u554f\u5185\u5bb9\u306f\u5897\u6e1b\u3059\u308b<br \/>\n\u53ef\u80fd\u6027\u304c\u3042\u3063\u305f\u3002<\/p>\n<p>\u3067\u3001\u56de\u7b54\u3059\u308b\u307b\u3046\u306f\uff13\uff5e\u306e\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3002<br \/>\n\u4eca\u306f3\u3064\u3060\u3051\u3069\u4eca\u5f8c\u306f\u5897\u3048\u308b\u304b\u3082\u3057\u308c\u306a\u3044\u3057\u6e1b\u308b\u304b\u3082\u3057\u308c\u306a\u3044\u3002<br \/>\n\u3067\u3001\u305d\u308c\u3092\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u7a81\u3063\u8fbc\u307f\u305f\u304b\u3063\u305f\u3002<\/p>\n<p>\u4eca\u307e\u3067\u306f\u56de\u7b54\u3092\u53d7\u3051\u53d6\u3063\u3066\u30ab\u30f3\u30de\u533a\u5207\u308a\u3068\u304b\u306b\u3057\u3066<br \/>\nDB\u306b\u7a81\u3063\u8fbc\u3093\u3067\u305f\u3051\u3069\u3001\u4ee5\u524d\u5148\u8f29\u304b\u3089\u300c\u30ab\u30f3\u30de\u533a\u5207\u308a\u306f<br \/>\n\u3044\u3051\u3066\u306a\u3044\u3002\u6b63\u898f\u5316\u3067\u304d\u306a\u3044\u306a\u3089\u305b\u3081\u3066<a class=\"keyword\" href=\"http:\/\/d.hatena.ne.jp\/keyword\/%A5%B7%A5%EA%A5%A2%A5%E9%A5%A4%A5%BA\">\u30b7\u30ea\u30a2\u30e9\u30a4\u30ba<\/a>\u3057\u306a\u3055\u3044\u300d<br \/>\n\u3068\u8a00\u308f\u308c\u305f\u3053\u3068\u3092\u601d\u3044\u51fa\u3057\u3066\u8a66\u3057\u305f\u3068\u3053\u308d\u4fbf\u5229\u3060\u3063\u305f\u3002<\/p>\n<p><span style=\"color: #000099;\">\u25a0\u53c2\u8003\u30b5\u30a4\u30c8<\/span><br \/>\n<a href=\"http:\/\/suin.asia\/2011\/08\/09\/4_tips_to_preserve_array_as_string\">http:\/\/suin.asia\/2011\/08\/09\/4_tips_to_preserve_array_as_string<\/a><\/p>\n<p>$ans = <span style=\"color: #990000;\">serialize<\/span>($_GET['answer']);<br \/>\n$<a class=\"keyword\" href=\"http:\/\/d.hatena.ne.jp\/keyword\/sql\">sql<\/a> = '<br \/>\nINSERT INTO \u30c6\u30fc\u30d6\u30eb<br \/>\n(<br \/>\nanswer<br \/>\n)<br \/>\nVALUES<br \/>\n(<br \/>\n\"' . <a class=\"keyword\" href=\"http:\/\/d.hatena.ne.jp\/keyword\/mysql\">mysql<\/a>_real_escape_string($ans) . '\",<br \/>\n)<br \/>\n;<\/p>\n<p>\u30a8\u30b9\u30b1\u30fc\u30d7\u3068\u304b\u3069\u3046\u306a\u308b\u306e\u3001\u3068\u601d\u3063\u305f\u3051\u3069\u4e0a\u8a18\u306e\u5f62\u3067\u3044\u3051\u305f\u3002<br \/>\n<a class=\"keyword\" href=\"http:\/\/d.hatena.ne.jp\/keyword\/MySQL\">MySQL<\/a>\u306e\u65b9\u306f\u6587\u5b57\u5217\u30bf\u30a4\u30d7\u3067\u3044\u3051\u308b\u307f\u305f\u3044\u306a\u306e\u3067\u3001<br \/>\ntext\u578b\u3067\u3044\u3063\u305f\u3002\u591a\u5206varchar\u3067\u3082\u5927\u4e08\u592b\u305d\u3046\u3002<\/p>\n<p>\u3042\u3068\u3001\u6587\u5b57\u5217\u6271\u3044\u3060\u3063\u305f\u3089\u30ab\u30f3\u30de\u533a\u5207\u308a\u3068\u3042\u3093\u307e\u5909\u308f\u3089\u3078\u3093\u306e\u3067\u306f\uff1f<br \/>\n\u3068\u601d\u3063\u305f\u3051\u3069\u3001\u3088\u304f\u3088\u304f\u898b\u308b\u3068\u591a\u6570\u306e\u578b(bool\u578b\u30fbint\u578b\u30fbfloat\u578b\u30fbstring\u578b\u30fb\u6dfb\u5b57\u914d\u5217\u30fb<a class=\"keyword\" href=\"http:\/\/d.hatena.ne.jp\/keyword\/%CF%A2%C1%DB%C7%DB%CE%F3\">\u9023\u60f3\u914d\u5217<\/a>)<br \/>\n\u304c\u3044\u3051\u308b\u3089\u3057\u3044\u306e\u3067\u7d76\u5bfe\u4fbf\u5229\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30a2\u30f3\u30b1\u30fc\u30c8\u30d5\u30a9\u30fc\u30e0\u307f\u305f\u3044\u306a\u306e\u304c\u3042\u3063\u3066\u3001 \u4eca\u5f8c\u3082\u5b9a\u671f\u958b\u50ac\u3057\u3001\u5c1a\u4e14\u3064\u8cea\u554f\u5185\u5bb9\u306f\u5897\u6e1b\u3059 ... <\/p>\n","protected":false},"author":1,"featured_media":1085,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2,5],"tags":[],"class_list":["post-170","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","category-mysql"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/comments?post=170"}],"version-history":[{"count":0,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/170\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media\/1085"}],"wp:attachment":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media?parent=170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/categories?post=170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/tags?post=170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}