{"id":435,"date":"2016-12-20T01:45:45","date_gmt":"2016-12-19T16:45:45","guid":{"rendered":"http:\/\/okamurax.com\/?p=435"},"modified":"2016-12-23T10:04:21","modified_gmt":"2016-12-23T01:04:21","slug":"php-%e5%b7%a5%e7%a8%8b%e7%ae%a1%e7%90%86%e3%83%86%e3%82%b9%e3%83%88%e3%82%a2%e3%83%97%e3%83%aa","status":"publish","type":"post","link":"https:\/\/appbay.org\/?p=435","title":{"rendered":"PHP \u5de5\u7a0b\u7ba1\u7406\u30c6\u30b9\u30c8\u30a2\u30d7\u30ea"},"content":{"rendered":"<p>table.php<\/p>\n<pre class=\"lang:php decode:true \" >\r\n<?php\r\n\r\nif(array_key_exists(\"v\",$_GET)){\r\n\r\n\tswitch($_GET[\"v\"]){\r\n\t\t\r\n\tcase \"done\":\r\n\r\n\t\t$stmt = $db->query(\"SELECT * FROM gaisaku WHERE kanryo_kubun = 1;\");\r\n\t\t$result = $stmt->fetchAll();\r\n\t\t\r\n\t\t$stmt = $db->query(\"SELECT COUNT(*) FROM gaisaku WHERE kanryo_kubun = 1;\");\r\n\t\t$c = $stmt->fetchColumn();\r\n\t\t\r\n\t\tbreak;\r\n\t\t\r\n\tcase \"hold\":\r\n\r\n\t\t$stmt = $db->query(\"SELECT * FROM gaisaku WHERE kanryo_kubun = 2;\");\r\n\t\t$result = $stmt->fetchAll();\r\n\t\t\r\n\t\t$stmt = $db->query(\"SELECT COUNT(*) FROM gaisaku WHERE kanryo_kubun = 2;\");\r\n\t\t$c = $stmt->fetchColumn();\r\n\t\t\r\n\t\tbreak;\r\n\t\t\r\n\tcase \"none_draw\":\r\n\r\n\t\t$stmt = $db->query(\"SELECT DISTINCT\r\n\t\t\tgaisaku.id,\r\n\t\t\tgaisaku.tokui_saki,\r\n\t\t\tgaisaku.katashiki,\r\n\t\t\tgaisaku.koban,\r\n\t\t\tgaisaku.suryo,\r\n\t\t\tgaisaku.seisaku_saki,\r\n\t\t\tgaisaku.kanryo_kubun,\r\n\t\t\tgaisaku.tanka,\r\n\t\t\tgaisaku.kingaku,\r\n\t\t\tgaisaku.saisyu_koushinbi,\r\n\t\t\tgaisaku.syukka_zuki,\r\n\t\t\tgaisaku_task.task\r\n\t\tFROM gaisaku LEFT JOIN gaisaku_task\r\n\t\t\tON gaisaku.id = gaisaku_task.gaisaku_id AND gaisaku_task.task = '\u51fa\u56f3'\r\n\t\tWHERE (gaisaku_task.task != '\u51fa\u56f3' OR gaisaku_task.task IS NULL) AND kanryo_kubun IS NULL OR kanryo_kubun = 0\");\r\n\t\t$result = $stmt->fetchAll();\r\n\t\t\r\n\t\t$stmt = $db->query(\"SELECT COUNT(DISTINCT gaisaku.ID)\r\n\t\tFROM gaisaku LEFT JOIN gaisaku_task\r\n\t\tON gaisaku.id = gaisaku_task.gaisaku_id AND gaisaku_task.task = '\u51fa\u56f3'\r\n\t\tWHERE (gaisaku_task.task != '\u51fa\u56f3' OR gaisaku_task.task IS NULL)\r\n\t\tAND kanryo_kubun IS NULL OR kanryo_kubun = 0\");\r\n\t\t\r\n\t\t$c = $stmt->fetchColumn();\r\n\t\t\r\n\t\tbreak;\r\n\t\t\r\n\tcase \"none_sup\":\r\n\r\n\t\t$stmt = $db->query(\"SELECT * FROM gaisaku WHERE seisaku_saki = '' AND kanryo_kubun IS NULL OR kanryo_kubun = 0\");\r\n\t\t$result = $stmt->fetchAll();\r\n\t\t\r\n\t\t$stmt = $db->query(\"SELECT COUNT(*) FROM gaisaku WHERE seisaku_saki = '' AND kanryo_kubun IS NULL OR kanryo_kubun = 0\");\r\n\t\t$c = $stmt->fetchColumn();\r\n\t\t\r\n\t\tbreak;\r\n\r\n\tdefault:\r\n\t\t\r\n\t\t$stmt = $db->query(\"SELECT * FROM gaisaku WHERE kanryo_kubun IS NULL OR kanryo_kubun = 0\");\r\n\t\t$result = $stmt->fetchAll();\r\n\t\t\r\n\t\t$stmt = $db->query(\"SELECT COUNT(*) FROM gaisaku WHERE kanryo_kubun IS NULL OR kanryo_kubun = 0\");\r\n\t\t$c = $stmt->fetchColumn();\r\n\t\t\r\n\t}\r\n\r\n}else{\r\n\r\n\t\t$stmt = $db->query(\"SELECT * FROM gaisaku WHERE kanryo_kubun IS NULL OR kanryo_kubun = 0\");\r\n\t\t$result = $stmt->fetchAll();\r\n\t\t\r\n\t\t$stmt = $db->query(\"SELECT COUNT(*) FROM gaisaku WHERE kanryo_kubun IS NULL OR kanryo_kubun = 0\");\r\n\t\t$c = $stmt->fetchColumn();\r\n\t\t\r\n}\r\n\r\nfor($j = 0; $j < $c; $j++):\r\n?>\r\n<table id=\"table_<?php echo $result[$j][\"id\"]; ?>\" data-id=\"<?php echo $result[$j][\"id\"]; ?>\">\r\n\t<!-- tr 1 -->\r\n\t<tr>\r\n\t\t<th class=\"cap_1\">\r\n\t\t\t<p><?php echo $j + 1; ?><\/p>\r\n\t\t<\/th>\r\n\t\t<th class=\"cap_2\">\r\n\t\t\t<p>\u9867\u5ba2<\/p>\r\n\t\t<\/th>\r\n\t\t<th class=\"cap_3\">\r\n\t\t\t<p>\u578b\u5f0f<\/p>\r\n\t\t<\/th>\r\n\t\t<th class=\"cap_4\">\r\n\t\t\t<p>\u5de5\u756a<\/p>\r\n\t\t<\/th>\r\n\t\t<th class=\"cap_5\">\r\n\t\t\t<p>\u6570\u91cf<\/p>\r\n\t\t<\/th>\r\n\t\t<th class=\"cap_6\">\r\n\t\t\t<p>\u88fd\u4f5c\u5148<\/p>\r\n\t\t<\/th>\r\n\t\t<th class=\"cap_7\">\r\n\t\t\t<p>\u5358\u4fa1<\/p>\r\n\t\t<\/th>\r\n\t\t<?php\r\n\t\t\/\/\u30bf\u30b9\u30af\r\n\t\tfor($i=0; $i < $column; $i++){\r\n\t\t\t\r\n\t\t\techo '<th class=\"y_';\r\n\t\t\techo date(\"y\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' m_';\r\n\t\t\techo date(\"m\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' d_';\r\n\t\t\techo date(\"d\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' w_';\r\n\t\t\techo date(\"w\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' r_1';\r\n\t\t\techo '\"';\r\n\t\t\techo 'data-date=\"';\r\n\t\t\techo date(\"Y-m-d\",strtotime(\" $start_day + $i day\"));\t\r\n\t\t\techo '\">';\r\n\t\t\t\/\/\u65e5\u4ed8\u898b\u51fa\r\n\t\t\techo date(\"m\/d\",strtotime(\" $start_day + $i day\"));\r\n\t\t\t\/\/\r\n\t\t\techo '<\/th>';\r\n\t\t}\r\n\t\t?>\r\n\t<\/tr>\r\n\t<!-- tr 2 -->\r\n\t<tr>\r\n\t\t<td rowspan=\"3\" class=\"val_1\">\r\n\t\t\t<p class=\"btn edit_btn\">[\u7de8\u96c6]<\/p>\r\n\t\t<\/td>\r\n\t\t<td rowspan=\"3\" class=\"val_2\">\r\n\t\t\t<p><?php echo $result[$j][\"tokui_saki\"]; ?><\/p>\r\n\t\t<\/td>\r\n\t\t<td rowspan=\"3\" class=\"val_3\">\r\n\t\t\t<p><?php echo $result[$j][\"katashiki\"]; ?><\/p>\r\n\t\t<\/td>\r\n\t\t<td rowspan=\"3\" class=\"val_4\">\r\n\t\t\t<p><?php echo $result[$j][\"koban\"]; ?><\/p>\r\n\t\t<\/td>\r\n\t\t<td rowspan=\"3\" class=\"val_5\">\r\n\t\t\t<p><?php echo $result[$j][\"suryo\"]; ?><\/p>\r\n\t\t<\/td>\r\n\t\t<td rowspan=\"3\" class=\"val_6\">\r\n\t\t\t<p><?php echo $result[$j][\"seisaku_saki\"]; ?><\/p>\r\n\t\t<\/td>\r\n\t\t<td rowspan=\"3\" class=\"val_7\">\r\n\t\t\t<p><?php echo number_format($result[$j][\"tanka\"]); ?><\/p>\r\n\t\t\t<span><?php echo \"(\", number_format($result[$j][\"tanka\"] * $result[$j][\"suryo\"]), \")\"; ?><\/span>\r\n\t\t<\/td>\r\n\t\t<?php\r\n\t\t\r\n\t\t\/\/\u30bf\u30b9\u30af\r\n\t\tfor($i=0; $i < $column; $i++){\r\n\t\t\t\r\n\t\t\techo '<td class=\"y_';\r\n\t\t\techo date(\"y\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' m_';\r\n\t\t\techo date(\"m\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' d_';\r\n\t\t\techo date(\"d\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' w_';\r\n\t\t\techo date(\"w\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' r_2';\r\n\t\t\r\n\t\t\t$date_id = $result[$j][\"id\"];\r\n\t\t\t$date_value = date(\"Y-m-d\",strtotime(\" $start_day + $i day\"));\r\n\r\n\t\t\t\/\/\u30bf\u30b9\u30af\u306e\u7bc4\u56f2\u5185\u304b\u3069\u3046\u304b\u5224\u65ad\r\n\t\t\t$stmt = $db->prepare(\"SELECT MAX(hizuke) FROM gaisaku_task WHERE gaisaku_id = ?\");\r\n\t\t\t$stmt->execute(array($date_id));\r\n\t\t\t$date_max = $stmt->fetchAll();\r\n\r\n\t\t\t$stmt = $db->prepare(\"SELECT MIN(hizuke) FROM gaisaku_task WHERE gaisaku_id = ?\");\r\n\t\t\t$stmt->execute(array($date_id));\r\n\t\t\t$date_min = $stmt->fetchAll();\r\n\t\t\t\r\n\t\t\tif($date_min[0][0] <= $date_value &#038;&#038; $date_max[0][0] >= $date_value){\r\n\t\t\t\techo ' blk';\r\n\t\t\t\techo '\"';\r\n\t\t\t}else{\r\n\t\t\t\techo '\"';\r\n\t\t\t}\r\n\t\t\t\r\n\t\t\techo 'data-date=\"';\r\n\t\t\techo date(\"Y-m-d\",strtotime(\" $start_day + $i day\"));\t\r\n\t\t\techo '\"';\r\n\t\t\techo '><\/td>';\r\n\r\n\t\t}\r\n\t\t?>\r\n\t<\/tr>\r\n\t<!-- tr 3 -->\r\n\t<tr>\r\n\t\t<?php\r\n\t\tfor($i=0; $i < $column; $i++){\r\n\t\t\t\r\n\t\t\techo '<td class=\"y_';\r\n\t\t\techo date(\"y\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' m_';\r\n\t\t\techo date(\"m\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' d_';\r\n\t\t\techo date(\"d\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' w_';\r\n\t\t\techo date(\"w\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' r_3';\r\n\t\t\techo '\"';\r\n\t\t\techo 'data-date=\"';\r\n\t\t\techo date(\"Y-m-d\",strtotime(\" $start_day + $i day\"));\t\r\n\t\t\techo '\">';\r\n\r\n\t\t\t$date_id = $result[$j][\"id\"];\r\n\t\t\t$date_value = date(\"Y-m-d\",strtotime(\" $start_day + $i day\"));\r\n\t\t\t\r\n\t\t\t\/\/\u30bf\u30b9\u30af\u5185\u5bb9\r\n\t\t\t$stmt = $db->prepare(\"SELECT task,kensa_komoku,hizuke FROM gaisaku_task WHERE gaisaku_id = ? AND hizuke = ?\");\r\n\t\t\t$stmt->execute(array($date_id,$date_value));\r\n\t\t\t$date_result = $stmt->fetchAll();\r\n\r\n\t\t\tforeach($date_result as $r){\r\n\t\t\t\techo $r[\"task\"];\r\n\t\t\t\techo ($r[\"kensa_komoku\"]) ? \"(\" . $r[\"kensa_komoku\"] . \")\" : \"\";\r\n\t\t\t\techo \"<br>\";\r\n\t\t\t}\r\n\r\n\t\t\techo '<\/td>';\r\n\t\t\r\n\t\t}\r\n\t\t?>\r\n\t<\/tr>\r\n\t<!-- tr 4 -->\r\n\t<tr>\r\n\t\t<?php\r\n\t\tfor($i=0; $i < $column; $i++){\r\n\t\t\t\r\n\t\t\techo '<td class=\"y_';\r\n\t\t\techo date(\"y\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' m_';\r\n\t\t\techo date(\"m\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' d_';\r\n\t\t\techo date(\"d\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' w_';\r\n\t\t\techo date(\"w\",strtotime(\" $start_day + $i day\"));\r\n\t\t\techo ' r_4';\r\n\t\t\techo '\"';\r\n\t\t\techo 'data-date=\"';\r\n\t\t\techo date(\"Y-m-d\",strtotime(\" $start_day + $i day\"));\t\r\n\t\t\techo '\">';\r\n\t\t\t\/\/\r\n\t\t\techo '<span class=\"btn tbl_btn\">[ \uff0b ]<\/span>', '<span class=\"btn tbl_btn_remove\">[ \uff0d ]<\/span>';\r\n\t\t\t\/\/\r\n\t\t\techo '<\/td>';\r\n\t\t\r\n\t\t}\r\n\t\t?>\r\n\t<\/tr>\r\n<\/table>\r\n\r\n<?php endfor; ?>\r\n<\/pre>\n<p>style.css<\/p>\n<pre class=\"lang:php decode:true \" >\r\n*{\r\n\tfont-family: \"Meiryo\";\r\n\tfont-size: 12px;\r\n}\r\nth.w_6{\r\n\tcolor: blue;\r\n}\r\nth.w_0{\r\n\tcolor: red;\r\n}\r\n\r\nth{\r\n\ttext-align: center;\r\n}\r\n.cap_1{\r\n\tfont-weight: bold;\r\n\tmin-width: 40px;\r\n}\r\n.cap_2{\r\n\tfont-weight: bold;\r\n\tmin-width: 150px;\r\n}\r\n.cap_3{\r\n\tfont-weight: bold;\r\n\tmin-width: 200px;\r\n}\r\n.cap_4{\r\n\tfont-weight: bold;\r\n\tmin-width: 100px;\r\n}\r\n.cap_5{\r\n\tfont-weight: bold;\r\n\tmin-width: 40px;\r\n}\r\n.cap_6{\r\n\tfont-weight: bold;\r\n\tmin-width: 150px;\r\n}\r\n.cap_7{\r\n\tfont-weight: bold;\r\n\tmin-width: 100px;\r\n}\r\n\r\n.val_1{\r\n\ttext-align: center;\r\n}\r\n.val_2{\r\n\r\n}\r\n.val_3{\r\n\r\n}\r\n.val_4{\r\n\r\n}\r\n.val_5{\r\n\ttext-align: right;\r\n}\r\n.val_6{\r\n\r\n}\r\n.val_7{\r\n\ttext-align: right;\r\n}\r\n.r_1{\r\n\r\n}\r\n.r_2{\r\n\theight: 5px;\r\n}\r\n.r_3{\r\n\theight: 30px;\r\n}\r\n.r_4{\r\n\ttext-align: center;\r\n}\r\n.r_4 > span{\r\n\tfont-size: 9px;\r\n}\r\n\r\nth,\r\ntd\r\n{\r\n\r\n\tborder: 1px solid #ccc;\r\n}\r\n\r\ntable{\r\n\tmargin: 0 0 10px 0;\r\n}\r\n.frm\r\n{\r\n\tmargin: 0 0 10px 0;\r\n}\r\n\r\n.frm > .btn,\r\n.frm > .down_btn\r\n{\r\n\tborder: 1px solid #ccc;\r\n\tpadding: 2px;\r\n}\r\n\r\n.btn{\r\n\tcolor: blue;\r\n\tcursor: pointer;\r\n}\r\n.down_btn\r\n{\r\n\tcolor: #ccc;\r\n}\r\n\r\nbody\r\n{\r\n\r\n\tpadding:10px;\r\n\t\r\n}\r\n\r\n.blk\r\n{\r\n\tbackground-color: #1253A4;\r\n}\r\n.w_0, .w_1, .w_2, .w_3, .w_4, .w_5, .w_6\r\n{\r\n\tmin-width: 100px;\r\n}\r\n\r\n#save_div\r\n{\r\n\tdisplay: none;\r\n\tmargin: 0 0 10px 0;\r\n\t\r\n\tpadding-bottom: 10px;\r\n\tborder-bottom: 2px solid #1253A4;\r\n}\r\n#edit_div\r\n{\r\n\tbackground-color: white;\r\n\tdisplay: none;\r\n\twidth: 100%;\r\n\tpadding: 10px 0 10px 10px;\r\n\r\n\tborder-bottom: 2px solid #1253A4;\r\n\t\r\n\ttop: 0px;\r\n\tleft: 0px;\r\n\tposition: fixed;\r\n\tz-index: 999;\r\n}\r\n\r\ninput[type=text]\r\n{\r\n\twidth: 10em;\r\n}\r\n#column_count\r\n{\r\n\twidth: 3em;\r\n}\r\n\r\n\r\n<\/pre>\n<p>save.php<\/p>\n<pre class=\"lang:php decode:true \" >\r\n<?php\r\nif( array_key_exists(\"do\", $_POST) &#038;&#038; array_key_exists(\"chk\", $_POST) &#038;&#038; array_key_exists(\"chk\", $_SESSION) &#038;&#038;\r\n$_POST[\"do\"] == \"save\" &#038;&#038; $_POST[\"chk\"] == $_SESSION[\"chk\"] ){\r\n\t\r\n\t$stmt = $db->prepare(\"INSERT INTO gaisaku (\r\n\t\ttokui_saki,katashiki,koban,suryo,seisaku_saki,tanka,kingaku,saisyu_koushinbi\r\n\t) VALUES (?,?,?,?,?,?,0,now())\");\r\n\t\r\n\t\r\n\t$stmt->execute(array($_POST[\"kokyaku\"],$_POST[\"katashiki\"],$_POST[\"kouban\"],$_POST[\"suryo\"],$_POST[\"seisakusaki\"],$_POST[\"tanka\"]));\r\n\t\r\n\t$_SESSION[\"chk\"] = uniqid();\r\n\theader(\"Location: \" . $_SERVER[\"SCRIPT_NAME\"] . \"?\" . $_SERVER[\"QUERY_STRING\"]);\r\n   \r\n}else{\r\n\t$_SESSION[\"chk\"] = uniqid();\r\n}\r\n\r\n?>\r\n<div id=\"save_div\">\r\n<form method=\"POST\">\r\n\t<div class=\"frm\">\r\n\t\u9867\u5ba2\uff1a<input type=\"text\" name=\"kokyaku\" id=\"save_kokyaku\">\r\n\t\u578b\u5f0f\uff1a<input type=\"text\" name=\"katashiki\" id=\"save_katashiki\">\r\n\t\u5de5\u756a\uff1a<input type=\"text\" name=\"kouban\" id=\"save_kouban\">\r\n\t\u6570\u91cf\uff1a<input type=\"text\" name=\"suryo\" id=\"save_suryo\">\r\n\t\u88fd\u4f5c\u5148\uff1a<input type=\"text\" name=\"seisakusaki\" id=\"save_seisakusaki\">\r\n\t<\/div>\r\n\t\u5358\u4fa1\uff1a<input type=\"text\" name=\"tanka\" id=\"save_tanka\">\r\n\t<input type=\"submit\" value=\"\u3000\u767b\u9332\u3000\">\r\n\t<input type=\"button\" value=\"\u3000\u4e2d\u6b62\u3000\" id=\"save_cancel_btn\">\r\n\t<input type=\"hidden\" name=\"do\" value=\"save\">\r\n\t<input type=\"hidden\" name=\"chk\" value=\"<?php echo $_SESSION[\"chk\"]; ?>\">\r\n<\/form>\r\n<\/div>\r\n<\/pre>\n<p>index.php<\/p>\n<pre class=\"lang:php decode:true \" >\r\n<?php\r\n\r\nexit();\r\n\r\nsession_start();\r\nini_set(\"display_errors\",1);\r\nerror_reporting(E_ALL);\r\n\r\n?>\r\n\r\n<!DOCTYPE html>\r\n<html lang=\"ja\">\r\n<head>\r\n\t<meta charset=\"UTF-8\">\r\n\t<title>\u5916\u6ce8\u5de5\u7a0b\u7ba1\u7406\u8868<\/title>\r\n\t<link rel=\"stylesheet\" href=\"cssreset-min.css\">\r\n\t<link rel=\"stylesheet\" href=\"style.css\">\r\n\t<script src=\"jquery-1.11.2.min.js\"><\/script>\r\n<\/head>\r\n<body>\r\n<?php\r\n\r\n\r\n\r\n\r\n\r\nif(array_key_exists(\"s\",$_GET) &#038;&#038; $_GET[\"s\"] != \"\"){\r\n\t\r\n\tif(preg_match(\"\/^[0-9]{8}$\/\", $_GET[\"s\"])){\r\n\t\t\r\n\t\t$start_day = substr($_GET[\"s\"], 0, 4) . \"-\" . substr($_GET[\"s\"], 4, 2) . \"-\" . substr($_GET[\"s\"], 6, 2);\r\n\t\t\r\n\t}else{\r\n\t\t\r\n\t\t$start_day = date(\"Y-m-d\");\r\n\t\t\r\n\t}\r\n\t\r\n}else{\r\n\t\r\n\t$start_day = date(\"Y-m-d\");\r\n}\r\n\r\n\r\nif(array_key_exists(\"c\",$_GET) &#038;&#038; $_GET[\"c\"] != \"\"){\r\n\t\r\n\tif(preg_match(\"\/^[0-9]+$\/\", $_GET[\"c\"])){\r\n\t\t\r\n\t\t$column = $_GET[\"c\"];\r\n\t\t\r\n\t}else{\r\n\t\t\r\n\t\t$column = 14;\r\n\t\t\r\n\t}\r\n\t\r\n}else{\r\n\t\r\n\t$column = 14;\r\n}\r\n\r\ninclude 'class.php';\r\n$db = Db::con();\r\n\r\ninclude 'edit.php';\r\ninclude 'save.php';\r\n\r\n?>\r\n<div class=\"frm\">\r\n\r\n\t<input type=\"button\" value=\"\u3000\u65b0\u898f\u767b\u9332\u3000\" id=\"save_btn\">\r\n\t\r\n\t<span class=\"<?php if(!array_key_exists(\"v\", $_GET)){\r\n\t\t\techo 'down_btn\"';\r\n\t\t}else{\r\n\t\t\techo 'btn\" id=\"default_btn\"';\r\n\t\t}\r\n\t?>>\u3000 \u901a\u5e38 \u3000<\/span>\r\n\t\r\n\t<span class=\"<?php if(array_key_exists(\"v\", $_GET) &#038;&#038; $_GET[\"v\"] == \"none_draw\"){\r\n\t\t\techo 'down_btn\"';\r\n\t\t}else{\r\n\t\t\techo 'btn\" id=\"none_draw_btn\"';\r\n\t\t}\r\n\t?>>\u3000 \u672a\u51fa\u56f3\u4f9d\u983c \u3000<\/span>\r\n\r\n\t<span class=\"<?php if(array_key_exists(\"v\", $_GET) &#038;&#038; $_GET[\"v\"] == \"none_sup\"){\r\n\t\t\techo 'down_btn\"';\r\n\t\t}else{\r\n\t\t\techo 'btn\" id=\"none_sup_btn\"';\r\n\t\t}\r\n\t?>>\u3000\u88fd\u4f5c\u5148\u672a\u6c7a\u5b9a\u3000<\/span>\r\n\t\r\n\t<span class=\"<?php if(array_key_exists(\"v\", $_GET) &#038;&#038; $_GET[\"v\"] == \"done\"){\r\n\t\t\techo 'down_btn\"';\r\n\t\t}else{\r\n\t\t\techo 'btn\" id=\"done_btn\"';\r\n\t\t}\r\n\t?>>\u3000\u3000 \u51fa\u8377\u6e08 \u3000\u3000<\/span>\r\n\t\r\n\t<span class=\"<?php if(array_key_exists(\"v\", $_GET) &#038;&#038; $_GET[\"v\"] == \"hold\"){\r\n\t\t\techo 'down_btn\"';\r\n\t\t}else{\r\n\t\t\techo 'btn\" id=\"hold_btn\"';\r\n\t\t}\r\n\t?>>\u3000\u3000 \u4fdd\u7559 \u3000\u3000<\/span>\r\n\t\t\r\n<\/div>\r\n\r\n<div id=\"start\" class=\"frm\">\r\n\t\u5217\u6570\uff1a<input type=\"text\" value=\"<?php echo $column ?>\" id=\"column_count\">\r\n\t\u65e5\u4ed8\uff1a\r\n\t<!-- \u5e74 -->\r\n\t<select id=\"start_y\">\r\n\t\t<option><?php echo date(\"Y\",strtotime(\" $start_day - 2 year\")); ?><\/option>\r\n\t\t<option><?php echo date(\"Y\",strtotime(\" $start_day - 1 year\")); ?><\/option>\r\n\t\t<option selected ><?php echo date(\"Y\",strtotime(\" $start_day + 0 year\")); ?><\/option>\r\n\t\t<option><?php echo date(\"Y\",strtotime(\" $start_day + 1 year\")); ?><\/option>\r\n\t\t<option><?php echo date(\"Y\",strtotime(\" $start_day + 2 year\")); ?><\/option>\r\n\t<\/select>\r\n\t<!-- \u6708 -->\r\n\t<select id=\"start_m\">\r\n\t\t<?php\r\n\t\tfor($i=1; $i <= 12; $i++){\r\n\t\t\tif((int)date(\"m\",strtotime(\"$start_day\")) == $i){\r\n\t\t\t\tif($i < 10){ $i = \"0\" . $i; }\r\n\t\t\t\techo '<option selected>', $i, '<\/option>'; \r\n\t\t\t}else{\r\n\t\t\t\tif($i < 10){ $i = \"0\" . $i; }\r\n\t\t\t\techo '<option>', $i, '<\/option>'; \r\n\t\t\t}\r\n\t\t} \r\n\t\t?>\r\n\t<\/select>\r\n\t<!-- \u65e5 -->\r\n\t<select id=\"start_d\">\r\n\t\t<?php\r\n\t\tfor($i=1; $i <= 31; $i++){\r\n\t\t\tif((int)date(\"d\",strtotime(\"$start_day\")) == $i){\r\n\t\t\t\tif($i < 10){ $i = \"0\" . $i; }\r\n\t\t\t\techo '<option selected>', $i, '<\/option>'; \r\n\t\t\t}else{\r\n\t\t\t\tif($i < 10){ $i = \"0\" . $i; }\r\n\t\t\t\techo '<option>', $i, '<\/option>'; \r\n\t\t\t}\r\n\t\t}\r\n\t\t?>\r\n\t<\/select>\r\n\t<input type=\"button\" value=\"\u3000\u66f4\u65b0\u3000\" id=\"start_position\">\r\n\t<input type=\"button\" value=\"\u3000\u672c\u65e5\u3000\" id=\"today_position\">\r\n\t\r\n<\/div>\r\n\r\n<?php include 'table.php'; ?>\r\n\r\n<script>\r\n\r\n$(document).on(\"change\",\"#task_select\",function(){\r\n\t\r\n\tif($(\"#task_select option:selected\").text() == \"\u691c\u67fb\"){\r\n\t\t\r\n\t\t$(\"#task_select_val\").removeAttr(\"disabled\");\r\n\t\t\r\n\t}else{\r\n\t\t\r\n\t\t$(\"#task_select_val\").attr(\"disabled\", \"disabled\");\t\r\n\t\t\r\n\t}\r\n\t\r\n});\r\n\r\n$(document).on(\"click\",\"#input_task_cancel_btn\", function(){\r\n\r\n\t$(\"#input_task_add\").remove();\r\n\r\n});\r\n\t\r\n$(document).on(\"click\",\"#input_task_add_btn\", function(){\r\n\r\n\tvar task =     $(\"#task_select option:selected\").text();\r\n\tvar task_val = $(\"#task_select_val\").val();\r\n\tvar id =       $(this).prev().children(\"input[name=id]\").val();\r\n\tvar ymd =      $(this).prev().children(\"input[name=ymd]\").val();\r\n\r\n\t$.ajax({\r\n\t\ttype: \"POST\",\r\n\t\turl: \"add_task.php\",\r\n\t\tacync: false,\r\n\t\tdata: {\r\n\t\t\ttask: task,\r\n\t\t\ttask_val: task_val,\r\n\t\t\tid: id,\r\n\t\t\tymd: ymd\r\n\t\t\t},\r\n\t\tdataType: 'html',\r\n\t\tsuccess: function(data){\r\n\t\t\tif (data === \"false\"){\r\n\t\t\t\talert(\"\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3057\u305f\u3002\u51e6\u7406\u306f\u4e2d\u65ad\u3055\u308c\u307e\u3057\u305f\u3002\");\r\n\t\t\t\treturn;\r\n\t\t\t}\r\n\t\t\t\r\n\t\t\t$(\"#input_task_add\").remove();\r\n\t\t\twindow.location.reload();\r\n\t\t\t\r\n\t\t},error: function(){\r\n\t\t\talert(\"\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3057\u305f\u3002\u51e6\u7406\u306f\u4e2d\u65ad\u3055\u308c\u307e\u3057\u305f\u3002\");\r\n\t\t\treturn;\r\n\t\t}\r\n\t});\r\n\t\r\n});\r\n\r\n\/\/\u30c0\u30a4\u30a2\u30ed\u30b0\u3092\u8868\u793a\r\n$(document).on(\"click\", \".tbl_btn\", function(){\r\n\r\n\tif(document.getElementById(\"input_task_add\") != null){\r\n\t\treturn;\r\n\t}\r\n\t\r\n\tvar id = $(this).parent().parent().parent().parent().data(\"id\");\r\n\tvar ymd = $(this).parent().data(\"date\");\r\n\t\r\n\tvar top = $(this).position().top;\r\n\tvar left = $(this).position().left;\r\n\t\r\n\tvar html = \r\n\t'<form class=\"frm\">'+\r\n\t\t'\u30bf\u30b9\u30af\uff1a<select id=\"task_select\"><option>\u51fa\u56f3\u65e5<\/option><option>\u652f\u7d66\u54c1\u624b\u914d<\/option><option>\u691c\u67fb<\/option><option>\u7d0d\u671f<\/option><\/select> '+\r\n\t\t'<input type=\"text\" id=\"task_select_val\" disabled=\"disabled\">'+\r\n\t\t'<input type=\"hidden\" name=\"id\" value=\"' + id + '\">'+\r\n\t\t'<input type=\"hidden\" name=\"ymd\" value=\"' + ymd + '\">'+\r\n\t'<\/form>'+\r\n\t'<input type=\"button\" value=\"\u3000\u767b\u9332\u3000\" id=\"input_task_add_btn\"> <input type=\"button\" value=\"\u3000\u4e2d\u6b62\u3000\"id=\"input_task_cancel_btn\">';\r\n\t\r\n\tvar e = $(\"<div>\", {\r\n\t\tid: \"input_task_add\", \r\n\t\thtml: html\r\n\t\t});\r\n\r\n\t$(\"body\").append(e);\r\n\t\r\n\t$(\"#input_task_add\").css({\r\n\t\t\"background-color\": \"white\",\r\n\t\t\"position\": \"absolute\",\r\n\t\t\"z-index\": \"999\",\r\n\t\t\"border\":\"2px solid #1253A4\",\r\n\t\t\"padding\": \"10px\",\r\n\t\t\"width\": \"265px\",\r\n\t\t\"top\": top,\r\n\t\t\"left\": left\r\n\t\t});\r\n\r\n});\r\n\r\n$(document).on(\"click\", \"#default_btn\", function(){\r\n\t\r\n\tvar y = $(\"#start_y option:selected\").text();\r\n\tvar m = $(\"#start_m option:selected\").text();\r\n\tvar d = $(\"#start_d option:selected\").text();\r\n\tvar start_day = y + m + d;\r\n\tvar count = $(\"#column_count\").val();\r\n\t\r\n\twindow.location.href = \"<?php echo $_SERVER['SCRIPT_NAME']; ?>\" + \"?s=\" + start_day + \"&c=\" + count + \"\";\r\n});\r\n\r\n$(document).on(\"click\", \"#done_btn\", function(){\r\n\t\r\n\tvar y = $(\"#start_y option:selected\").text();\r\n\tvar m = $(\"#start_m option:selected\").text();\r\n\tvar d = $(\"#start_d option:selected\").text();\r\n\tvar start_day = y + m + d;\r\n\tvar count = $(\"#column_count\").val();\r\n\t\r\n\twindow.location.href = \"<?php echo $_SERVER['SCRIPT_NAME']; ?>\" + \"?v=done&s=\" + start_day + \"&c=\" + count + \"\";\r\n});\r\n\r\n$(document).on(\"click\", \"#none_draw_btn\", function(){\r\n\t\r\n\tvar y = $(\"#start_y option:selected\").text();\r\n\tvar m = $(\"#start_m option:selected\").text();\r\n\tvar d = $(\"#start_d option:selected\").text();\r\n\tvar start_day = y + m + d;\r\n\tvar count = $(\"#column_count\").val();\r\n\t\r\n\twindow.location.href = \"<?php echo $_SERVER['SCRIPT_NAME']; ?>\" + \"?v=none_draw&s=\" + start_day + \"&c=\" + count + \"\";\r\n});\r\n$(document).on(\"click\", \"#none_sup_btn\", function(){\r\n\t\r\n\tvar y = $(\"#start_y option:selected\").text();\r\n\tvar m = $(\"#start_m option:selected\").text();\r\n\tvar d = $(\"#start_d option:selected\").text();\r\n\tvar start_day = y + m + d;\r\n\tvar count = $(\"#column_count\").val();\r\n\t\r\n\twindow.location.href = \"<?php echo $_SERVER['SCRIPT_NAME']; ?>\" + \"?v=none_sup&s=\" + start_day + \"&c=\" + count + \"\";\r\n});\r\n$(document).on(\"click\", \"#hold_btn\", function(){\r\n\t\r\n\tvar y = $(\"#start_y option:selected\").text();\r\n\tvar m = $(\"#start_m option:selected\").text();\r\n\tvar d = $(\"#start_d option:selected\").text();\r\n\tvar start_day = y + m + d;\r\n\tvar count = $(\"#column_count\").val();\r\n\t\r\n\twindow.location.href = \"<?php echo $_SERVER['SCRIPT_NAME']; ?>\" + \"?v=hold&s=\" + start_day + \"&c=\" + count + \"\";\r\n});\r\n\r\n\/\/\u66f4\u65b0\r\n$(document).on(\"click\", \"#start_position\", function(){\r\n\t\r\n\tvar y = $(\"#start_y option:selected\").text();\r\n\tvar m = $(\"#start_m option:selected\").text();\r\n\tvar d = $(\"#start_d option:selected\").text();\r\n\tvar start_day = y + m + d;\r\n\tvar count = $(\"#column_count\").val();\r\n\t\r\n\twindow.location.href = \"<?php echo $_SERVER['SCRIPT_NAME']; ?><?php if(array_key_exists(\"v\",$_GET) &#038;&#038; $_GET[\"v\"] != \"\"){ echo \"?v=\", $_GET[\"v\"], \"&#038;\"; }else{ echo \"?\"; } ?>s=\" + start_day + \"&c=\" + count + \"\";\r\n\r\n});\r\n\/\/\u672c\u65e5\r\n$(document).on(\"click\", \"#today_position\", function(){\r\n\t\r\n\tvar count = $(\"#column_count\").val();\r\n\twindow.location.href = \"<?php echo $_SERVER['SCRIPT_NAME']; ?><?php if(array_key_exists(\"v\",$_GET) &#038;&#038; $_GET[\"v\"] != \"\"){ echo \"?v=\", $_GET[\"v\"], \"&#038;\"; }else{ echo \"?\"; } ?>s=\" + <?php echo date(\"Ymd\"); ?> + \"&c=\" + count + \"\";\r\n\r\n});\r\n\r\n$(document).on(\"click\",\"#save_btn\",function(){\r\n\t$(\"#edit_div\").css(\"display\",\"none\");\r\n\t$(\"#save_div\").css(\"display\",\"block\");\r\n});\r\n\r\n\/\/\u4e2d\u6b62\r\n$(document).on(\"click\",\"#save_cancel_btn\",function(){\r\n\t$(\"#save_div\").css(\"display\",\"none\");\r\n});\r\n$(document).on(\"click\",\"#edit_cancel_btn\",function(){\r\n\t$(\"#edit_div\").css(\"display\",\"none\");\r\n});\r\n\r\n$(document).on(\"click\",\".edit_btn\",function(){\r\n\t\r\n\t$(\"#save_div\").css(\"display\",\"none\");\r\n\t\r\n\tvar id =          $(this).parent().parent().parent().parent().data(\"id\");\r\n\tvar kokyaku =     $(this).parent().parent().find(\".val_2\").children(\"p\").text();\r\n\tvar katashiki =   $(this).parent().parent().find(\".val_3\").children(\"p\").text();\r\n\tvar kouban =      $(this).parent().parent().find(\".val_4\").children(\"p\").text();\r\n\tvar suryo =       $(this).parent().parent().find(\".val_5\").children(\"p\").text();\r\n\tvar seisakusaki = $(this).parent().parent().find(\".val_6\").children(\"p\").text();\r\n\tvar tanka =       $(this).parent().parent().find(\".val_7\").children(\"p\").text();\r\n\t\r\n\t$(\"#edit_div\").css(\"display\",\"block\");\r\n\t\r\n\t\/\/\u8868\u793a\u3055\u305b\u3066\u3044\u308b\u306e\u306fdata-id\u3067\u306f\u306a\u304f\u30eb\u30fc\u30d7\u30ab\u30a6\u30f3\u30bf\r\n\t$(\"#update_id\").text($(this).parent().parent().parent().find(\".cap_1\").children(\"p\").text());\r\n\t\r\n\t$(\"#edit_id\").val(id);\r\n\r\n\t$(\"#edit_kokyaku\").val(kokyaku);\r\n\t$(\"#edit_katashiki\").val(katashiki);\r\n\t$(\"#edit_kouban\").val(kouban);\r\n\t$(\"#edit_suryo\").val(suryo);\r\n\t$(\"#edit_seisakusaki\").val(seisakusaki);\r\n\t$(\"#edit_tanka\").val(tanka.replace(\/,\/g,\"\"));\r\n});\r\n\r\n\/\/\u66f4\u65b0\u30fb\u524a\u9664\u30fb\u51fa\u8377\r\n$(document).on(\"click\",\"#edit_update_btn, #edit_delete_btn, #edit_hide_btn, #edit_hide_cancel_btn, #edit_hold_btn, #edit_hold_cancel_btn\",function(){\r\n\t\r\n\tvar condition =   $(this).attr(\"id\");\r\n\tvar id =          $(\"#edit_id\").val();\r\n\tvar kokyaku =     $(\"#edit_kokyaku\").val();\r\n\tvar katashiki =   $(\"#edit_katashiki\").val();\r\n\tvar kouban =      $(\"#edit_kouban\").val();\r\n\tvar suryo =       $(\"#edit_suryo\").val();\r\n\tvar seisakusaki = $(\"#edit_seisakusaki\").val();\r\n\tvar tanka =       $(\"#edit_tanka\").val();\r\n\tvar y =           $(\"#edit_year option:selected\").text();\r\n\tvar m =           $(\"#edit_month option:selected\").text();\r\n\r\n\t$.ajax({\r\n\t\ttype: \"POST\",\r\n\t\turl: \"edit_condition.php\",\r\n                timeout: 3000,\r\n\t\tacync: false,\r\n\t\tdata: {\r\n\t\t\tcondition: condition,\r\n\t\t\tid: id,\r\n\t\t\tkokyaku: kokyaku,\r\n\t\t\tkatashiki: katashiki,\r\n\t\t\tkouban: kouban,\r\n\t\t\tsuryo: suryo,\r\n\t\t\tseisakusaki: seisakusaki,\r\n\t\t\ttanka: tanka,\r\n\t\t\ty: y,\r\n\t\t\tm: m\r\n\t\t\t},\r\n\t\tdataType: \"html\",\r\n\t\tsuccess: function(data){\r\n\t\t\tif (data === \"false\"){\r\n\t\t\t\talert(\"\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3057\u305f\u3002\u51e6\u7406\u306f\u4e2d\u65ad\u3055\u308c\u307e\u3057\u305f\u3002\");\r\n\t\t\t\treturn;\r\n\t\t\t}\r\n\t\t\talert();\r\n\t\t\t$(\"#edit_div\").css(\"display\",\"none\");\r\n\t\t\twindow.location.reload();\r\n\t\t\t\r\n\t\t},error: function(){\r\n\t\t\talert(\"\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3057\u305f\u3002\u51e6\u7406\u306f\u4e2d\u65ad\u3055\u308c\u307e\u3057\u305f\u3002\");\r\n\t\t\treturn;\r\n\t\t}\r\n\t});\r\n});\r\n\r\n$(document).keydown(function(e){\r\n\tif(e.keyCode === 27){\r\n\t\t$(\"#edit_div\").css(\"display\",\"none\");\r\n\t\t$(\"#save_div\").css(\"display\",\"none\");\r\n\t\t$(\"#input_task_add\").remove();\r\n\t}\r\n});\r\n\t\r\n\t\r\n<\/script>\r\n<\/body>\r\n<\/html>\r\n\r\n<\/pre>\n<p>edit_condition.php<\/p>\n<pre class=\"lang:php decode:true \" >\r\n<?php\r\n\r\nif(!array_key_exists(\"condition\",$_POST)) exit(\"false\");\r\n\t\r\nrequire_once(\"class.php\");\r\n$db = Db::con();\r\n\r\nswitch ($_POST[\"condition\"]){\r\ncase \"edit_hold_btn\":\r\n    $sql = \"UPDATE gaisaku SET kanryo_kubun = 2 WHERE id = ?\";\r\n    break;\r\ncase \"edit_hold_cancel_btn\":\r\n    $sql = \"UPDATE gaisaku SET kanryo_kubun = NULL WHERE id= ?\";\r\n    break;\r\ncase \"edit_update_btn\":\r\n    $sql = \"UPDATE gaisaku SET tokui_saki = ?,katashiki = ?,koban = ?,suryo = ?,seisaku_saki = ?,tanka= ? WHERE id = ?\";\r\n    break;\r\ncase \"edit_hide_btn\":\r\n    $sql = \"UPDATE gaisaku SET kanryo_kubun = 1,syukka_zuki = ? WHERE id = ?\";\r\n    break;\r\ncase \"edit_hide_cancel_btn\":\r\n    $sql = \"UPDATE gaisaku SET kanryo_kubun = NULL, syukka_zuki = NULL WHERE id = ?\";\r\n    break;\r\ncase \"edit_delete_btn\":\r\n    $sql = \"DELETE FROM gaisaku WHERE id = ?\";\r\n    break;\r\n}\r\ntry{\r\n    $stmt = $db->prepare($sql);\r\n    switch($_POST[\"condition\"]){\r\n    case \"edit_hold_btn\":\r\n        $stmt->execute(array($_POST[\"id\"]));\r\n        break;\r\n    case \"edit_hold_cancel_btn\":\r\n        $stmt->execute(array($_POST[\"id\"]));\r\n        break;\r\n    case \"edit_update_btn\":\r\n        $stmt->execute(array($_POST[\"id\"],$_POST[\"kokyaku\"],$_POST[\"katashiki\"],$_POST[\"kouban\"],$_POST[\"suryo\"],$_POST[\"seisakusaki\"],$_POST[\"tanka\"]));\r\n        break;\r\n    case \"edit_hide_btn\":\r\n        $stmt->execute(array($_POST[\"id\"],$_POST[\"y\"] . \"-\" . $_POST[\"m\"] . \"-01\"));\r\n        break;\r\n    case \"edit_hide_cancel_btn\":\r\n        $stmt->execute(array($_POST[\"id\"]));\r\n        break;\r\n    case \"edit_delete_btn\":\r\n        $stmt->execute(array($_POST[\"id\"]));\r\n        break;\r\n    }\r\n} catch (PDOException $e) {\r\n    echo \"false\";\r\n}\r\n\r\n\r\n<\/pre>\n<p>edit.php<\/p>\n<pre class=\"lang:php decode:true \" >\r\n<div id=\"edit_div\">\r\n\r\n\t<div class=\"frm\">\r\n\t\t\u66f4\u65b0\uff1a[ <span id=\"update_id\"><\/span> ]\r\n\t\t\u9867\u5ba2\uff1a<input type=\"text\" name=\"kokyaku\" id=\"edit_kokyaku\"><input type=\"hidden\" name=\"id\" id=\"edit_id\">\r\n\t\t\u578b\u5f0f\uff1a<input type=\"text\" name=\"katashiki\" id=\"edit_katashiki\">\r\n\t\t\u5de5\u756a\uff1a<input type=\"text\" name=\"kouban\" id=\"edit_kouban\">\r\n\t\t\u6570\u91cf\uff1a<input type=\"text\" name=\"suryo\" id=\"edit_suryo\">\r\n\t\t\u88fd\u4f5c\u5148\uff1a<input type=\"text\" name=\"seisakusaki\" id=\"edit_seisakusaki\">\r\n\t<\/div>\r\n\r\n\t\u5358\u4fa1\uff1a<input type=\"text\" name=\"tanka\" id=\"edit_tanka\">\r\n\t<input type=\"submit\" value=\"\u3000\u66f4\u65b0\u3000\" id=\"edit_update_btn\">\r\n\t<input type=\"button\" value=\"\u3000\u4e2d\u6b62\u3000\" id=\"edit_cancel_btn\">\r\n\t<input type=\"button\" value=\"\u3000\u524a\u9664\u3000\" id=\"edit_delete_btn\">\r\n\t\r\n\t<!--\u51fa\u8377-->\r\n\t<?php if(array_key_exists(\"v\", $_GET) &#038;&#038; $_GET[\"v\"] == \"done\"): ?>\r\n\t\t<input type=\"button\" value=\"\u3000\u51fa\u8377\u53d6\u6d88\u3000\" id=\"edit_hide_cancel_btn\">\r\n\t<?php else: ?>\r\n\t(\r\n\t\t<select id=\"edit_year\">\r\n\t\t\t<option><?php echo date(\"Y\",strtotime(\"- 1 year\")); ?><\/option>\r\n\t\t\t<option selected ><?php echo date(\"Y\"); ?><\/option>\r\n\t\t\t<option><?php echo date(\"Y\",strtotime(\"+ 1 year\")); ?><\/option>\r\n\t\t<\/select>\r\n\t\t<select id=\"edit_month\">\r\n\t\t\t<?php\r\n\t\t\tfor($i=1; $i <= 12; $i++){\r\n\t\t\t\tif((int)date(\"m\",strtotime(\"$start_day\")) == $i){\r\n\t\t\t\t\tif($i < 10){ $i = \"0\" . $i; }\r\n\t\t\t\t\techo '<option selected>', $i, '<\/option>'; \r\n\t\t\t\t}else{\r\n\t\t\t\t\tif($i < 10){ $i = \"0\" . $i; }\r\n\t\t\t\t\techo '<option>', $i, '<\/option>'; \r\n\t\t\t\t}\r\n\t\t\t} \r\n\t\t\t?>\r\n\t\t<\/select>\r\n\t\t<input type=\"button\" value=\"\u3000\u51fa\u8377\u3000\" id=\"edit_hide_btn\">\r\n\t)\r\n\t<?php endif; ?>\r\n\t\r\n\t<!--\u4fdd\u7559-->\r\n\t<?php if(array_key_exists(\"v\", $_GET) &#038;&#038; $_GET[\"v\"] == \"hold\"): ?>\r\n\t\t<input type=\"button\" value=\"\u3000\u4fdd\u7559\u53d6\u6d88\u3000\" id=\"edit_hold_cancel_btn\">\r\n\t<?php else: ?>\r\n\t\t<input type=\"button\" value=\"\u3000\u4fdd\u7559\u3000\" id=\"edit_hold_btn\">\r\n\t<?php endif; ?>\r\n\t\r\n<\/div>\r\n<\/pre>\n<p>class.php<\/p>\n<pre class=\"lang:php decode:true \" >\r\n<?php\r\n\r\nclass Db{\r\n\tstatic public function con(){\r\n\t\ttry{\r\n\t\t\t$db = new PDO(\"mysql:host=localhost;dbname=db;\",\"id\",\"pass\");\r\n\t\t\t$db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);\r\n\t\t\treturn $db;\r\n\t\t\t\/\/$d = new PDO('sqlite::memory:',null,null,array(PDO::ATTR_PERSISTENT=>true));\/\/\u63a5\u7d9a\u306e\u6c38\u7d9a\u5316\t\r\n\t\t} catch(PDOException $e) {\r\n\t\t\texit(\"DB\u63a5\u7d9a\u4e0d\u5177\u5408\");\r\n\t\t}\t\t\r\n\t}\r\n}\r\n\r\n\/*\r\n\r\nuse okamura_post\r\n\r\ncreate table gaisaku (\r\n\tid int not null auto_increment primary key,\r\n\ttokui_saki varchar(32),\r\n\tkatashiki varchar(32),\r\n\tkoban bigint,\r\n\tsuryo int,\r\n\tseisaku_saki varchar(8),\r\n\tkanryo_kubun int,\r\n\tsyukka_zuki date,\r\n\ttanka decimal(12),\r\n\tkingaku decimal(12),\r\n\tsaisyu_koushinbi datetime\r\n) default character set=utf8;\r\n\r\ncreate table gaisaku_task (\r\n\tid int not null auto_increment primary key,\r\n\tgaisaku_id int,\r\n\ttask varchar(32),\r\n\tkensa_komoku varchar(32),\r\n\thizuke date\r\n) default character set=utf8;\r\n\r\n*\/\r\n<\/pre>\n<p>add_task.php<\/p>\n<pre class=\"lang:php decode:true \" >\r\n<?php\r\nrequire_once(\"class.php\");\r\n$db = Db::con();\r\ntry{\r\n\t$stmt = $db->prepare(\"INSERT INTO gaisaku_task (gaisaku_id,task,kensa_komoku,hizuke) VALUES (?,?,?,?)\");\r\n\t$stmt->execute(array($_POST[\"id\"],$_POST[\"task\"],$_POST[\"task_val\"],$_POST[\"ymd\"]));\r\n} catch (Exception $e) {\r\n\techo \"false\";\r\n}\r\n\r\n\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>table.php<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[3],"class_list":["post-435","post","type-post","status-publish","format-standard","hentry","category-1","tag-php"],"_links":{"self":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/435","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=435"}],"version-history":[{"count":1,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/435\/revisions"}],"predecessor-version":[{"id":436,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/435\/revisions\/436"}],"wp:attachment":[{"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}