xref: /PHP-5.3/ext/sqlite/tests/sqlite_026.phpt (revision 610c7fbe)
1--TEST--
2sqlite: sqlite_fetch_column_types
3--SKIPIF--
4<?php # vim:ft=php
5if (!extension_loaded("sqlite")) print "skip"; ?>
6--FILE--
7<?php
8include "blankdb.inc";
9
10sqlite_query($db, "CREATE TABLE strings(a, b INTEGER, c VARCHAR(10), d)");
11sqlite_query($db, "INSERT INTO strings VALUES('1', '2', '3', 'abc')");
12
13var_dump(sqlite_fetch_column_types($db, "strings"));
14
15sqlite_close($db);
16?>
17--EXPECT--
18array(4) {
19  ["a"]=>
20  string(0) ""
21  ["b"]=>
22  string(7) "INTEGER"
23  ["c"]=>
24  string(11) "VARCHAR(10)"
25  ["d"]=>
26  string(0) ""
27}
28