\u30ec\u30f3\u30b5\u30d0\u7b49\u3067PHP\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u3063\u3066\u4ee5\u4e0b\u3092\u8cbc\u4ed8\u3051\u308c\u3070\u5b9f\u884c\u53ef\u80fd\u3002
\n\u30c7\u30fc\u30bf\u306fSQLite\u306b\u4fdd\u5b58\u3055\u308c\u308b\u3002<\/p>\n
<\/p>\n
<?php\r\n\r\nini_set(\"display_errors\", \"1\");\r\nini_set(\"error_reporting\", E_ALL);\r\n\r\n$data = file_get_contents(\"php:\/\/input\");\r\nif (strlen($data) > 0){\r\n \r\n \/\/$data_array = json_decode($data, true);\r\n \/\/file_put_contents(\"log.txt\", \"value:\" . $data_array[\"rc001001\"][\"value\"] . \", css:\" . $data_array[\"rc001001\"][\"css\"]);\r\n\r\n \/\/file_put_contents(\"log.txt\",$data);\r\n \r\n if(file_exists(\"db.sql\")){\r\n if ($db = sqlite_open(\"db.sql\", 0666, $e)) {\r\n sqlite_query($db, \"DROP TABLE tbl\");\r\n sqlite_query($db, \"CREATE TABLE tbl (col)\");\r\n sqlite_query($db, \"INSERT INTO tbl (col) VALUES ('$data')\");\r\n } else {\r\n die($e);\r\n } \r\n }else{\r\n if ($db = sqlite_open(\"db.sql\", 0666, $e)) {\r\n sqlite_query($db, \"CREATE TABLE tbl (col)\");\r\n sqlite_query($db, \"INSERT INTO tbl (col) VALUES ('$data')\");\r\n } else {\r\n die($e);\r\n } \r\n }\r\n\r\n \/\/header(\"Content-Type: text\/javascript; charset=utf-8\");\r\n \/\/echo $data;\r\n \r\n \/\/$result = sqlite_query($db, \"SELECT col FROM tbl\");\r\n \/\/var_dump(sqlite_fetch_array($result));\r\n \r\n exit(); \r\n}\r\n\r\n?>\r\n<html lang=\"ja\">\r\n<head>\r\n <meta charset=\"utf-8\">\r\n <style>\r\n body{\r\n margin: 0;\r\n }\r\n body, input[type=\"button\"]{\r\n font-size: 11px; font-family: \"\u30e1\u30a4\u30ea\u30aa\";\r\n }\r\n input[type=\"button\"]{\r\n width: 100px;\r\n margin: 5px 0 5px 5px;\r\n }\r\n #screen{\r\n width: 100%; height: 100%;\r\n background-color: blue; opacity: 0.1;\r\n position: absolute; z-index: 1;\r\n }\r\n #container{\r\n width: 90%; height: 90%;\r\n overflow: scroll; -webkit-overflow-scrolling: touch;\r\n }\r\n table{\r\n border-collapse: collapse;\r\n }\r\n td{\r\n border: 1px solid #ccc;\r\n cursor: pointer;\r\n min-width: 15px; height: 15px;\r\n }\r\n\r\n <\/style>\r\n <script src=\"http:\/\/code.jquery.com\/jquery-1.11.1.min.js\"><\/script>\r\n<\/head>\r\n<body>\r\n<div id=\"screen\"><\/div>\r\n<div><input type=\"button\" id=\"s\" value=\"save\"><input type=\"button\" id=\"c\" value=\"cancel\"><\/div>\r\n<div id=\"container\">\r\n <table>\r\n <?php\r\n for($r = 1; $r <= 30; $r++){\r\n echo \"<tr>\";\r\n for($c = 1; $c <= 30; $c++){\r\n echo '<td class=\"r' . str_pad($r,3,0,STR_PAD_LEFT) . ' ' . 'c' . str_pad($c,3,0,STR_PAD_LEFT) . '\" ';\r\n echo 'id=\"' . 'rc' . str_pad($r,3,0,STR_PAD_LEFT) . str_pad($c,3,0,STR_PAD_LEFT) . '\">';\r\n echo '';\r\n echo '<\/td>';\r\n }\r\n echo \"<\/tr>\";\r\n }\r\n ?>\r\n <\/table>\r\n <p>\r\n ctrl\u3092\u62bc\u3057\u306a\u304c\u3089\u30de\u30a6\u30b9\u3092\u52d5\u304b\u3059\u3068\u66f8\u3051\u308b\u3002shift\u3092\u62bc\u3057\u306a\u304c\u3089\u30de\u30a6\u30b9\u3092\u52d5\u304b\u3059\u3068\u6d88\u305b\u308b\u3002<br>\r\n \u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u30c6\u30ad\u30b9\u30c8\u5165\u529b\u3067\u304d\u308b\u3002enter\u304besc\u304b\u30d5\u30a9\u30fc\u30ab\u30b9\u3092\u629c\u304f\u3068\u78ba\u5b9a(\u30ad\u30e3\u30f3\u30bb\u30eb\u51e6\u7406\u306f\u306a\u3057)\u3002\r\n <\/p>\r\n<\/div>\r\n\r\n<script>\r\n\r\n$(\"input#s\").on(\"click\",function(){\r\n \r\n $(\"input#s, input#c\").attr(\"disabled\",\"\");\r\n \r\n var data = {};\r\n var id;\r\n \r\n for(var r = 1; r <= 30; r++){\r\n for(var c = 1; c <= 30; c++){\r\n id = \"rc\" + (\"00\" + r).slice(-3) + (\"00\" + c).slice(-3) + \"\";\r\n data[id] = {\r\n \"value\": $(\"#\" + id + \"\").text(),\r\n \"css\": $(\"#\" + id + \"\").css(\"background-color\")\r\n };\r\n }\r\n }\r\n \/\/contentType: \"application\/json\", dataType: \"json\", data: JSON.stringify(data),\r\n $.ajax({\r\n type: \"post\", url: \"\", async: true, dataType: \"text\", data: JSON.stringify(data), \r\n success: function(data){\r\n \/\/console.log(data);\r\n alert(\"OK\");\r\n $(\"input#s, input#c\").attr(\"disabled\", false);\r\n \r\n window.location.reload();\r\n \r\n },error: function(){\r\n alert(\"NG\");\r\n $(\"input#s, input#c\").attr(\"disabled\", false);\r\n }\r\n });\r\n \r\n});\r\n\r\n$(\"input#c\").on(\"click\",function(){\r\n window.location.reload();\r\n});\r\n\r\n$(\"td\").on(\"mousemove\",function(i){\r\n if (i.ctrlKey) {\r\n $(this).css(\"background-color\",\"#ccc\");\r\n } else if (i.shiftKey) {\r\n $(this).css(\"background-color\",\"white\");\r\n }\r\n});\r\n\r\n$(\"td\").on(\"click\", function(i){\r\n $(\"<input><\/input>\",{\r\n \"type\": \"text\",\r\n \"value\": $(i.target).text(),\r\n \"css\": {\r\n \"position\": \"absolute\", \"z-index\": \"1\",\r\n \"top\": i.pageY, \"left\": i.pageX\r\n }\r\n }).on(\"keydown\", function(k){\r\n if (k.keyCode === 13 || k.keyCode === 27) {\r\n $(i.target).text( $(this).val() );\r\n $(this).remove();\r\n }\r\n }).appendTo(\"body\").focus().blur(function(){\r\n $(i.target).text( $(this).val() );\r\n $(this).remove(); \r\n });\r\n});\r\n\r\n$(window).on(\"load\",function(){\r\n $(\"#screen\").hide();\r\n});\r\n\r\n<\/script>\r\n<?php\r\nif(file_exists(\"db.sql\")){\r\n if ($db = sqlite_open(\"db.sql\", 0666, $e)) {\r\n $row = sqlite_fetch_array(sqlite_query($db, \"SELECT col FROM tbl\"));\r\n echo \"<script>\";\r\n echo \"var result = $row[0];\";\r\n echo \"<\/script><script>\";\r\n \r\n echo 'for(var r = 1; r <= 30; r++){\r\n for(var c = 1; c <= 30; c++){\r\n var id = \"rc\" + (\"00\" + r).slice(-3) + (\"00\" + c).slice(-3) + \"\";\r\n $(\"#\" + id + \"\").css(\"background-color\", result[id].css);\r\n $(\"#\" + id + \"\").text(result[id].value); \r\n }\r\n }';\r\n echo \"<\/script>\";\r\n } \r\n}\r\n?>\r\n<\/body>\r\n<\/html><\/pre>\n","protected":false},"excerpt":{"rendered":"\u30ec\u30f3\u30b5\u30d0\u7b49\u3067PHP\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u3063\u3066\u4ee5\u4e0b\u3092\u8cbc\u4ed8\u3051\u308c\u3070\u5b9f\u884c\u53ef\u80fd\u3002 \u30c7\u30fc\u30bf\u306fSQLite\u306b\u4fdd\u5b58\u3055\u308c\u308b\u3002 <?php ini_set(“display_errors”, “1”); ini_set(“erro … <\/p>\n