diff options
author | Wez Furlong <wez@php.net> | 2003-04-17 01:29:45 +0000 |
---|---|---|
committer | Wez Furlong <wez@php.net> | 2003-04-17 01:29:45 +0000 |
commit | 25954d1d7259cced795089cf67a46c42a37eac03 (patch) | |
tree | bb8c0ab2ff520f50415e97cec497e16d427bf537 /ext/sqlite/sqlite.php | |
parent | 0c366c24e5d21ebd375d295b27ffebc6636497f7 (diff) | |
download | php-git-25954d1d7259cced795089cf67a46c42a37eac03.tar.gz |
This commit was generated by cvs2svn to compensate for changes in r123706,
which included commits to RCS files with non-trunk default branches.
Diffstat (limited to 'ext/sqlite/sqlite.php')
-rw-r--r-- | ext/sqlite/sqlite.php | 28 |
1 files changed, 28 insertions, 0 deletions
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); + +?> |