{"id":1923,"date":"2014-09-12T17:17:14","date_gmt":"2014-09-12T08:17:14","guid":{"rendered":"http:\/\/taitan916.info\/blog\/?p=1923"},"modified":"2024-04-18T15:27:50","modified_gmt":"2024-04-18T06:27:50","slug":"post-1923","status":"publish","type":"post","link":"https:\/\/taitan916.info\/blog\/archives\/1923","title":{"rendered":"PHP\u3068SQLite\u3067\u7c21\u6613BBS\u306e\u4f5c\u6210"},"content":{"rendered":"

PHP\u3068SQLite\u306e\u7df4\u7fd2\u3067\u7c21\u6613\u63b2\u793a\u677f\u3092\u4f5c\u3063\u305f\u306e\u3067\u30e1\u30e2\u3002<\/p>\n

 <\/p>\n

\u30c6\u30fc\u30d6\u30eb\u69cb\u9020<\/h2>\n
CREATE TABLE 'bbs' ( 'id' INTEGER PRIMARY KEY, 'msg' TEXT , 'ymd' DATETIME );<\/pre>\n
 <\/p>\n
\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9<\/h2>\n
<?php\r\n\r\n\/\/DB\u63a5\u7d9a\r\n$db = new SQLite3('.\/db\/bbs');\r\n\r\n\r\n\/\/\u66f8\u304d\u8fbc\u307f\u6642\r\nif( $_POST['mode'] == 'insert' && $_POST['msg'] ){\r\n    $msg = $db->escapeString(strip_tags($_POST['msg'])); \/\/\u30a8\u30b9\u30b1\u30fc\u30d7&HTML\u30bf\u30b0\u9664\u53bb\r\n    $query = '\r\n        INSERT INTO bbs \r\n            (msg, ymd) \r\n        VALUES \r\n            (\"' . $msg . '\", datetime(\"now\", \"localtime\"))\r\n    ';\r\n    $result = $db->query($query);\r\n\r\n    if( $result ){\r\n        header('Location:' . $_SERVER['PHP_SELF']);\r\n    }else{\r\n        echo 'insert error!';\r\n        exit();\r\n    }\r\n}\r\n\r\n\r\n\/\/\u524a\u9664\u6642\r\nif( $_GET['mode'] == 'delete' && $_GET['id'] ){\r\n    $id = $db->escapeString($_GET['id']); \/\/\u30a8\u30b9\u30b1\u30fc\u30d7\r\n    $query = 'DELETE FROM bbs WHERE id = ' . $id;\r\n    $result = $db->query($query);\r\n\r\n    if( $result ){\r\n        header('Location:' . $_SERVER['PHP_SELF']);\r\n    }else{\r\n        echo 'delete error!';\r\n        exit();\r\n    }\r\n}\r\n\r\n\r\n\/\/\u7de8\u96c6\u7528\u306e\u30c7\u30fc\u30bf\u53d6\u5f97\r\nif( $_GET['mode'] == 'update' && $_GET['id'] ){\r\n    $id = $db->escapeString($_GET['id']); \/\/\u30a8\u30b9\u30b1\u30fc\u30d7\r\n    $query = 'SELECT * FROM bbs WHERE id = ' . $id;\r\n    $result = $db->query($query);\r\n\r\n    if( $result ){\r\n        while ($row = $result->fetchArray()) {\r\n            $updateData['id'] = $row['id'];\r\n            $updateData['msg'] = $row['msg'];\r\n        }\r\n    }else{\r\n        echo 'select error!';\r\n        exit();\r\n    }\r\n}\r\n\r\n\r\n\/\/\u7de8\u96c6\r\nif( $_POST['mode'] == 'update2' && $_POST['id'] && $_POST['msg']){\r\n    $msg = $db->escapeString(strip_tags($_POST['msg'])); \/\/\u30a8\u30b9\u30b1\u30fc\u30d7\r\n    $id = $db->escapeString(strip_tags($_POST['id'])); \/\/\u30a8\u30b9\u30b1\u30fc\u30d7\r\n\r\n    $query = '\r\n        UPDATE bbs \r\n        SET msg = \"' . $msg . '\"\r\n        WHERE id = ' . $id\r\n    ;\r\n    $result = $db->query($query);\r\n\r\n    if( $result ){\r\n        header('Location:' . $_SERVER['PHP_SELF']);\r\n    }else{\r\n        echo 'update error!';\r\n        exit();\r\n    }\r\n}\r\n\r\n\r\n\/\/\u8aad\u307f\u8fbc\u307f\r\n$bbsTable = '';\r\n$bbsTable .= '<table border=\"1\"><tr><th>\u756a\u53f7<\/th><th>\u30e1\u30c3\u30bb\u30fc\u30b8<\/th><th>\u66f8\u304d\u8fbc\u307f\u65e5\u6642<\/th><th>\u7de8\u96c6<\/th><th>\u524a\u9664<\/th><\/tr>';\r\n\r\n$query = '\r\n    SELECT * \r\n    FROM bbs \r\n    ORDER BY id DESC \r\n    LIMIT 10\r\n';\r\n$result = $db->query($query);\r\n\r\nif( !$result ){\r\n    echo 'sql error!';\r\n    exit();\r\n}\r\n\r\nwhile ($row = $result->fetchArray()) {\r\n    $bbsTable .= '\r\n        <tr>\r\n            <td>' . $row['id'] . '<\/td>\r\n            <td>' . htmlspecialchars($row['msg']) . '<\/td>\r\n            <td>' . $row['ymd'] . '<\/td>\r\n            <td><input type=\"button\" onclick=\"return bbsUpdate('. $row['id'] .')\" value=\"\u7de8\u96c6\" class=\"btn\"><\/td>\r\n            <td><input type=\"button\" onclick=\"return bbsDelete('. $row['id'] .')\" value=\"\u524a\u9664\" class=\"btn btn-danger\"><\/td>\r\n        <\/tr>\r\n    ';\r\n}\r\n\r\n$bbsTable .= '<\/table>';\r\n$db->close();\r\n?>\r\n<html>\r\n<head>\r\n<title>PHP&sqlite\u3067\u63b2\u793a\u677f\u30c6\u30b9\u30c8<\/title>\r\n<link href=\"\/\/netdna.bootstrapcdn.com\/twitter-bootstrap\/2.3.2\/css\/bootstrap-combined.min.css\" rel=\"stylesheet\">\r\n<script>\r\nfunction bbsDelete( id ){\r\n    if( confirm('\u524a\u9664\u3057\u3066\u3088\u308d\u3057\u3044\u3067\u3059\u304b') ){\r\n        location.href = '<?=$_SERVER[\"PHP_SELF\"]?>?mode=delete&id=' + id;\r\n    } else {\r\n        return false;\r\n    }\r\n}\r\nfunction bbsUpdate( id ){\r\n    location.href = '<?=$_SERVER[\"PHP_SELF\"]?>?mode=update&id=' + id;\r\n}\r\n<\/script>\r\n\r\n<\/head>\r\n<body>\r\n    <form action=\"<?=$_SERVER[\"PHP_SELF\"]?>\" method=\"post\">\r\n        <textarea name=\"msg\" rows=\"5\" cols=\"60\"><? if( $_GET['mode'] == 'update' ){?><?=$updateData['msg']?><?}?><\/textarea><br>\r\n        <input type=\"hidden\" name=\"mode\" value=\"<?=( $_GET['mode'] == 'update' ) ? 'update2' : 'insert';?>\">\r\n        <? if( $_GET['mode'] == 'update' ){?><input type=\"hidden\" name=\"id\" value=\"<?=$updateData['id']?>\"><?}?>\r\n        <input type=\"submit\" value=\"\u66f8\u304d\u8fbc\u307f\">\r\n    <\/form><\/hr>\r\n    <?=$bbsTable?>\r\n<\/body>\r\n<\/html><\/pre>\n
 <\/p>\n
\u305d\u306e\u4ed6<\/h2>\n
\u8aad\u307f\u66f8\u304d\u3068\u304b\u306b\u95a2\u3057\u3066\u306fMySQL\u3068\u3042\u307e\u308a\u5909\u308f\u3089\u306a\u3044\u306e\u3067\u554f\u984c\u306a\u3044\u3051\u3069\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u3068\u304b\u304c\u7121\u3044\u306e\u3067\u3001DB\u30d5\u30a1\u30a4\u30eb\u306e\u6271\u3044\u306f\u6ce8\u610f\u3057\u306a\u3044\u3068\u3044\u3051\u306a\u3055\u305d\u3046\u3002<\/p>\n
\u3042\u3068\u8907\u6570\u306e\u66f8\u304d\u8fbc\u307f\u306e\u30bf\u30a4\u30df\u30f3\u30b0\u304c\u4e00\u81f4\u3059\u308b\u3068\u66f8\u304d\u8fbc\u307f\u30a8\u30e9\u30fc\u306b\u306a\u3063\u3066\u3057\u307e\u3046\u3002\u8aad\u307f\u8fbc\u307f\u306fOK\u3002<\/p>\n
\u3088\u3063\u3066BBS\u3092\u4f5c\u308b\u306e\u306b\u306f\u5411\u3044\u3066\u306a\u3044\u3068\u3044\u3046\u3053\u3068\u306b\u306f\u306a\u3063\u3066\u3057\u307e\u3044\u305d\u3046\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
PHP\u3068SQLite\u306e\u7df4\u7fd2\u3067\u7c21\u6613\u63b2\u793a\u677f\u3092\u4f5c\u3063\u305f\u306e\u3067\u30e1\u30e2\u3002   \u30c6\u30fc\u30d6\u30eb ... <\/p>\n","protected":false},"author":1,"featured_media":2297,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2,43],"tags":[],"class_list":["post-1923","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","category-sqlite"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/1923","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/comments?post=1923"}],"version-history":[{"count":2,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/1923\/revisions"}],"predecessor-version":[{"id":5871,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/1923\/revisions\/5871"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media\/2297"}],"wp:attachment":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media?parent=1923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/categories?post=1923"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/tags?post=1923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}