{"id":665,"date":"2014-08-27T21:07:02","date_gmt":"2014-08-27T12:07:02","guid":{"rendered":"http:\/\/androiphone.uvs.jp\/?p=665"},"modified":"2015-11-09T13:51:00","modified_gmt":"2015-11-09T04:51:00","slug":"phpsqlite-pdo%e3%82%92%e4%bd%bf%e3%82%8f%e3%81%aa%e3%81%84%e3%81%a8sqlite3%e7%b3%bb%e3%81%ab%e6%8e%a5%e7%b6%9a%e3%81%a7%e3%81%8d%e3%81%aa%e3%81%84","status":"publish","type":"post","link":"https:\/\/androiphone.uvs.jp\/?p=665","title":{"rendered":"[PHP+SQLite] PDO\u3092\u4f7f\u308f\u306a\u3044\u3068SQLite3\u7cfb\u306b\u63a5\u7d9a\u3067\u304d\u306a\u3044"},"content":{"rendered":"<p><a href=\"http:\/\/sqlitebrowser.org\/\">SQLite Database Browser<\/a>\u3092\u3064\u304b\u3063\u3066\u3001\u30c0\u30df\u30fc\u30c7\u30fc\u30bf\u3092\u3064\u304f\u308a<\/p>\n<p>\u3055\u3041\u3001PHP\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3057\u3088\u3046\u3068\u601d\u3063\u305f\u3089\u30fb\u30fb\u30fb\u30fb<\/p>\n<blockquote>\n<p>Warning: sqlite_open(): file is encrypted or is not a database in test2.php on line 8 \u63a5\u7d9a\u5931\u6557\u3067\u3059\u3002<\/p>\n<p>file is encrypted or is not a database \u30fb\u30fb\u30fb<\/p>\n<\/blockquote>\n<p>\u3093\uff1f\u3044\u308d\u3044\u308d\u82e6\u62261\u6642\u9593\u3001\u3069\u3046\u3082PDO\u7d4c\u7531\u3067\u306a\u3044\u3068\u3001\u63a5\u7d9a\u3067\u304d\u306a\u3044\u30fb\u30fb\u30fb<\/p>\n<p>\u307e\u3041\u3001PHP\u3067\u306eDB\u51e6\u7406\u306fPDO\u304c\u63a8\u5968\u3055\u308c\u3066\u3044\u308b\u3088\u3046\u306a\u306e\u3067\u3001PDO\u306e\u30b5\u30f3\u30d7\u30eb\u3092\u3055\u304c\u3059 <\/p>\n<p><a href=\" http:\/\/blog.doli.jp\/blog\/2013\/post783\/\">http:\/\/blog.doli.jp\/blog\/2013\/post783\/<\/a> <a href=\"http:\/\/www.phpbook.jp\/tutorial\/pdo\/\">http:\/\/www.phpbook.jp\/tutorial\/pdo\/<\/a><\/p>\n<p><a href=\"http:\/\/log.noiretaya.com\/38\">http:\/\/log.noiretaya.com\/38<\/a><\/p>\n<p>\u3042\u305f\u308a\u3092\u30d1\u30af\u30ea\u306a\u304c\u3089<\/p>\n<pre>[php]\r\n&amp;lt;html&amp;gt;\r\n&amp;lt;head&amp;gt;&amp;lt;title&amp;gt;PHP TEST&amp;lt;\/title&amp;gt;&amp;lt;\/head&amp;gt;\r\n&amp;lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text\/html; charset=UTF-8&quot;&amp;gt;\r\n&amp;lt;body&amp;gt;\r\n\r\n&amp;lt;?php\r\n\r\n    try {\r\n      $db = new PDO('sqlite:test.db');\r\n      $db-&amp;gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\r\n    } catch (PDOException $e) {\r\n      die ('Connection failed : '.$e-&amp;gt;getMessage());\r\n    }\r\n    \r\n    try {\r\n      $sql = 'select * from data order by SCORE DESC;';\r\n      $stmt = $db-&amp;gt;query($sql);\r\n      \r\n      while($result = $stmt-&amp;gt;fetch(PDO::FETCH_ASSOC)){\r\n        print($result['SCORE'] .',' );\r\n        print($result['UDID'].',');\r\n        print($result['NAME'].'&amp;lt;br&amp;gt;');\r\n      }\r\n      \r\n    } catch (PDOException $e) {\r\n      $err = $db-&amp;gt;errorInfo();\r\n      die ($err[2]);\r\n    }\r\n    \r\n    unset($db);\r\n\r\n?&amp;gt;\r\n&amp;lt;\/body&amp;gt;\r\n&amp;lt;\/html&amp;gt;\r\n[\/php]<\/pre>\n<p>\u3067\u3001\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u30fb\u30fb\u30fb\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQLite Database Browser\u3092\u3064\u304b\u3063\u3066\u3001\u30c0\u30df\u30fc\u30c7\u30fc\u30bf\u3092\u3064\u304f\u308a \u3055\u3041\u3001PHP\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3057\u3088\u3046\u3068\u601d\u3063\u305f\u3089\u30fb\u30fb\u30fb\u30fb Warning: sqlite_open(): file is encrypted [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"","_original_post":"","footnotes":""},"categories":[18,16,17],"tags":[],"class_list":["post-665","post","type-post","status-publish","format-standard","hentry","category-html","category-php","category-sqlite","ja"],"_links":{"self":[{"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=\/wp\/v2\/posts\/665","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=665"}],"version-history":[{"count":4,"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=\/wp\/v2\/posts\/665\/revisions"}],"predecessor-version":[{"id":907,"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=\/wp\/v2\/posts\/665\/revisions\/907"}],"wp:attachment":[{"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}