{"id":998,"date":"2017-02-21T10:37:32","date_gmt":"2017-02-21T01:37:32","guid":{"rendered":"http:\/\/blue-bear.jp\/kb\/?p=998"},"modified":"2017-02-21T10:37:32","modified_gmt":"2017-02-21T01:37:32","slug":"php-mysqli%e3%82%af%e3%82%a8%e3%83%aa%e6%a7%8b%e6%96%87%e3%82%92%e7%84%a1%e5%ae%b3%e5%8c%96%e3%81%99%e3%82%8b%ef%bc%88%e3%82%a8%e3%82%b9%e3%82%b1%e3%83%bc%e3%83%97%e5%87%a6%e7%90%86%ef%bc%89","status":"publish","type":"post","link":"https:\/\/blue-bear.jp\/kb\/php-mysqli%e3%82%af%e3%82%a8%e3%83%aa%e6%a7%8b%e6%96%87%e3%82%92%e7%84%a1%e5%ae%b3%e5%8c%96%e3%81%99%e3%82%8b%ef%bc%88%e3%82%a8%e3%82%b9%e3%82%b1%e3%83%bc%e3%83%97%e5%87%a6%e7%90%86%ef%bc%89\/","title":{"rendered":"[php] mysqli\u30af\u30a8\u30ea\u69cb\u6587\u3092\u7121\u5bb3\u5316\u3059\u308b\uff08\u30a8\u30b9\u30b1\u30fc\u30d7\u51e6\u7406\uff09"},"content":{"rendered":"<h2>mysqli\u30af\u30a8\u30ea\u69cb\u6587\u3092\u7121\u5bb3\u5316\u3059\u308b\uff08\u30a8\u30b9\u30b1\u30fc\u30d7\u51e6\u7406\uff09<\/h2>\n<p>mysqli\u30af\u30a8\u30ea\u69cb\u6587\u3092\u30a8\u30b9\u30b1\u30fc\u30d7\u51e6\u7406\u3059\u308b\u306b\u306fmysqli_real_escape_string\u3092\u4f7f\u7528\u3059\u308b<\/p>\n<p>mysqli_real_escape_string ( mysqli $link , string $escapestr )<\/p>\n<pre>\/\/DB\u30a2\u30ab\u30a6\u30f3\u30c8\u60c5\u5831\u306e\u8a2d\u5b81E\r\n$host = \"host\u540d\";\r\n$user = \"user\u540d\";\r\n$password = '\u30d1\u30b9\u30ef\u30fc\u30c9';\r\n$database = \"DB\u540d\";\r\n\r\n$mysqli = new mysqli($host, $user, $password, $database)\r\n\t\t or die(\"DB connection dis-connected\");\r\n$mysqli-&gt;set_charset(\"utf8\");\r\n\r\n$message = \"Let's go\"; \/\/\u30b3\u30ed\u30f3\u3092\u7121\u5bb3\u5316\u3059\u3079\u3057\r\n$sql = \"INSERT INTO `table\u540d` (`message`) VALUES ('$message');\r\n$sql = mysqli_real_escape_string($mysqli,$sql);\r\n<\/pre>\n<p>\u53c2\u8003\uff1a<a href=\"http:\/\/php.net\/manual\/ja\/mysqli.real-escape-string.php\" target=\"_blank\">http:\/\/php.net\/manual\/ja\/mysqli.real-escape-string.php<\/a><\/p>\n<p>*mysql_escape_string\u306fphp7\u3067\u5ec3\u6b62\u3055\u308c\u3066\u3044\u308b<\/p>\n","protected":false},"excerpt":{"rendered":"<p>mysqli\u30af\u30a8\u30ea\u69cb\u6587\u3092\u7121\u5bb3\u5316\u3059\u308b\uff08\u30a8\u30b9<\/p>\n","protected":false},"author":1,"featured_media":999,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[139,157],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts\/998"}],"collection":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/comments?post=998"}],"version-history":[{"count":1,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts\/998\/revisions"}],"predecessor-version":[{"id":1000,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts\/998\/revisions\/1000"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/media\/999"}],"wp:attachment":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/media?parent=998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/categories?post=998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/tags?post=998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}