Changes between Version 18 and Version 19 of jazz/09-09-11

Timestamp:

May 15, 2010, 9:05:20 PM (15 years ago)

Author:

jazz

Comment:

--

jazz/09-09-11

@@ -161 +161 @@
 }}}
  * [http://tw.php.net/sqlite PHP: SQLite - Manual] - PHP 存取 SQLite 的原文手冊
- * [http://support.oss.org.tw/wiki/index.php/Php_sqlite PHP-SQLite - 資策會技術支援資料庫]
+ * [http://wiki.oss.org.tw/index.php/Php_sqlite PHP-SQLite - 資策會技術支援資料庫]
+{{{
+<?PHP
+ 
+$db = sqlite_open('ex3.db', 0666, $sqliteerror);
+$query = sqlite_query($db, "SELECT * FROM tbl");
+var_dump($query);
+sqlite_close($db);
+?>
+}}}
+{{{
+<?PHP
+$db = sqlite_open('ex3.db', 0666, $sqliteerror);
+$query = sqlite_array_query($db, "SELECT * FROM tbl", SQLITE_ASSOC);
+//Object-oriented style
+//$dbhandle = new SQLiteDatabase('ex3.db');
+//$query = $dbhandle->arrayQuery('SELECT * FROM tbl', SQLITE_ASSOC);
+ 
+foreach ($query as $entry) {
+echo Title: ' . $entry['title'] . ' Length: ' . $entry['length'];
+echo "<br>";
+}
+?>
+}}}
  
 == OpenPBS / Torque ==