{"id":27,"date":"2006-06-13T18:00:18","date_gmt":"2006-06-13T09:00:18","guid":{"rendered":"https:\/\/deskplate.net\/blog\/2006\/06\/13\/pear-db-%e6%9b%b4%e6%96%b0-2\/"},"modified":"2006-06-13T18:00:18","modified_gmt":"2006-06-13T09:00:18","slug":"pear-db-%e6%9b%b4%e6%96%b0-2","status":"publish","type":"post","link":"https:\/\/deskplate.net\/blog\/archives\/27","title":{"rendered":"Pear DB \u66f4\u65b0"},"content":{"rendered":"<p>\/\/PEAR\u306eDB\u30af\u30e9\u30b9\u5b9a\u7fa9\u3092\u8aad\u307f\u8fbc\u3080<br \/>\nrequire_once(&#8216;DB.php&#8217;);<br \/>\n\/\/config \u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u8fbc\u3080<br \/>\nrequire_once(&#8216;..\/config.php&#8217;);<br \/>\n\/\/\u63a5\u7d9a<br \/>\n$con = DB::connect($dsn);<br \/>\n\/\/ \u63a5\u7d9a\u306b\u5931\u6557\u3057\u305f\u3089\u30a8\u30e9\u30fc\u8868\u793a\u3057\u3066\u7d42\u4e86<br \/>\nif (DB::isError($db)) exit($db->getMessage());<br \/>\n\/\/\u30aa\u30fc\u30c8\u30b3\u30df\u30c3\u30c8\u30bb\u30c3\u30c8<br \/>\n$con->autoCommit();<br \/>\n\/\/sql\u6587\u4f5c\u6210<br \/>\n$preSql =  &#8220;INSERT INTO \u30c6\u30fc\u30d6\u30eb\u540d ( \u30ab\u30e9\u30e0\u540d, \u30ab\u30e9\u30e0\u540d ) VALUES ( ?, ? )&#8221;;<br \/>\n\/\/\u30d7\u30ea\u30b3\u30f3\u30d1\u30a4\u30eb\u6e08\u307f\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u4f5c\u6210<br \/>\n$stmt   = $con->prepare($preSql);<br \/>\n\/\/\u30d0\u30ea\u30e5\u30fc\u8a2d\u5b9a<br \/>\n$data   = array( \u5024, \u5024 );<br \/>\n\/\/\u5b9f\u884c<br \/>\n$res \t= $con->execute($stmt,$data);<br \/>\n\/\/\u30b3\u30df\u30c3\u30c8<br \/>\n$con->commit();<br \/>\n\/\/\u3053\u308c\u306f\u672c\u5f53\u306b\u5fc5\u8981\u306a\u306e\u304b\uff1f<br \/>\n$con->freePrepared($stmt);<br \/>\n\/\/\u5207\u65ad<br \/>\n$con->disConnect();<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\/\/PEAR\u306eDB\u30af\u30e9\u30b9\u5b9a\u7fa9\u3092\u8aad\u307f\u8fbc\u3080 <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-27","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/posts\/27","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/comments?post=27"}],"version-history":[{"count":0,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/posts\/27\/revisions"}],"wp:attachment":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/media?parent=27"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/categories?post=27"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/tags?post=27"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}