From 25954d1d7259cced795089cf67a46c42a37eac03 Mon Sep 17 00:00:00 2001
From: Wez Furlong <wez@php.net>
Date: Thu, 17 Apr 2003 01:29:45 +0000
Subject: This commit was generated by cvs2svn to compensate for changes in
 r123706, which included commits to RCS files with non-trunk default branches.

---
 ext/sqlite/sqlite.php | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 ext/sqlite/sqlite.php

(limited to 'ext/sqlite/sqlite.php')

diff --git a/ext/sqlite/sqlite.php b/ext/sqlite/sqlite.php
new file mode 100644
index 0000000000..40ba9d2195
--- /dev/null
+++ b/ext/sqlite/sqlite.php
@@ -0,0 +1,28 @@
+<?php
+dl("sqlite.so");
+
+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);
+$r = sqlite_query("select * 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);
+
+?>
-- 
cgit v1.2.1