{"version":"1.0","provider_name":"\u53f0\u5927\u7cfb\u7d71\u8a13\u7df4\u73ed\u8ab2\u7a0b\u7db2\u9801 (\u6797\u5947\u8ce6)","provider_url":"https:\/\/cflin.com\/wordpress","author_name":"Chifu","author_url":"https:\/\/cflin.com\/wordpress\/author\/daky","title":"[\u7b2c\u56db\u5802] php &amp; sqlite \u7bc4\u4f8b - \u53f0\u5927\u7cfb\u7d71\u8a13\u7df4\u73ed\u8ab2\u7a0b\u7db2\u9801 (\u6797\u5947\u8ce6)","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\"><a href=\"https:\/\/cflin.com\/wordpress\/42\/%e7%ac%ac%e5%9b%9b%e5%a0%82-php-sqlite-%e7%af%84%e4%be%8b\">[\u7b2c\u56db\u5802] php &amp; sqlite \u7bc4\u4f8b<\/a><\/blockquote>\n<script type='text\/javascript'>\n<!--\/\/--><![CDATA[\/\/><!--\n\t\t\/*! This file is auto-generated *\/\n\t\t!function(c,d){\"use strict\";var e=!1,n=!1;if(d.querySelector)if(c.addEventListener)e=!0;if(c.wp=c.wp||{},!c.wp.receiveEmbedMessage)if(c.wp.receiveEmbedMessage=function(e){var t=e.data;if(t)if(t.secret||t.message||t.value)if(!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var r,a,i,s=d.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),n=d.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),o=0;o<n.length;o++)n[o].style.display=\"none\";for(o=0;o<s.length;o++)if(r=s[o],e.source===r.contentWindow){if(r.removeAttribute(\"style\"),\"height\"===t.message){if(1e3<(i=parseInt(t.value,10)))i=1e3;else if(~~i<200)i=200;r.height=i}if(\"link\"===t.message)if(a=d.createElement(\"a\"),i=d.createElement(\"a\"),a.href=r.getAttribute(\"src\"),i.href=t.value,i.host===a.host)if(d.activeElement===r)c.top.location.href=t.value}}},e)c.addEventListener(\"message\",c.wp.receiveEmbedMessage,!1),d.addEventListener(\"DOMContentLoaded\",t,!1),c.addEventListener(\"load\",t,!1);function t(){if(!n){n=!0;for(var e,t,r=-1!==navigator.appVersion.indexOf(\"MSIE 10\"),a=!!navigator.userAgent.match(\/Trident.*rv:11\\.\/),i=d.querySelectorAll(\"iframe.wp-embedded-content\"),s=0;s<i.length;s++){if(!(e=i[s]).getAttribute(\"data-secret\"))t=Math.random().toString(36).substr(2,10),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t);if(r||a)(t=e.cloneNode(!0)).removeAttribute(\"security\"),e.parentNode.replaceChild(t,e)}}}}(window,document);\n\/\/--><!]]>\n<\/script><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/cflin.com\/wordpress\/42\/%e7%ac%ac%e5%9b%9b%e5%a0%82-php-sqlite-%e7%af%84%e4%be%8b\/embed\" width=\"600\" height=\"338\" title=\"&#8220;[\u7b2c\u56db\u5802] php &amp; sqlite \u7bc4\u4f8b&#8221; &#8212; \u53f0\u5927\u7cfb\u7d71\u8a13\u7df4\u73ed\u8ab2\u7a0b\u7db2\u9801 (\u6797\u5947\u8ce6)\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe>","description":"&lt;form action=\"\" method=\"post\" name=\"form1&#8243;&gt;&lt;br&gt; Input address book data:&lt;br&gt; &lt;input name=\"name\" type=\"text\" value=\"shinder\"&gt;&lt;br&gt; &lt;input name=\"phone\" type=\"text\" value=\"0918981520&#8243;&gt;&lt;br&gt; &lt;input name=\"address\" type=\"text\" value=\"Taipei\"&gt;&lt;br&gt; &lt;input name=\"submit\" type=\"submit\" value=\"Add\"&gt;&lt;br&gt; &lt;?php \/\/\u5efa\u7acb\u8cc7\u6599\u9023\u7dda\u7269\u4ef6 $pdo = new PDO(&#8220;sqlite:mydb.sqlite\"); $pdo-&gt;exec(&#8220;CREATE TABLE address_book ( sid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , name VARCHAR, phone VARCHAR, address VARCHAR, creation_date DATETIME DEFAULT CURRENT_TIMESTAMP)\"); if(count($_POST)&gt;0) { \/\/ &hellip; \u95b1\u8b80\u5168\u6587 &rarr;"}