PHP\u3067MySQL\u3092\u6271\u3046\u969b\u306fmysqli\u95a2\u6570\u3092\u3001\u30a8\u30b9\u30b1\u30fc\u30d7\u306e\u969b\u306freal_escape_string\u3092\u4f7f\u7528\u3057\u3066\u3044\u305f\u3002\u305f\u3060\u4ed6\u793e\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u898b\u308b\u3068pdo \/ mysqli\u3069\u3061\u3089\u3092\u4f7f\u3046\u306b\u3057\u3066\u3082\u30d7\u30ea\u30da\u30a2\u30c9\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3067\u66f8\u304b\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u591a\u3044\u3088\u3046\u306b\u601d\u3046\u3002\u305d\u3053\u3067\u30d7\u30ea\u30da\u30a2\u30c9\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u66f8\u304d\u65b9\u3092\u899a\u3048\u3066\u304a\u304d\u305f\u3044\u3002<\/p>\n
<\/p>\n
mysql> SHOW COLUMNS FROM test_table;\r\n+------------+--------------+------+-----+---------+----------------+\r\n| Field | Type | Null | Key | Default | Extra |\r\n+------------+--------------+------+-----+---------+----------------+\r\n| id | int | NO | PRI | NULL | auto_increment |\r\n| name | varchar(255) | NO | | NULL | |\r\n| score | int | NO | | NULL | |\r\n| regist_ymd | datetime | NO | | NULL | |\r\n+------------+--------------+------+-----+---------+----------------+<\/pre>\n<\/p>\n
\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9<\/h2>\n
INSERT<\/h3>\n
$stmt = $mysqli->prepare(\"\r\n INSERT INTO test_table \r\n (name, score, regist_ymd) \r\n VALUES \r\n (?, ?, now())\r\n\");\r\n\r\n$name = '\u5c71\u7530';\r\n$score = 50;\r\n\r\n$stmt->bind_param('si', $name, $score);\r\n\r\n$res = $stmt->execute();\r\n$stmt->close();<\/pre>\nUPDATE<\/h3>\n
$stmt = $mysqli->prepare(\"\r\n UPDATE test_table \r\n SET name = ?\r\n WHERE id = ?\r\n\");\r\n\r\n$name = '\u9ad8\u6a4b';\r\n$id = 1;\r\n\r\n$stmt->bind_param('si', $name, $id);\r\n\r\n$res = $stmt->execute();\r\n$stmt->close();<\/pre>\nSELECT<\/h3>\n
$stmt = $mysqli->prepare(\"\r\n SELECT * \r\n FROM test_table \r\n WHERE score > ?\r\n\");\r\n$score = 70;\r\n$stmt->bind_param('i',$score);\r\n$stmt->execute();\r\n$result = $stmt->get_result();\r\n\r\nwhile($row = $result->fetch_array(MYSQLI_ASSOC)){\r\n var_dump($row);\r\n}<\/pre>\nDELETE<\/h3>\n
$stmt = $mysqli->prepare(\"\r\n DELETE FROM test_table \r\n WHERE id = ?\r\n\");\r\n\r\n$id = 1;\r\n\r\n$stmt->bind_param('i', $id);\r\n\r\n$res = $stmt->execute();\r\n$stmt->close();<\/pre>\n<\/p>\n
\u89e3\u8aac\u7b49<\/h2>\n
bind_param<\/h3>\n
\u7b2c1\u5f15\u6570\u306b\u30d0\u30a4\u30f3\u30c9\u5909\u6570\u306e\u578b\u3092\u8a18\u8ff0\u3059\u308b\u5fc5\u8981\u3042\u308a\u3002\u578b\u6307\u5b9a\u6587\u5b57\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3002<\/p>\n
\n
- i \u2192 int<\/li>\n
- d \u2192 float<\/li>\n
- s \u2192 string<\/li>\n
- b \u2192 blob<\/li>\n<\/ul>\n
\u30d0\u30a4\u30f3\u30c9\u3059\u308b\u5909\u6570\u304c\u300c\u6587\u5b57\u5217\u3001\u6570\u5024\u3001\u6587\u5b57\u5217\u300d\u306e\u5834\u5408\u306f\u300csis\u300d\u306e\u3088\u3046\u306b\u8a18\u8ff0\u3059\u308b\u3002<\/p>\n
\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9\u306f\u3053\u3061\u3089<\/a>\u3002<\/p>\n
execute<\/h3>\n
\u30d7\u30ea\u30da\u30a2\u30c9\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u5b9f\u884c\u3002\u6210\u5426\u306b\u3088\u308a\u623b\u308a\u5024\u304ctrue \/ false\u306b\u306a\u308b\u306e\u3067\u30a8\u30e9\u30fc\u30c1\u30a7\u30c3\u30af\u306e\u969b\u306f\u300cif( $stmt->execute() )\u300d\u3068\u304b\u306b\u306a\u308a\u305d\u3046\u3002<\/p>\n
\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9\u306f\u3053\u3061\u3089<\/a>\u3002<\/p>\n
<\/p>\n
\u30a8\u30e9\u30fc\u5bfe\u5fdc<\/h2>\n
Fatal error: Uncaught mysqli_sql_exception: Unknown column 'xxx' in 'field list' in<\/h3>\n
(\u30ab\u30e9\u30e0\u540d\u304c\u9593\u9055\u3063\u3066\u3044\u308b\u7b49\u3067)\u30ab\u30e9\u30e0\u304c\u898b\u3064\u304b\u3089\u306a\u3044\u5834\u5408\u306b\u767a\u751f\u3059\u308b\u30a8\u30e9\u30fc\u3002\u4f8b\u3048\u3070\u3060\u3051\u3069\u4eca\u56de\u306e\u5834\u5408\u300cscore\u300d\u3068\u3044\u3046\u30ab\u30e9\u30e0\u3092\u300cpoint\u300d\u3068\u304b\u3067\u66f8\u3044\u3061\u3083\u3046\u3068\u30a8\u30e9\u30fc\u3002<\/p>\n
\u30ab\u30e9\u30e0\u540d\u306b\u9593\u9055\u3044\u304c\u7121\u3044\u304b\u78ba\u8a8d\u3059\u308b\u3053\u3068\u3002<\/p>\n
Fatal error: Uncaught mysqli_sql_exception: Column count doesn't match value count at row<\/h3>\n
\u30d0\u30a4\u30f3\u30c9\u5909\u6570\u3068\u30ab\u30e9\u30e0\u6570\u304c\u5408\u308f\u306a\u3044\u5834\u5408\u306b\u767a\u751f\u3059\u308b\u30a8\u30e9\u30fc\u3002\u3069\u3061\u3089\u304b\u306b\u629c\u3051\u304c\u7121\u3044\u304b\u78ba\u8a8d\u3059\u308b\u3053\u3068\u3002<\/p>\n
<\/p>\n
\u30d7\u30ea\u30da\u30a2\u30c9\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u30e1\u30ea\u30c3\u30c8<\/h2>\n
\u30a8\u30b9\u30b1\u30fc\u30d7\u304c\u4e0d\u8981<\/h3>\n