- \n
- \u7591\u4f3c\u500b\u4eba\u60c5\u5831\u30c7\u30fc\u30bf\u751f\u6210\u30b5\u30fc\u30d3\u30b9<\/a>
DB\u306b\u5165\u308c\u308b\u30c0\u30df\u30fc\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3059\u308b\u306e\u306b\u5f79\u7acb\u3064\u3002<\/li>\n\n\n\n- MySQL :: MySQL 8.0 \u30ea\u30d5\u30a1\u30ec\u30f3\u30b9\u30de\u30cb\u30e5\u30a2\u30eb :: 13.2.7 LOAD DATA \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8<\/a>
load data \u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u6642\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u78ba\u8a8d\u306b\u5f79\u7acb\u3064\u3002\u6587\u5b57\u5217\u3092\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u7b49\u3067\u56f2\u3093\u3067\u3044\u305f\u3089\u8ffd\u52a0\u30aa\u30d7\u30b7\u30e7\u30f3\u5fc5\u8981\u3002<\/li>\n<\/ul>\n\n\n\n\u30c6\u30b9\u30c8\u7528\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210<\/h2>\n\n\n\n
\u53c2\u8003Web\u30da\u30fc\u30b8\u304b\u3089\u3001\u3053\u3093\u306a\u611f\u3058\u306e\u30c0\u30df\u30fc\u30c7\u30fc\u30bf\u306eCSV\u3092\u53d6\u5f97\u3059\u308b\u3002<\/p>\n\n\n
\n1,\u690d\u6728\u91cc\u5948,\u30a6\u30a8\u30ad\u30ea\u30ca,\u5973,0844385187,1964\/05\/14\n2,\u5800\u4e95\u5eb7\u6b63,\u30db\u30ea\u30a4\u30e4\u30b9\u30de\u30b5,\u7537,0757176326,1982\/07\/23\n3,\u6c38\u5cf6\u5b89\u7537,\u30ca\u30ac\u30b7\u30de\u30e4\u30b9\u30aa,\u7537,0879535416,2000\/03\/20\n4,\u9ad8\u7530\u5eb7\u5584,\u30b3\u30a6\u30c0\u30e4\u30b9\u30e8\u30b7,\u7537,0188902927,1976\/06\/19\n5,\u7af9\u672c\u4e00\u78e8,\u30bf\u30b1\u30e2\u30c8\u30ab\u30ba\u30de,\u7537,0942815128,2000\/11\/25\n6,\u8302\u6728\u51a8\u58eb\u5b50,\u30e2\u30ae\u30d5\u30b8\u30b3,\u5973,0442779966,1989\/11\/20\n7,\u4e2d\u5c71\u5b5d\u7537,\u30ca\u30ab\u30e4\u30de\u30bf\u30ab\u30aa,\u7537,0744082304,1984\/09\/21\n8,\u77e2\u6ca2\u7fd4\u5b50,\u30e4\u30b6\u30ef\u30b7\u30e7\u30a6\u30b3,\u5973,0998049457,1965\/07\/18\n9,\u5c71\u4e2d\u826f\u548c,\u30e4\u30de\u30ca\u30ab\u30e8\u30b7\u30ab\u30ba,\u7537,0292720584,1965\/10\/18\n10,\u571f\u8c37\u559c\u5e02,\u30c4\u30c1\u30e4\u30ad\u30a4\u30c1,\u7537,0276788454,1999\/01\/24\n<\/pre><\/div>\n\n\n
PowerShell\u304b\u3089mysql\u30b3\u30de\u30f3\u30c9\u3092\u5229\u7528\u3057\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u3001
use \u30b3\u30de\u30f3\u30c9\u3067\uff08\u6587\u5b57\u30a8\u30f3\u30b3\u30fc\u30c9\u304cUTF-8\u306b\u306a\u3063\u3066\u3044\u308b\uff09DB\u3078\u63a5\u7d9a\u3057\u3001
\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3002<\/p>\n\n\n\n> create table DBTest (id int primary key auto_increment, name_kanji varchar(255) not null, name_katakana varchar(255) not null, sex char(1) default '\u7537', tel varchar(255) not null, birthday date not null);\n<\/pre><\/div>\n\n\n
\u78ba\u8a8d\u306e\u305f\u3081\u306b\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001<\/p>\n\n\n
\n> show fields from DBTest;\n<\/pre><\/div>\n\n\n
\u6b21\u306e\u3088\u3046\u306b\u8868\u793a\u3055\u308c\u308b\u3002<\/p>\n\n\n
\n+---------------+--------------+------+-----+---------+----------------+\n| Field | Type | Null | Key | Default | Extra |\n+---------------+--------------+------+-----+---------+----------------+\n| id | int(11) | NO | PRI | NULL | auto_increment |\n| name_kanji | varchar(255) | NO | | NULL | |\n| name_katakana | varchar(255) | NO | | NULL | |\n| sex | char(1) | YES | | \u7537 | |\n| tel | varchar(255) | NO | | NULL | |\n| birthday | date | YES | | NULL | |\n+---------------+--------------+------+-----+---------+----------------+\n6 rows in set (0.016 sec)\n<\/pre><\/div>\n\n\n
\u30c0\u30df\u30fc\u30c7\u30fc\u30bf\u3092DBTest\u30c6\u30fc\u30d6\u30eb\u3078\u633f\u5165\u3059\u308b\u305f\u3081\u306b\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3002<\/p>\n\n\n
\n> load data local infile 'CSV\u30d5\u30a1\u30a4\u30eb\u306e\u7d76\u5bfe\u30d1\u30b9\u3002\\\u8a18\u53f7\u306f\\\\\u3068\u30a8\u30b9\u30b1\u30fc\u30d7\u51e6\u7406\u304c\u5fc5\u8981' into table DBTest fields terminated by ',';\n<\/pre><\/div>\n\n\n
\u30c0\u30df\u30fc\u30c7\u30fc\u30bf\u304c\u633f\u5165\u3055\u308c\u305f\u3053\u3068\u3092\u78ba\u8a8d\u3059\u308b\u305f\u3081\u306b\u3001\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001<\/p>\n\n\n
\n> select * from DBTest;\n<\/pre><\/div>\n\n\n
\u6b21\u306e\u3088\u3046\u306b\u8868\u793a\u3055\u308c\u3066\u3001\u7121\u4e8b\u633f\u5165\u3067\u304d\u305f\u3053\u3068\u3092\u78ba\u8a8d\u3067\u304d\u308b\u3002<\/p>\n\n\n
\n+----+------------+------------------+------+------------+------------+\n| id | name_kanji | name_katakana | sex | tel | birthday |\n+----+------------+------------------+------+------------+------------+\n| 1 | \u690d\u6728\u91cc\u5948 | \u30a6\u30a8\u30ad\u30ea\u30ca | \u5973 | 0844385187 | 1964-05-14 |\n| 2 | \u5800\u4e95\u5eb7\u6b63 | \u30db\u30ea\u30a4\u30e4\u30b9\u30de\u30b5 | \u7537 | 0757176326 | 1982-07-23 |\n| 3 | \u6c38\u5cf6\u5b89\u7537 | \u30ca\u30ac\u30b7\u30de\u30e4\u30b9\u30aa | \u7537 | 0879535416 | 2000-03-20 |\n| 4 | \u9ad8\u7530\u5eb7\u5584 | \u30b3\u30a6\u30c0\u30e4\u30b9\u30e8\u30b7 | \u7537 | 0188902927 | 1976-06-19 |\n| 5 | \u7af9\u672c\u4e00\u78e8 | \u30bf\u30b1\u30e2\u30c8\u30ab\u30ba\u30de | \u7537 | 0942815128 | 2000-11-25 |\n| 6 | \u8302\u6728\u51a8\u58eb\u5b50 | \u30e2\u30ae\u30d5\u30b8\u30b3 | \u5973 | 0442779966 | 1989-11-20 |\n| 7 | \u4e2d\u5c71\u5b5d\u7537 | \u30ca\u30ab\u30e4\u30de\u30bf\u30ab\u30aa | \u7537 | 0744082304 | 1984-09-21 |\n| 8 | \u77e2\u6ca2\u7fd4\u5b50 | \u30e4\u30b6\u30ef\u30b7\u30e7\u30a6\u30b3 | \u5973 | 0998049457 | 1965-07-18 |\n| 9 | \u5c71\u4e2d\u826f\u548c | \u30e4\u30de\u30ca\u30ab\u30e8\u30b7\u30ab\u30ba | \u7537 | 0292720584 | 1965-10-18 |\n| 10 | \u571f\u8c37\u559c\u5e02 | \u30c4\u30c1\u30e4\u30ad\u30a4\u30c1 | \u7537 | 0276788454 | 1999-01-24 |\n+----+------------+------------------+------+------------+------------+\n<\/pre><\/div>\n\n\n
\u52d5\u4f5c\u78ba\u8a8d\u7528\u30b3\u30fc\u30c9<\/h2>\n\n\n\n
\u6982\u8981<\/h3>\n\n\n\n
\u6b21\u306e3\u70b9\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u9069\u5b9c\u914d\u7f6e\u3057\u3066\u3001Web\u30d6\u30e9\u30a6\u30b6\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3057\u3001
\u5834\u5408\u306b\u3088\u3063\u3066\u306fPowerShell\u306emysql\u30b3\u30de\u30f3\u30c9\u304b\u3089SELECT\u6587\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u3067\u78ba\u8a8d\u3067\u304d\u308b\u3002<\/p>\n\n\n\nDBTest.php<\/h3>\n\n\n
\n<?php\n\/\/ DB\u306e\u7a2e\u985e\u3001DB\u540d\u3001DB\u30b5\u30fc\u30d0\u306eIP\u30a2\u30c9\u30ec\u30b9\u3001\u6587\u5b57\u30a8\u30f3\u30b3\u30fc\u30c9\u3092\u6307\u5b9a\u3002\n$dsn = 'mysql:dbname=selfphp; host=127.0.0.1; charset=utf8';\n\/\/ DB\u306e\u30e6\u30fc\u30b6\u540d\u3002\n$usr = 'selfusr';\n\/\/ \u4e0a\u8a18DB\u30e6\u30fc\u30b6\u540d\u3067\u30ed\u30b0\u30a4\u30f3\u3059\u308b\u6642\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3002\n$passwd = 'selfpass';\n?>\n\n<!DOCTYPE HTML>\n<html>\n <head>\n <meta charset="UTF-8">\n <title>DBTest.php<\/title>\n <\/head>\n <body>\n <?php\n try {\n \/\/ DB\u62bd\u8c61\u5316\u3092\u62c5\u5f53\u3059\u308bPDO\u30af\u30e9\u30b9\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u751f\u6210\u3002\n $db = new PDO($dsn, $usr, $passwd);\n\n \/\/ \u4f8b\u5916\u3092\u767a\u751f\u3055\u305b\u308b\u3053\u3068\u3067\u30a8\u30e9\u30fc\u3092\u901a\u77e5\u3059\u308b\u3088\u3046\u8a2d\u5b9a\u3002PHP\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u898f\u5b9a\u304c\u9055\u3046\u3089\u3057\u3044\u306e\u3067\u5ff5\u306e\u305f\u3081\u6307\u5b9a\u3002\n $db -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\n\n \/\/ \u6301\u7d9a\u7684\u63a5\u7d9a\u3092\u6709\u52b9\u306b\u3059\u308b\u3053\u3068\u3067\u3001\u30a2\u30af\u30bb\u30b9\u6570\u304c\u591a\u3044\u30b5\u30a4\u30c8\u3067\u306f\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6539\u5584\u304c\u671f\u5f85\u3067\u304d\u308b\u3002\n \/\/ \u6301\u7d9a\u7684\u63a5\u7d9a\u306f\u30b9\u30af\u30ea\u30d7\u30c8\u304c\u7d42\u4e86\u3057\u3066\u3082\u3001DB\u3078\u306e\u63a5\u7d9a\u304c\u7dad\u6301\u3055\u308c\u3001\n \/\/ \u4ed6\u304b\u3089\u8981\u6c42\u304c\u3042\u3063\u305f\u5834\u5408\u306b\u306f\u3001\u7dad\u6301\u3055\u308c\u305f\u63a5\u7d9a\u3092\u518d\u5229\u7528\u3059\u308b\u63a5\u7d9a\u306e\u3053\u3068\u3002\n \/\/ \u6301\u7d9a\u7684\u63a5\u7d9a\u3092\u6709\u52b9\u306b\u3059\u308b\u306b\u306f\u3001\u4e0b\u8a181\u884c\u3067\u53ef\u80fd\u3002\u307e\u305f\u306fPDO\u30af\u30e9\u30b9\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u751f\u6210\u6642\u306b\u6307\u5b9a\u53ef\u80fd\u3002\n $db -> setAttribute(PDO::ATTR_PERSISTENT, true);\n\n \/\/ PDO\u30af\u30e9\u30b9\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u751f\u6210 = DB\u3078\u63a5\u7d9a\u5b8c\u4e86\u306a\u306e\u3067\u3001\u7d50\u679c\u3092\u8868\u793a\u3002\n print('<b>\u63a5\u7d9a\u306b\u6210\u529f\u3057\u307e\u3057\u305f<\/b><br><br>');\n\n \/\/ \u4e0d\u6b63\u306aSQL\u6587\u3067\u3001\u308f\u3056\u3068\u30a8\u30e9\u30fc\u3092\u8868\u793a\u3055\u305b\u308b\u3002\n $db -> exec('aiueo');\n \n } catch (PDOException $e) {\n \/\/ errorInfo\u306b\u62e1\u5f35\u30a8\u30e9\u30fc\u60c5\u5831\u304c\u5165\u3063\u3066\u3044\u308b\u3002\n \/\/ \u8981\u7d200\u306b\u3001ANSI SQL92 SQLSTATE\u306e\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\u304c\u5165\u3063\u3066\u3044\u308b\u3002\n \/\/ \u6b63\u5e38\u7d42\u4e86\u306a\u3089000000\u306e\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\u3002\n \/\/ \u305d\u306e\u4ed6\u306e\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\u306f\u3001\u300cANSI SQL92 SQLSTATE\u300d\u3067\u691c\u7d22\u3059\u308c\u3070\u51fa\u3066\u304f\u308b\u3002\n print("\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\uff1a{$e -> errorInfo[0]}<br>");\n\n \/\/ \u8981\u7d201\u306b\u3001\u30c9\u30e9\u30a4\u30d0\u56fa\u6709\u306e\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\u304c\u5165\u3063\u3066\u3044\u308b\u3002\n print("\u30c9\u30e9\u30a4\u30d0\u56fa\u6709\u306e\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\uff1a{$e -> errorInfo[1]}<br>");\n\n \/\/ \u8981\u7d202\u306b\u3001\u30c9\u30e9\u30a4\u30d0\u56fa\u6709\u306e\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u5165\u3063\u3066\u3044\u308b\u3002\n print("\u30c9\u30e9\u30a4\u30d0\u56fa\u6709\u306e\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\uff1a{$e -> errorInfo[2]}<br><br>");\n\n \/\/ \u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8868\u793a\u3059\u308b\u3002\n \/\/ die("<b>\u63a5\u7d9a\u30a8\u30e9\u30fc\uff1a{$e -> getMessage()}<\/b><br><br>");\n print("<b>\u63a5\u7d9a\u30a8\u30e9\u30fc\uff1a{$e -> getMessage()}<\/b><br><br>");\n \n } finally {\n $db = null;\n }\n ?>\n <hr>\n <br>\n <b>\u30c7\u30fc\u30bf\u3092\u767b\u9332\u3059\u308b\u305f\u3081\u306e\u30d5\u30a9\u30fc\u30e0<\/b><br>\n <form method="post" action="DBTest2.php">\n <label for="name_kanji">\u540d\u524d\uff08\u6f22\u5b57\uff09<\/label><br>\n <input id="name_kanji" type="text" name="f_name_kanji"><br>\n <br>\n <label for="name_katakana">\u540d\u524d\uff08\u30ab\u30bf\u30ab\u30ca\uff09<\/label><br>\n <input id="name_katakana" type="text" name="f_name_katakana"><br>\n <br>\n <label>\u6027\u5225<\/label><br>\n <input type="radio" name="f_sex" value="\u7537" checked>\u7537\n <input type="radio" name="f_sex" value="\u5973">\u5973\n <br><br>\n <label for="tel">\u96fb\u8a71\u756a\u53f7\uff08\u6570\u5024\u306e\u307f\uff09<\/label><br>\n <input id="tel" type="text" name="f_tel"><br>\n <br>\n <label for="birthday">\u8a95\u751f\u65e5<\/label><br>\n \u897f\u66a6<input id="birthday" type="text" name="f_birthday1">\u5e74 \n <input type="text" name="f_birthday2">\u6708 \n <input type="text" name="f_birthday3">\u65e5<br>\n <br><br>\n <input type="submit" value="\u767b\u9332">\n <\/form>\n <\/body>\n<\/html>\n<\/pre><\/div>\n\n\nDBTest2.php<\/h3>\n\n\n
\n<?php\n\/\/ DB\u306e\u7a2e\u985e\u3001DB\u540d\u3001DB\u30b5\u30fc\u30d0\u306eIP\u30a2\u30c9\u30ec\u30b9\u3001\u6587\u5b57\u30a8\u30f3\u30b3\u30fc\u30c9\u3092\u6307\u5b9a\u3002\n$dsn = 'mysql:dbname=selfphp; host=127.0.0.1; charset=utf8';\n\/\/ DB\u306e\u30e6\u30fc\u30b6\u540d\u3002\n$usr = 'selfusr';\n\/\/ \u4e0a\u8a18DB\u30e6\u30fc\u30b6\u540d\u3067\u30ed\u30b0\u30a4\u30f3\u3059\u308b\u6642\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3002\n$passwd = 'selfpass';\n?>\n\n<!DOCTYPE HTML>\n<html>\n <head>\n <meta charset="UTF-8">\n <title>DBTest2.php<\/title>\n <\/head>\n <body>\n <?php\n try {\n \/\/ PDO\u30af\u30e9\u30b9\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u751f\u6210\u6642\u306b\u4f7f\u7528\u3059\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u95a2\u9023\u306e\u914d\u5217\u3002\n $pdo_options = [\n 'ATTR_ERRMODE' => 'PDO::ERRMODE_EXCEPTION',\n 'ATTR_PERSISTENT' => true,\n ];\n\n \/\/ PDO\u30af\u30e9\u30b9\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u751f\u6210\u3002\n $db = new PDO($dsn, $usr, $passwd, $pdo_options);\n\n \/\/ PDO\u30af\u30e9\u30b9\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u751f\u6210 = DB\u3078\u63a5\u7d9a\u5b8c\u4e86\u306a\u306e\u3067\u3001\u7d50\u679c\u3092\u8868\u793a\u3002\n print('<b>\u63a5\u7d9a\u306b\u6210\u529f\u3057\u307e\u3057\u305f<\/b><br><br>');\n\n \/\/ INSERT\u30b3\u30de\u30f3\u30c9\u306e\u6e96\u5099\u3002\n $stt = $db -> prepare(\n 'INSERT INTO DBTest(name_kanji, name_katakana, sex, tel, birthday) VALUES(:name_kanji, :name_katakana, :sex, :tel, :birthday)'\n );\n\n \/\/ POST\u5185\u5bb9\u78ba\u8a8d\u306e\u305f\u3081\u306e\u51fa\u529b\u3002\n print("f_name_kanji : {$_POST['f_name_kanji']}<br>");\n print("f_name_katakana : {$_POST['f_name_katakana']}<br>");\n print("f_sex : {$_POST['f_sex']}<br>");\n print("f_tel : {$_POST['f_tel']}<br>");\n print("f_birthday1 : {$_POST['f_birthday1']}<br>");\n print("f_birthday2 : {$_POST['f_birthday2']}<br>");\n print("f_birthday3 : {$_POST['f_birthday3']}<br>");\n\n \/\/ \u540d\u524d\u4ed8\u304d\u30d1\u30e9\u30e1\u30fc\u30bf\u3067\u306e\u30d7\u30ec\u30a4\u30b9\u30db\u30eb\u30c0\u30fc\u3092\u5229\u7528\u3057\u3066\u3001INSERT\u30b3\u30de\u30f3\u30c9\u306bPOST\u30c7\u30fc\u30bf\u306e\u5185\u5bb9\u3092\u30bb\u30c3\u30c8\u3002\n \/\/ \u540d\u524d\u7121\u3057\u30d1\u30e9\u30e1\u30fc\u30bf\u306f\u300c?\u300d\u3092\u57cb\u8fbc\u5148\u306b\u4f7f\u3044\u3001\u57cb\u3081\u8fbc\u3080\u6642\u306b\u306f\u6570\u5024\u3067\u6307\u5b9a\u3059\u308b\u3002\n $stt -> bindValue(':name_kanji', $_POST['f_name_kanji']);\n $stt -> bindValue(':name_katakana', $_POST['f_name_katakana']);\n $stt -> bindValue(':sex', $_POST['f_sex']);\n $stt -> bindValue(':tel', $_POST['f_tel']);\n $stt -> bindValue(':birthday', $_POST['f_birthday1'] . '\/' . $_POST['f_birthday2'] . '\/' . $_POST['f_birthday3']);\n\n \/\/ \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u958b\u59cb\u3002\n $db -> beginTransaction();\n\n \/\/ INSERT\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3002\n $stt -> execute();\n\n \/\/ \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3092\u30b3\u30df\u30c3\u30c8\u3002\n $db -> commit();\n\n \/\/ INSERT\u30b3\u30de\u30f3\u30c9\u304c\u6210\u529f\u3057\u305f\u3053\u3068\u3092\u8868\u793a\u3002\n print("<b>INSERT\u30b3\u30de\u30f3\u30c9\u6210\u529f<\/b><br><br>");\n\n \/\/ \u6700\u5f8c\u306b\u5b9f\u884c\u3057\u305fINSERT\u30b3\u30de\u30f3\u30c9\u3067\u4f7f\u308f\u308c\u305f\u30aa\u30fc\u30c8\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u306e\u5024\u3092\u8868\u793a\u3002\n print("\u6700\u5f8c\u306eID\u5024\uff1a{$db -> lastInsertId()}<br><br>");\n\n } catch (PDOException $e) {\n \/\/ errorInfo\u306b\u62e1\u5f35\u30a8\u30e9\u30fc\u60c5\u5831\u304c\u5165\u3063\u3066\u3044\u308b\u3002\n \/\/ \u8981\u7d200\u306b\u3001ANSI SQL92 SQLSTATE\u306e\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\u304c\u5165\u3063\u3066\u3044\u308b\u3002\n \/\/ \u6b63\u5e38\u7d42\u4e86\u306a\u3089000000\u306e\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\u3002\n \/\/ \u305d\u306e\u4ed6\u306e\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\u306f\u3001\u300cANSI SQL92 SQLSTATE\u300d\u3067\u691c\u7d22\u3059\u308c\u3070\u51fa\u3066\u304f\u308b\u3002\n print("\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\uff1a{$e -> errorInfo[0]}<br>");\n\n \/\/ \u8981\u7d201\u306b\u3001\u30c9\u30e9\u30a4\u30d0\u56fa\u6709\u306e\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\u304c\u5165\u3063\u3066\u3044\u308b\u3002\n print("\u30c9\u30e9\u30a4\u30d0\u56fa\u6709\u306e\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\uff1a{$e -> errorInfo[1]}<br>");\n\n \/\/ \u8981\u7d202\u306b\u3001\u30c9\u30e9\u30a4\u30d0\u56fa\u6709\u306e\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u5165\u3063\u3066\u3044\u308b\u3002\n print("\u30c9\u30e9\u30a4\u30d0\u56fa\u6709\u306e\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\uff1a{$e -> errorInfo[2]}<br><br>");\n\n \/\/ \u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8868\u793a\u3059\u308b\u3002\n \/\/ die("<b>\u63a5\u7d9a\u30a8\u30e9\u30fc\uff1a{$e -> getMessage()}<\/b><br><br>");\n print("<b>\u63a5\u7d9a\u30a8\u30e9\u30fc\uff1a{$e -> getMessage()}<\/b><br><br>");\n \n } finally {\n $db = null;\n }\n ?>\n <hr>\n <\/body>\n<\/html>\n<\/pre><\/div>\n\n\nDBTest3.php<\/h3>\n\n\n
\n<?php\n\/\/ DB\u306e\u7a2e\u985e\u3001DB\u540d\u3001DB\u30b5\u30fc\u30d0\u306eIP\u30a2\u30c9\u30ec\u30b9\u3001\u6587\u5b57\u30a8\u30f3\u30b3\u30fc\u30c9\u3092\u6307\u5b9a\u3002\n$dsn = 'mysql:dbname=selfphp; host=127.0.0.1; charset=utf8';\n\/\/ DB\u306e\u30e6\u30fc\u30b6\u540d\u3002\n$usr = 'selfusr';\n\/\/ \u4e0a\u8a18DB\u30e6\u30fc\u30b6\u540d\u3067\u30ed\u30b0\u30a4\u30f3\u3059\u308b\u6642\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3002\n$passwd = 'selfpass';\n\/\/ DB\u304b\u3089\u53d6\u5f97\u3057\u305f1\u4eba\u5206\u306e\u30c7\u30fc\u30bf\u304c\u5165\u308b\u30af\u30e9\u30b9\u3002 \nclass Member {\n public $id;\n public $name_kanji;\n public $name_katakana;\n public $sex;\n public $tel;\n public $birthday;\n}\n?>\n\n<!DOCTYPE HTML>\n<html>\n <head>\n <meta charset="UTF-8">\n <title>DBTest3.php<\/title>\n <\/head>\n <body>\n <?php\n try {\n \/\/ PDO\u30af\u30e9\u30b9\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u751f\u6210\u6642\u306b\u4f7f\u7528\u3059\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u95a2\u9023\u306e\u914d\u5217\u3002\n $pdo_options = [\n \/\/ \u30a8\u30e9\u30fc\u304c\u3042\u308c\u3070\u4f8b\u5916\u3092\u767a\u751f\u3055\u305b\u308b\u3088\u3046\u306b\u6307\u5b9a\u3002\n 'ATTR_ERRMODE' => 'PDO::ERRMODE_EXCEPTION',\n \/\/ \u6301\u7d9a\u7684\u63a5\u7d9a\u3092ON\u306b\u6307\u5b9a\u3002\n 'ATTR_PERSISTENT' => true,\n ];\n\n \/\/ PDO\u30af\u30e9\u30b9\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u751f\u6210\u3002\n $db = new PDO($dsn, $usr, $passwd, $pdo_options);\n\n \/\/ PDO\u30af\u30e9\u30b9\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u751f\u6210 = DB\u3078\u63a5\u7d9a\u5b8c\u4e86\u306a\u306e\u3067\u3001\u7d50\u679c\u3092\u8868\u793a\u3002\n print('<b>\u63a5\u7d9a\u306b\u6210\u529f\u3057\u307e\u3057\u305f<\/b><br><br>');\n\n \/\/ SELECT\u30b3\u30de\u30f3\u30c9\u306e\u6e96\u5099\u3002\n $stt = $db -> prepare('SELECT * FROM dbtest');\n\n \/\/ SELECT\u30b3\u30de\u30f3\u30c9\u306e\u5b9f\u884c\u3002\n $stt -> execute();\n\n print("<b>fetch(PDO::FETCH_ASSOC)\u3092\u5229\u7528\u3057\u3066\u8868\u793a<\/b><br>");\n while($row = $stt -> fetch(PDO::FETCH_ASSOC)) {\n print("{$row['id']} : {$row['name_kanji']} : {$row['name_katakana']} : {$row['sex']} : {$row['tel']} : {$row['birthday']}<br>");\n }\n\n \/\/ \u518d\u5ea6SELECt\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3002\n $stt -> execute();\n print("<br>");\n print("<b>fetchAll(PDO::FETCH_ASSOC)\u3092\u5229\u7528\u3057\u3066print_r\u95a2\u6570\u3067\u8868\u793a<\/b><br>");\n print_r($stt -> fetchAll(PDO::FETCH_ASSOC));\n\n print("<br><br>");\n print("<b>\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u5fdc\u3059\u308b\u30af\u30e9\u30b9\u3092\u4f5c\u6210\u3057\u3001\u305d\u3053\u306b\u60c5\u5831\u3092\u683c\u7d0d<\/b><br>");\n \/\/ \u518d\u5ea6SELECT\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3002\n $stt -> execute();\n\n \/\/ DB\u306e\u60c5\u5831\u3092Member\u30af\u30e9\u30b9\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306b\u683c\u7d0d\u3002\n while ($row = $stt -> fetchObject('Member')) {\n print("ID : {$row -> id} \/ \u540d\u524d\uff08\u6f22\u5b57\uff09 : {$row -> name_kanji} \/ \u540d\u524d\uff08\u30ab\u30bf\u30ab\u30ca\uff09 : {$row -> name_katakana} \/ \u6027\u5225 : {$row -> sex} \/ \u96fb\u8a71\u756a\u53f7 : {$row -> tel} \/ \u8a95\u751f\u65e5 : {$row -> birthday}<br>");\n\n }\n\n } catch (PDOException $e) {\n \/\/ errorInfo\u306b\u62e1\u5f35\u30a8\u30e9\u30fc\u60c5\u5831\u304c\u5165\u3063\u3066\u3044\u308b\u3002\n \/\/ \u8981\u7d200\u306b\u3001ANSI SQL92 SQLSTATE\u306e\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\u304c\u5165\u3063\u3066\u3044\u308b\u3002\n \/\/ \u6b63\u5e38\u7d42\u4e86\u306a\u3089000000\u306e\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\u3002\n \/\/ \u305d\u306e\u4ed6\u306e\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\u306f\u3001\u300cANSI SQL92 SQLSTATE\u300d\u3067\u691c\u7d22\u3059\u308c\u3070\u51fa\u3066\u304f\u308b\u3002\n print("\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\uff1a{$e -> errorInfo[0]}<br>");\n\n \/\/ \u8981\u7d201\u306b\u3001\u30c9\u30e9\u30a4\u30d0\u56fa\u6709\u306e\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\u304c\u5165\u3063\u3066\u3044\u308b\u3002\n print("\u30c9\u30e9\u30a4\u30d0\u56fa\u6709\u306e\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\uff1a{$e -> errorInfo[1]}<br>");\n\n \/\/ \u8981\u7d202\u306b\u3001\u30c9\u30e9\u30a4\u30d0\u56fa\u6709\u306e\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u5165\u3063\u3066\u3044\u308b\u3002\n print("\u30c9\u30e9\u30a4\u30d0\u56fa\u6709\u306e\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\uff1a{$e -> errorInfo[2]}<br><br>");\n\n \/\/ \u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8868\u793a\u3059\u308b\u3002\n \/\/ die("<b>\u63a5\u7d9a\u30a8\u30e9\u30fc\uff1a{$e -> getMessage()}<\/b><br><br>");\n print("<b>\u63a5\u7d9a\u30a8\u30e9\u30fc\uff1a{$e -> getMessage()}<\/b><br><br>");\n \n } finally {\n $db = null;\n }\n ?>\n <hr>\n <\/body>\n<\/html>\n<\/pre><\/div>\n\n\n\u7d50\u679c<\/h2>\n\n\n\n
DBTest.php<\/h3>\n\n\n\n
![\"\"](\"https:\/\/shinke1987.net\/wp-content\/uploads\/2023\/05\/2023-05-27-10.14.41-localhost-c221471a1f82-1024x674.png\")
<\/figure>\n\n\n\nDBTest2.php<\/h3>\n\n\n\n
![\"\"](\"https:\/\/shinke1987.net\/wp-content\/uploads\/2023\/05\/2023-05-27-10.14.52-localhost-6b06fa660d56-1024x542.png\")
<\/figure>\n\n\n\nDBTest3.php<\/h3>\n\n\n\n
![\"\"](\"https:\/\/shinke1987.net\/wp-content\/uploads\/2023\/05\/2023-05-27-10.15.00-localhost-870af35fe93c-965x1024.png\")
<\/figure>\n","protected":false},"excerpt":{"rendered":"\u74b0\u5883 XAMPP for Windows 8.2.4 \u53c2\u8003Web\u30da\u30fc\u30b8 \u30c6\u30b9\u30c8\u7528\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210 \u53c2\u8003Web\u30da\u30fc\u30b8\u304b\u3089\u3001\u3053\u3093\u306a\u611f\u3058\u306e\u30c0\u30df\u30fc\u30c7\u30fc\u30bf\u306eCSV\u3092\u53d6\u5f97\u3059\u308b\u3002 PowerShell\u304b\u3089mysql\u30b3\u30de\u30f3\u30c9\u3092\u5229\u7528\u3057\u30ed\u30b0\u30a4\u30f3 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[80],"tags":[81],"class_list":["post-918","post","type-post","status-publish","format-standard","hentry","category-php","tag-php"],"_links":{"self":[{"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/posts\/918","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/shinke1987.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=918"}],"version-history":[{"count":2,"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/posts\/918\/revisions"}],"predecessor-version":[{"id":923,"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/posts\/918\/revisions\/923"}],"wp:attachment":[{"href":"https:\/\/shinke1987.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/shinke1987.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/shinke1987.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- MySQL :: MySQL 8.0 \u30ea\u30d5\u30a1\u30ec\u30f3\u30b9\u30de\u30cb\u30e5\u30a2\u30eb :: 13.2.7 LOAD DATA \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8<\/a>