7
if (!extension_loaded("sqlite")) print "skip"; ?>
10
include "blankdb.inc";
13
array (0 => 'one', 1 => 'two'),
14
array (0 => 'three', 1 => 'four')
17
sqlite_query("CREATE TABLE strings(a VARCHAR, b VARCHAR)", $db);
19
foreach ($data as $str) {
20
sqlite_query("INSERT INTO strings VALUES('${str[0]}','${str[1]}')", $db);
23
echo "====BUFFERED====\n";
24
$r = sqlite_query("SELECT a, b from strings", $db);
25
while (sqlite_valid($r)) {
26
var_dump(sqlite_current($r, SQLITE_NUM));
27
var_dump(sqlite_column($r, 0));
28
var_dump(sqlite_column($r, 1));
29
var_dump(sqlite_column($r, 'a'));
30
var_dump(sqlite_column($r, 'b'));
33
echo "====UNBUFFERED====\n";
34
$r = sqlite_unbuffered_query("SELECT a, b from strings", $db);
35
while (sqlite_valid($r)) {
36
var_dump(sqlite_column($r, 0));
37
var_dump(sqlite_column($r, 'b'));
38
var_dump(sqlite_column($r, 1));
39
var_dump(sqlite_column($r, 'a'));