1 files changed, 36 insertions, 0 deletions
diff --git a/ext/sqlite/sqlite.php b/ext/sqlite/sqlite.php
new file mode 100644
index 000000000..527504b72
--- /dev/null
+++ b/ext/sqlite/sqlite.php
@@ -0,0 +1,36 @@
+<?php
+if (!extension_loaded("sqlite")) {
+	dl("sqlite.so");
+	if (!extension_loaded("sqlite")) {
+		exit("Please enable SQLite support\n");
+	}
+}
+
+debug_zval_dump(sqlite_libversion());
+debug_zval_dump(sqlite_libencoding());
+
+$s = sqlite_open("weztest.sqlite", 0666, $err);
+
+debug_zval_dump($err);
+debug_zval_dump($s);
+
+$r = sqlite_query("create table foo (a INTEGER PRIMARY KEY, b INTEGER )", $s);
+debug_zval_dump(sqlite_last_error($s));
+debug_zval_dump(sqlite_error_string(sqlite_last_error($s)));
+
+$r = sqlite_query("select *, php('md5', sql) as o from sqlite_master", $s);
+debug_zval_dump($r);
+debug_zval_dump(sqlite_num_rows($r));
+debug_zval_dump(sqlite_num_fields($r));
+
+for ($j = 0; $j < sqlite_num_fields($r); $j++) {
+	echo "Field $j is " . sqlite_field_name($r, $j) . "\n";
+}
+
+while ($row = sqlite_fetch_array($r, SQLITE_ASSOC)) {
+	print_r($row);
+}
+
+sqlite_close($s);
+
+?>