PHP\u3068SQLite\u306e\u7df4\u7fd2\u3067\u7c21\u6613\u63b2\u793a\u677f\u3092\u4f5c\u3063\u305f\u306e\u3067\u30e1\u30e2\u3002<\/p>\n
<\/p>\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":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t