<form action=\"\" method=\"post\" name=\"form1″><br>
\nInput address book data:<br>
\n<input name=\"name\" type=\"text\" value=\"shinder\"><br>
\n<input name=\"phone\" type=\"text\" value=\"0918981520″><br>
\n<input name=\"address\" type=\"text\" value=\"Taipei\"><br>
\n<input name=\"submit\" type=\"submit\" value=\"Add\"><br><\/p>\n
<?php<\/p>\n
\/\/\u5efa\u7acb\u8cc7\u6599\u9023\u7dda\u7269\u4ef6
\n$pdo = new PDO(“sqlite:mydb.sqlite\");<\/p>\n
$pdo->exec(“CREATE TABLE address_book (
\nsid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL ,
\nname VARCHAR,
\nphone VARCHAR,
\naddress VARCHAR,
\ncreation_date DATETIME DEFAULT CURRENT_TIMESTAMP)\");
\nif(count($_POST)>0) {
\n\/\/ \u6e96\u5099\u65b0\u589e\u8cc7\u6599\u7684\u8a9e\u6cd5
\n$name = $_POST[“name\"];
\n$phone = $_POST[“phone\"];
\n$address = $_POST[“address\"];
\n$pdo->exec(“INSERT INTO ‘address_book’ (‘name’, ‘phone’, ‘address’ )
\nVALUES( ‘$name’, ‘$phone’, ‘$address’)\");
\n}<\/p>\n
$pdoStatement = $pdo->prepare(“SELECT * FROM address_book\");
\n$pdoStatement->execute();
\n$arr;
\nwhile($row = $pdoStatement->fetch(PDO::FETCH_ASSOC) ) {
\nprint_r( $row );
\n}<\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
<form action=\"\" method=\"post\" name=\"form1″><br> Input address book data:<br> <input name=\"name\" type=\"text\" value=\"shinder\"><br> <input name=\"phone\" type=\"text\" value=\"0918981520″><br> <input name=\"address\" type=\"text\" value=\"Taipei\"><br> <input name=\"submit\" type=\"submit\" value=\"Add\"><br> <?php \/\/\u5efa\u7acb\u8cc7\u6599\u9023\u7dda\u7269\u4ef6 $pdo = new PDO(“sqlite:mydb.sqlite\"); $pdo->exec(“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)>0) { \/\/ … \u95b1\u8b80\u5168\u6587 [\u7b2c\u56db\u5802] php & sqlite \u7bc4\u4f8b<\/span>