PHP\u5fa9\u7fd2\u306e\u305f\u3081\u3001
\n\u30fbPHP\u3067\u306e\u30ed\u30b0\u30a4\u30f3\uff0b\u30ed\u30b0\u30a2\u30a6\u30c8
\n\u30fbVue.jp\u2192PHP\u2192MySQL\u3067\u306e\u53d6\u5f97(JSON)\uff0b\u66f4\u65b0
\n\u3092\u4f5c\u6210\u3057\u3066\u307f\u305f\u3002<\/p>\n
config.php<\/p>\n
<?php\r\n\r\ndefine(\"BASE_URL\", \"http:\/\/\" . $_SERVER[\"HTTP_HOST\"] . \"\/app1\");\r\n\r\ndefine(\"DB_DSN\", \"mysql:host=localhost;dbname=test_db;charset=utf8\");\r\ndefine(\"DB_USR\", \"root\");\r\ndefine(\"DB_PWD\", \"xxx\");\r\n\r\n$auth = [\r\n\t\"taro\" => [\"id\" => \"100\", \"pwd\" => '$2y$10$h8HbPPXw99gmOdhWWYgxl.oGBMPEBmTtE5YWW25dq7T.TpxTcqRAm'],\r\n\t\"jiro\" => [\"id\" => \"200\", \"pwd\" => '$2y$10$A9XhGbn\/K0O9OG\/\/Ei2.fe\/4i8\/VSgixJ2mSYs5w25\/etTLAy8AYm'],\r\n];\r\n\r\n\/\/ php -r \"echo password_hash('\u30d1\u30b9\u30ef\u30fc\u30c9', PASSWORD_DEFAULT);\"<\/pre>\nindex.php<\/p>\n
<?php\r\nsession_start();\r\n\r\nini_set(\"display_errors\", 1);\r\nini_set(\"error_reporting\", E_ALL);\r\n\r\nrequire_once \"config.php\";\r\n\r\nif (!isset($_SESSION[\"id\"])) {\r\n header(\"Location: \" . BASE_URL . \"\/login.php\");\r\n exit;\r\n}\r\n\r\n?>\r\n\r\n<!DOCTYPE html>\r\n<html lang=\"ja\">\r\n<head>\r\n <meta charset=\"UTF-8\">\r\n <title>test<\/title>\r\n <script src=\"https:\/\/cdn.jsdelivr.net\/npm\/vue\/dist\/vue.js\"><\/script>\r\n <script src=\"https:\/\/unpkg.com\/axios\/dist\/axios.min.js\"><\/script>\r\n <style>\r\n table{\r\n border-collapse: collapse;\r\n }\r\n td{\r\n min-width: 100px;\r\n border: 1px solid #ccc;\r\n \r\n }\r\n <\/style>\r\n<\/head>\r\n<body>\r\n\r\n<div id=\"app\">\r\n\r\n <form>\r\n <input type=\"button\" value=\"\u53d6\u5f97\" v-on:click=\"select\">\r\n <\/form>\r\n\r\n <table>\r\n <tr v-for=\"item in items\" v-bind:data-id=\"item.id\">\r\n <td v-on:click=\"td_click\">{{item.id}}<\/td>\r\n <td v-on:click=\"td_click\">{{item.name}}<\/td>\r\n <td v-on:click=\"td_click\">{{item.age}}<\/td>\r\n <\/tr>\r\n <\/table>\r\n\r\n <form>\r\n ID:<input type=\"text\" v-model=\"model['id']\" >\r\n Name:<input type=\"text\" v-model=\"model['name']\">\r\n Age:<input type=\"text\" v-model=\"model['age']\">\r\n <input type=\"button\" value=\"\u66f4\u65b0\" v-on:click=\"update\">\r\n <\/form>\r\n\r\n<\/div>\r\n\r\n<a href=\"<?php echo BASE_URL . \"\/logout.php\" ?>\">Logout<\/a>\r\n\r\n<script>\r\n\r\nlet v = new Vue({\r\n el: \"#app\",\r\n data: {\r\n\r\n model: {\r\n \"id\": \"\",\r\n \"name\": \"\",\r\n \"age\": \"\"\r\n },\r\n url: \"<?php echo BASE_URL . \"\/json.php\" ?>\",\r\n items: null\r\n\r\n },\r\n methods: {\r\n \r\n clear(){\r\n\r\n this.items = []; \r\n this.model[\"id\"] = \"\";\r\n this.model[\"name\"] = \"\";\r\n this.model[\"age\"] = \"\";\r\n\r\n },\r\n td_click(e) {\r\n\r\n let parent = e.currentTarget.parentNode;\r\n this.model[\"id\"] = parent.children[0].textContent;\r\n this.model[\"name\"] = parent.children[1].textContent;\r\n this.model[\"age\"] = parent.children[2].textContent;\r\n\r\n },\r\n select() {\r\n\r\n let params = new URLSearchParams();\r\n params.append(\"query_type\", 1);\r\n\r\n this.post(params, true);\r\n\r\n },\r\n update() {\r\n\r\n let params = new URLSearchParams();\r\n params.append(\"query_type\", 2);\r\n params.append(\"id\", this.model[\"id\"]);\r\n params.append(\"name\", this.model[\"name\"]);\r\n params.append(\"age\", this.model[\"age\"]);\r\n\r\n this.post(params, false);\r\n this.clear();\r\n\r\n },\r\n post(params, exists_response) {\r\n console.log(params);\r\n axios\r\n .post(v.url, params)\r\n .then(response => {\r\n\r\n if(exists_response) this.items = response.data;\r\n\r\n })\r\n .catch(error => {\r\n\r\n alert(error);\r\n\r\n });\r\n }\r\n }\r\n})\r\n\r\n<\/script>\r\n\r\n<\/body>\r\n<\/html><\/pre>\njson.php<\/p>\n
<?php\r\nsession_start();\r\n\r\nini_set(\"display_errors\", 1);\r\nini_set(\"error_reporting\", E_ALL);\r\n\r\nrequire \"config.php\";\r\n\r\nif (!isset($_SESSION[\"id\"])) exit;\r\n\r\n$query_type = filter_input(INPUT_POST, \"query_type\", FILTER_SANITIZE_FULL_SPECIAL_CHARS); \r\n$id = filter_input(INPUT_POST, \"id\", FILTER_SANITIZE_FULL_SPECIAL_CHARS); \r\n$name = filter_input(INPUT_POST, \"name\", FILTER_SANITIZE_FULL_SPECIAL_CHARS); \r\n$age = filter_input(INPUT_POST, \"age\", FILTER_SANITIZE_FULL_SPECIAL_CHARS); \r\n\r\nif ($_SERVER[\"REQUEST_METHOD\"] === \"POST\" && isset($query_type)) {\r\n\r\n $json = new Json();\r\n\r\n switch ($query_type){\r\n\r\n case 1:\r\n $columnList = array(\"id\",\"name\",\"age\");\r\n $json->ExecuteQuery(\"select * from test_table\", $columnList); \r\n break;\r\n\r\n case 2:\r\n $json->ExecuteNonQuery(\r\n \"update test_table set name = :name, age = :age where id = :id\", \r\n array(\":name\"=>$name, \":age\"=>$age, \":id\"=>$id)\r\n );\r\n break;\r\n\r\n }\r\n}\r\n\r\n\/\/ class\r\n\r\nclass Json{\r\n\r\n function Connection() {\r\n\r\n try {\r\n\r\n return new PDO(DB_DSN, DB_USR, DB_PWD);\r\n\r\n } catch (Exception $e) {\r\n \r\n http_response_code(401);\r\n exit;\r\n\r\n }\r\n }\r\n\r\n function ExecuteNonQuery($sql, $valueList){\r\n\r\n $stmt = $this->Connection()->prepare($sql);\r\n $stmt->execute($valueList);\r\n\r\n }\r\n\r\n function ExecuteQuery($sql, $columnList) {\r\n\r\n $result = array();\r\n foreach($this->Connection()->query($sql) as $row){\r\n $tmp = array();\r\n foreach($columnList as $column){\r\n $tmp[$column] = $row[$column];\r\n }\r\n array_push($result, $tmp);\r\n }\r\n header('Content-type: application\/json');\r\n echo json_encode($result, JSON_UNESCAPED_UNICODE);\r\n\r\n }\r\n}\r\n<\/pre>\nlogin.php<\/p>\n
<?php\r\nsession_start();\r\n\r\nini_set(\"display_errors\", 1);\r\nini_set(\"error_reporting\", E_ALL);\r\n\r\nrequire_once \"config.php\";\r\n\r\n$usr = filter_input(INPUT_POST, \"usr\", FILTER_SANITIZE_FULL_SPECIAL_CHARS); \r\n$pwd = filter_input(INPUT_POST, \"pwd\", FILTER_SANITIZE_FULL_SPECIAL_CHARS); \r\n\r\n$token = filter_input(INPUT_POST, \"token\", FILTER_SANITIZE_FULL_SPECIAL_CHARS); \r\n\r\nif ($_SERVER[\"REQUEST_METHOD\"] === \"POST\" && $token === $_SESSION[\"token\"]) {\r\n\r\n\tif (isset($auth[$usr]) && password_verify($pwd, $auth[$usr][\"pwd\"])) {\r\n\r\n\t\tsession_regenerate_id();\r\n\t\t$_SESSION[\"id\"] = $auth[$usr][\"id\"];\r\n\t\r\n\t\theader(\"Location: \" . BASE_URL . \"\/index.php\");\r\n\t\texit;\r\n\r\n\t} else {\r\n\r\n\t\techo \"<script>(function(){alert('\u30e6\u30fc\u30b6\u30fc\u540d\u307e\u305f\u306f\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u9055\u3044\u307e\u3059\u3002');}());<\/script>\";\r\n\r\n\t}\r\n}\r\n\r\n$_SESSION[\"token\"] = md5(mt_rand());\r\n\r\n?>\r\n\r\n<!DOCTYPE html>\r\n<html lang=\"ja\">\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<\/head>\r\n<body>\r\n\r\n<form method=\"post\">\r\n\t\u30e6\u30fc\u30b6\u30fc\u540d: <input type=\"text\" name=\"usr\">\r\n\t\u30d1\u30b9\u30ef\u30fc\u30c9: <input type=\"text\" name=\"pwd\">\r\n\t<input type=\"hidden\" name=\"token\" value=\"<?php echo $_SESSION[\"token\"]; ?>\">\r\n\t<input type=\"submit\">\r\n<\/form>\r\n\r\n<\/body>\r\n<\/html>\r\n<\/pre>\nlogout.php<\/p>\n
<?php\r\nsession_start();\r\n\r\nini_set(\"display_errors\", 1);\r\nini_set(\"error_reporting\", E_ALL);\r\n\r\nrequire_once \"config.php\";\r\n\r\nsession_destroy();\r\n\r\nheader(\"Location: \" . BASE_URL . \"\/login.php\");<\/pre>\n <\/p>\n","protected":false},"excerpt":{"rendered":"
PHP\u5fa9\u7fd2\u306e\u305f\u3081\u3001 \u30fbPHP\u3067\u306e\u30ed\u30b0\u30a4\u30f3\uff0b\u30ed\u30b0\u30a2\u30a6\u30c8 \u30fbVue.jp\u2192PHP\u2192MySQL\u3067\u306e\u53d6\u5f97(JSON)\uff0b\u66f4\u65b0 \u3092\u4f5c\u6210\u3057\u3066\u307f\u305f\u3002 config.php <?php define(“BASE_URL”, “htt … <\/p>\n