1--TEST-- 2sqlite: returned associative column names 3--INI-- 4sqlite.assoc_case=0 5--SKIPIF-- 6<?php 7if (!extension_loaded("sqlite")) print "skip"; ?> 8--FILE-- 9<?php 10include "blankdb.inc"; 11 12sqlite_query("CREATE TABLE foo (c1 char, c2 char, c3 char)", $db); 13sqlite_query("CREATE TABLE bar (c1 char, c2 char, c3 char)", $db); 14sqlite_query("INSERT INTO foo VALUES ('1', '2', '3')", $db); 15sqlite_query("INSERT INTO bar VALUES ('4', '5', '6')", $db); 16$r = sqlite_query("SELECT * from foo, bar", $db, SQLITE_ASSOC); 17var_dump(sqlite_fetch_array($r)); 18sqlite_close($db); 19?> 20--EXPECT-- 21array(6) { 22 ["foo.c1"]=> 23 string(1) "1" 24 ["foo.c2"]=> 25 string(1) "2" 26 ["foo.c3"]=> 27 string(1) "3" 28 ["bar.c1"]=> 29 string(1) "4" 30 ["bar.c2"]=> 31 string(1) "5" 32 ["bar.c3"]=> 33 string(1) "6" 34} 35
