{"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":"

\u30a2\u30f3\u30b1\u30fc\u30c8\u30d5\u30a9\u30fc\u30e0\u307f\u305f\u3044\u306a\u306e\u304c\u3042\u3063\u3066\u3001
\n\u4eca\u5f8c\u3082\u5b9a\u671f\u958b\u50ac\u3057\u3001\u5c1a\u4e14\u3064\u8cea\u554f\u5185\u5bb9\u306f\u5897\u6e1b\u3059\u308b
\n\u53ef\u80fd\u6027\u304c\u3042\u3063\u305f\u3002<\/p>\n

\u3067\u3001\u56de\u7b54\u3059\u308b\u307b\u3046\u306f\uff13\uff5e\u306e\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3002
\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
\n\u3067\u3001\u305d\u308c\u3092\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u7a81\u3063\u8fbc\u307f\u305f\u304b\u3063\u305f\u3002<\/p>\n

\u4eca\u307e\u3067\u306f\u56de\u7b54\u3092\u53d7\u3051\u53d6\u3063\u3066\u30ab\u30f3\u30de\u533a\u5207\u308a\u3068\u304b\u306b\u3057\u3066
\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
\n\u3044\u3051\u3066\u306a\u3044\u3002\u6b63\u898f\u5316\u3067\u304d\u306a\u3044\u306a\u3089\u305b\u3081\u3066\u30b7\u30ea\u30a2\u30e9\u30a4\u30ba<\/a>\u3057\u306a\u3055\u3044\u300d
\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

\u25a0\u53c2\u8003\u30b5\u30a4\u30c8<\/span>
\nhttp:\/\/suin.asia\/2011\/08\/09\/4_tips_to_preserve_array_as_string<\/a><\/p>\n

$ans = serialize<\/span>($_GET['answer']);
\n$sql<\/a> = '
\nINSERT INTO \u30c6\u30fc\u30d6\u30eb
\n(
\nanswer
\n)
\nVALUES
\n(
\n\"' . mysql<\/a>_real_escape_string($ans) . '\",
\n)
\n;<\/p>\n

\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
\nMySQL<\/a>\u306e\u65b9\u306f\u6587\u5b57\u5217\u30bf\u30a4\u30d7\u3067\u3044\u3051\u308b\u307f\u305f\u3044\u306a\u306e\u3067\u3001
\ntext\u578b\u3067\u3044\u3063\u305f\u3002\u591a\u5206varchar\u3067\u3082\u5927\u4e08\u592b\u305d\u3046\u3002<\/p>\n

\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
\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\u9023\u60f3\u914d\u5217<\/a>)
\n\u304c\u3044\u3051\u308b\u3089\u3057\u3044\u306e\u3067\u7d76\u5bfe\u4fbf\u5229\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\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":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t