{"id":1134,"date":"2020-06-20T11:58:31","date_gmt":"2020-06-20T02:58:31","guid":{"rendered":"https:\/\/beanhouse.org\/wordpress\/?p=1134"},"modified":"2021-09-12T23:56:30","modified_gmt":"2021-09-12T14:56:30","slug":"create-a-simple-search-form","status":"publish","type":"post","link":"https:\/\/beanhouse.org\/wordpress\/?p=1134","title":{"rendered":"\u7c21\u5358\u306a\u691c\u7d22\u30d5\u30a9\u30fc\u30e0\u306e\u5b9f\u88c5\u624b\u9806(PHP\u00d7MySQL)"},"content":{"rendered":"<p class=\"wpwc-reading-time\">\u3053\u306e\u8a18\u4e8b\u306f\u3060\u3044\u305f\u3044 5 \u5206\u307b\u3069\u3067\u8aad\u3081\u307e\u3059\u3002<\/p>\n<p>\u691c\u7d22\u6761\u4ef6\u3092\u5165\u529b\u3057\u3066\u7d50\u679c\u3092\u8868\u793a\u3059\u308b\u7c21\u5358\u306a\u691c\u7d22\u30d5\u30a9\u30fc\u30e0\u3092PHP\u3068MySQL\u3067\u4f5c\u3063\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u78ba\u8a8d\u3057\u305f\u74b0\u5883<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>OS Windows10<\/li><li>XAMPP ver.7.4.6<\/li><\/ul>\n\n\n\n<p>\u52d5\u304b\u3057\u305f\u4eba<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>PHP\u521d\u5fc3\u8005<\/li><li>\u30a8\u30f3\u30b8\u30cb\u30a2\u6b74\uff11\uff10\u6570\u5e74<\/li><li>\u65e2\u5a5a<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"698\" src=\"https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/window-1231894_1920-1024x698.jpg\" alt=\"search\" class=\"wp-image-1151\" srcset=\"https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/window-1231894_1920-1024x698.jpg 1024w, https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/window-1231894_1920-300x204.jpg 300w, https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/window-1231894_1920-768x523.jpg 768w, https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/window-1231894_1920-1536x1046.jpg 1536w, https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/window-1231894_1920.jpg 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\"><p class=\"ez-toc-title\" style=\"cursor:inherit\">\u76ee\u6b21<\/p>\n<\/div><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/beanhouse.org\/wordpress\/?p=1134\/#%E4%BB%95%E6%A7%98\" >\u4ed5\u69d8<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/beanhouse.org\/wordpress\/?p=1134\/#%E5%8B%95%E4%BD%9C%E4%BB%95%E6%A7%98\" >\u52d5\u4f5c\u4ed5\u69d8<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/beanhouse.org\/wordpress\/?p=1134\/#%E3%83%95%E3%82%A9%E3%83%AB%E3%83%80%E6%A7%8B%E6%88%90\" >\u30d5\u30a9\u30eb\u30c0\u69cb\u6210<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/beanhouse.org\/wordpress\/?p=1134\/#%E9%83%A8%E5%93%81%E3%81%9F%E3%81%A1\" >\u90e8\u54c1\u305f\u3061<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/beanhouse.org\/wordpress\/?p=1134\/#headerincphp\" >header.inc.php<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/beanhouse.org\/wordpress\/?p=1134\/#footerincphp\" >footer.inc.php<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/beanhouse.org\/wordpress\/?p=1134\/#dbhincphp\" >dbh.inc.php<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/beanhouse.org\/wordpress\/?p=1134\/#searchformincphp\" >searchform.inc.php<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/beanhouse.org\/wordpress\/?p=1134\/#%E6%9C%AC%E4%BD%93%E9%83%A8%E5%88%86\" >\u672c\u4f53\u90e8\u5206<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/beanhouse.org\/wordpress\/?p=1134\/#indexphp\" >index.php<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/beanhouse.org\/wordpress\/?p=1134\/#%E5%8B%95%E4%BD%9C%E7%A2%BA%E8%AA%8D\" >\u52d5\u4f5c\u78ba\u8a8d<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/beanhouse.org\/wordpress\/?p=1134\/#%E3%81%BE%E3%81%A8%E3%82%81\" >\u307e\u3068\u3081<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%BB%95%E6%A7%98\"><\/span>\u4ed5\u69d8<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8B%95%E4%BD%9C%E4%BB%95%E6%A7%98\"><\/span>\u52d5\u4f5c\u4ed5\u69d8<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u306b\u5165\u529b\u3057\u3066\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u305f\u3089\u3001\u5165\u529b\u3057\u305f\u5024\u3092\u90e8\u5206\u4e00\u81f4\u3067\u691c\u7d22\u3057\u3066\u51fa\u529b\u3059\u308b\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E3%83%95%E3%82%A9%E3%83%AB%E3%83%80%E6%A7%8B%E6%88%90\"><\/span>\u30d5\u30a9\u30eb\u30c0\u69cb\u6210<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\"><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"903\" height=\"437\" src=\"https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/41540d5d1aef1b0fd71ddc594352581b.png\" alt=\"testdb\" class=\"wp-image-1140 size-full\" srcset=\"https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/41540d5d1aef1b0fd71ddc594352581b.png 903w, https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/41540d5d1aef1b0fd71ddc594352581b-300x145.png 300w, https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/41540d5d1aef1b0fd71ddc594352581b-768x372.png 768w\" sizes=\"auto, (max-width: 903px) 100vw, 903px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p>5\u500b\u306e\u30d5\u30a1\u30a4\u30eb\u3067\u69cb\u6210\u3057\u307e\u3057\u305f\u3002<\/p>\n<\/div><\/div>\n\n\n\n<p>\u9806\u756a\u306b\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E9%83%A8%E5%93%81%E3%81%9F%E3%81%A1\"><\/span>\u90e8\u54c1\u305f\u3061<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>include\u30d5\u30a9\u30eb\u30c0\u306e\u4e2d\u306b\u683c\u7d0d\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"headerincphp\"><\/span>header.inc.php<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>html\u306e\u30d8\u30c3\u30c0\u90e8\u5206\u3092\u30b3\u30d4\u30da\u3057\u3066\u4f5c\u6210\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"html\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!DOCTYPE html>\n&lt;html lang=\"jp\">\n\n&lt;head>\n    &lt;meta charset=\"UTF-8\">\n    &lt;meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    &lt;title>\u691c\u7d22\u30d5\u30a9\u30fc\u30e0&lt;\/title>\n&lt;\/head>\n\n&lt;body><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"footerincphp\"><\/span>footer.inc.php<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>html\u306e\u30d5\u30c3\u30bf\u90e8\u5206\u3092\u30b3\u30d4\u30da\u3057\u3066\u4f5c\u6210\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"html\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;\/body>\n\n&lt;\/html><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"dbhincphp\"><\/span>dbh.inc.php<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>MySQL\u306e\u63a5\u7d9a\u90e8\u5206\u306e\u307f\u3092\u8a18\u8ff0<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"php\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;?php\n\n\/\/ php\u304b\u3089MySQL\u306b\u63a5\u7d9a\n\/\/\u30db\u30b9\u30c8\u540d\n$servername = \"localhost\";\n\/\/\u30e6\u30fc\u30b6\u30fc\u540d\n$user = \"root\";\n\/\/\u30d1\u30b9\u30ef\u30fc\u30c9\n$password = \"\";\n\/\/db\u540d\n$dbname = \"testdb\";\n\n\/\/ \u63a5\u7d9a\n$conn = mysqli_connect($servername, $user, $password, $dbname);\n\/\/ \u63a5\u7d9a\u78ba\u8a8d\nif (mysqli_connect_errno()) {\n    die('Connect Error (' . mysqli_connect_errno() . ') '\n        . mysqli_connect_error());\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"searchformincphp\"><\/span>searchform.inc.php<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u691c\u7d22\u3059\u308b\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3068\u30dc\u30bf\u30f3\u90e8\u5206\u3002<\/p>\n\n\n\n<p>POST\u3055\u308c\u305f\u3068\u304d\u306f\u5165\u529b\u3057\u305f\u5024\u304c\u30bb\u30c3\u30c8\u3055\u308c\u308b\u3088\u3046\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"php\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;?php\n\n$value = \"\";\nif (isset($_POST['name'])) {\n    $value = $_POST['name'];\n}\n\necho '&lt;form action=\"search.php\" method=\"POST\">\n        &lt;input type=\"text\" name=\"name\" id=\"name\" placeholder=\"\u304a\u540d\u524d\" value=\"' . $value . '\" >\n        &lt;button type=\"submit\" name=\"search-button\">\u691c\u7d22&lt;\/button>\n    &lt;\/form>';<\/pre>\n\n\n\n<p>\u7d9a\u3044\u3066\u672c\u4f53\u90e8\u5206\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9C%AC%E4%BD%93%E9%83%A8%E5%88%86\"><\/span>\u672c\u4f53\u90e8\u5206<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"indexphp\"><\/span>index.php<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u30d8\u30c3\u30c0\u3092\u8aad\u307f\u8fbc\u3093\u3067\u691c\u7d22\u30d5\u30a9\u30fc\u30e0\u3092\u8aad\u307f\u8fbc\u3093\u3067\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305d\u306e\u6b21\u306b\u691c\u7d22\u30dc\u30bf\u30f3\u304c\u62bc\u3055\u308c\u305f\u304b\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3066\u3001\u62bc\u3055\u308c\u3066\u3044\u308c\u3070\u691c\u7d22\u7d50\u679c\u306e\u51fa\u529b\u51e6\u7406\u3092\u884c\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u6700\u5f8c\u306b\u30d5\u30c3\u30bf\u3092\u8aad\u307f\u8fbc\u3093\u3067\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u307e\u305f\u3001\u95a2\u6570\u3092\u5185\u90e8\u30672\u3064\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"php\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;?php\ninclude_once 'include\/header.inc.php';\ninclude_once 'include\/searchform.inc.php';\n\nif (isset($_POST['search-button'])) {\n    \/\/\u691c\u7d22\u7d50\u679c\u3092\u51fa\u529b\n    getResult();\n}\ninclude_once 'include\/footer.inc.php';\n\n\/\/\u691c\u7d22\u7d50\u679c\nfunction getResult()\n{\n    include_once 'include\/dbh.inc.php';\n    \/\/ \u30bb\u30ec\u30af\u30c8\u6587\u4f5c\u6210\n    $sql = \"SELECT user_id , user_last, user_first, user_age FROM users WHERE user_last like ? OR user_first like ?\";\n    \/\/\u30d0\u30a4\u30f3\u30c9\u5909\u6570\n    $val1 = \"%\" . $_POST['name'] . \"%\";\n    $val2 = \"%\" . $_POST['name'] . \"%\";\n    \/\/ \u30d0\u30a4\u30f3\u30c9\u5909\u6570\u306e\u578b\n    $types = \"ss\";\n    \/\/ \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8ID\u53d6\u5f97\n    $stmt = mysqli_stmt_init($conn);\n    \/\/ SQL\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u5b9f\u884c\u3059\u308b\u6e96\u5099\n    if (!mysqli_stmt_prepare($stmt, $sql)) {\n        echo \"SQL ERROR!\";\n        \/\/ \u63a5\u7d9a\u3092\u9589\u3058\u308b\n        mysqli_close($conn);\n        exit();\n    }\n    \/\/ \u30d1\u30e9\u30e1\u30fc\u30bf\u306b\u30d0\u30a4\u30f3\u30c9\u3059\u308b\n    mysqli_stmt_bind_param($stmt, $types, $val1, $val2);\n    \/\/ \u30af\u30a8\u30ea\u3092\u5b9f\u884c\n    mysqli_stmt_execute($stmt);\n    $result = mysqli_stmt_get_result($stmt);\n    \/\/ \u884c\u6570\u53d6\u5f97\n    $rows = mysqli_num_rows($result);\n    echo \"&lt;h1>\u691c\u7d22\u7d50\u679c&lt;\/h1>\";\n    if ($rows > 0) {\n        echo $rows . \"\u4ef6\u53d6\u5f97\u3057\u307e\u3057\u305f\uff01&lt;hr>\";\n        getTable($result);\n    } else {\n        \/\/\u30c7\u30fc\u30bf\u306a\u3057\n        echo \"\u30d2\u30c3\u30c8\u3057\u307e\u305b\u3093\u3067\u3057\u305f\uff01\";\n        echo \"&lt;hr>\";\n    }\n    echo '&lt;a href=\"index.php\">\u623b\u308b&lt;\/a>';\n    \/\/ \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u9589\u3058\u308b\n    mysqli_stmt_close($stmt);\n    \/\/ \u63a5\u7d9a\u3092\u9589\u3058\u308b\n    mysqli_close($conn);\n}\n\/\/\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\nfunction getTable($result)\n{\n    $fields = mysqli_fetch_fields($result);\n    echo \"&lt;table class='searchtable'>&lt;tr>\";\n    foreach ($fields as $field) {\n        echo \"&lt;th>\" . $field->name . \"&lt;\/th>\";\n    }\n    echo \"&lt;\/tr>\";\n    \/\/ \u5024\u3092\u53d6\u5f97\u3059\u308b\n    while ($row = mysqli_fetch_assoc($result)) {\n        echo \"&lt;tr>\";\n        foreach ($row as $col) {\n            echo \"&lt;td>\" . $col . \"&lt;\/td>\";\n        }\n        echo \"&lt;\/tr>\";\n    }\n    echo \"&lt;\/table>\";\n}<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u5185\u90e8\u95a2\u6570<\/h4>\n\n\n\n<h5 class=\"wp-block-heading\">getResult<\/h5>\n\n\n\n<p>SQL\u6587\u3092\u4f5c\u3063\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>SQL\u6587\u306f\u5165\u529b\u3055\u308c\u305f\u5024\u3092\u90e8\u5206\u4e00\u81f4\u3067\u691c\u7d22\u3059\u308b\u3088\u3046\u306b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u307e\u305f\u3001\u691c\u7d22\u5bfe\u8c61\u306e\u30ab\u30e9\u30e0\u306fuser_last\u3068user_first\u3068\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">getTable<\/h5>\n\n\n\n<p>\u691c\u7d22\u7d50\u679c\u304b\u3089\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p><strong>mysqli_fetch_fields<\/strong>\u304b\u3089\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3092\u53d6\u5f97\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u306e\u30d8\u30c3\u30c0\u306b\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8B%95%E4%BD%9C%E7%A2%BA%E8%AA%8D\"><\/span>\u52d5\u4f5c\u78ba\u8a8d<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u30d6\u30e9\u30a6\u30b6\u306eurl\u306b localhost\/testb\u3068\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\"><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"802\" height=\"263\" src=\"https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/0cd97af26374b13d1ec280f66b05674c.png\" alt=\"searchform1\" class=\"wp-image-1144 size-full\" srcset=\"https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/0cd97af26374b13d1ec280f66b05674c.png 802w, https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/0cd97af26374b13d1ec280f66b05674c-300x98.png 300w, https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/0cd97af26374b13d1ec280f66b05674c-768x252.png 768w\" sizes=\"auto, (max-width: 802px) 100vw, 802px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p class=\"has-normal-font-size\">\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n<\/div><\/div>\n\n\n\n<p>\u691c\u7d22\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n\n\n\n<p>[\u7530]\u3068\u5165\u529b\u3057\u3066\u691c\u7d22\u3002<\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\"><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"309\" height=\"281\" src=\"https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/8d7cd5cd674604cccdeeed770a318a4e.png\" alt=\"searchform2\" class=\"wp-image-1145 size-full\" srcset=\"https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/8d7cd5cd674604cccdeeed770a318a4e.png 309w, https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/8d7cd5cd674604cccdeeed770a318a4e-300x273.png 300w\" sizes=\"auto, (max-width: 309px) 100vw, 309px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p>\u691c\u7d22\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>user_last\u3067\u691c\u7d22\u3055\u308c\u3066\u3044\u308b\u3088\u3046\u3067\u3059\u3002<\/p>\n<\/div><\/div>\n\n\n\n<p>\u7d9a\u3044\u3066[\u4fe1]\u3068\u5165\u529b\u3057\u3066\u691c\u7d22\u3002<\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\"><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"290\" height=\"302\" src=\"https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/bdd1cd5a796d31f0f3fb8fb337e94ff4.png\" alt=\"searchform3\" class=\"wp-image-1146 size-full\" srcset=\"https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/bdd1cd5a796d31f0f3fb8fb337e94ff4.png 290w, https:\/\/beanhouse.org\/wordpress\/wp-content\/uploads\/2020\/06\/bdd1cd5a796d31f0f3fb8fb337e94ff4-288x300.png 288w\" sizes=\"auto, (max-width: 290px) 100vw, 290px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p>\u3044\u3051\u3066\u308b\u611f\u3058\u3067\u3059\u3002<\/p>\n\n\n\n<p>user_first\u3067\u691c\u7d22\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E3%81%BE%E3%81%A8%E3%82%81\"><\/span>\u307e\u3068\u3081<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u7c21\u5358\u306a\u691c\u7d22\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u30d0\u30a4\u30f3\u30c9\u5909\u6570\u3092\u4f7f\u7528\u3057\u3066\u691c\u7d22\u3059\u308b\u90e8\u5206\u3067\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u66f8\u304d\u65b9\u304c\u30dd\u30a4\u30f3\u30c8\u304b\u306a\u3068\u601d\u3044\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u4eca\u56de\u4f7f\u7528\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u4ee5\u524d\u6295\u7a3f\u3057\u305f\u8a18\u4e8b\u3067\u4f5c\u6210\u3057\u305f\u3082\u306e\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002&gt;&gt;\u3010phpMyAdmin\u3011SQL\u6587\u3092\u4f7f\u3063\u3066\u30ec\u30b3\u30fc\u30c9\u306e\u4f5c\u6210\u30fb\u524a\u9664\u30fb\u66f4\u65b0\u3092\u3057\u3066\u307f\u308b<\/p>\n\n\n\n<p>\u304a\u308f\u308a\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u306e\u8a18\u4e8b\u306f\u3060\u3044\u305f\u3044 5 \u5206\u307b\u3069\u3067\u8aad\u3081\u307e\u3059\u3002 \u691c\u7d22\u6761\u4ef6\u3092\u5165\u529b\u3057\u3066\u7d50\u679c\u3092\u8868\u793a\u3059\u308b\u7c21\u5358\u306a\u691c\u7d22\u30d5\u30a9\u30fc\u30e0\u3092PHP\u3068MySQL\u3067\u4f5c\u3063\u3066\u307f\u307e\u3057\u305f\u3002 \u78ba\u8a8d\u3057\u305f\u74b0\u5883 OS Windows10XAMPP ver.7.4. &#8230; <\/p>\n","protected":false},"author":1,"featured_media":1151,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[110],"tags":[94,86,63,80],"class_list":["post-1134","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","tag-mysql","tag-php","tag-programming","tag-memorandum"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/beanhouse.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1134","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/beanhouse.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beanhouse.org\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beanhouse.org\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/beanhouse.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1134"}],"version-history":[{"count":15,"href":"https:\/\/beanhouse.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1134\/revisions"}],"predecessor-version":[{"id":2609,"href":"https:\/\/beanhouse.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1134\/revisions\/2609"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beanhouse.org\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1151"}],"wp:attachment":[{"href":"https:\/\/beanhouse.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1134"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beanhouse.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1134"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beanhouse.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1134"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}