1--TEST--
2SQLite3 columnType and columnName
3--EXTENSIONS--
4sqlite3
5--FILE--
6<?php
7
8require_once(__DIR__ . '/new_db.inc');
9define('TIMENOW', time());
10
11echo "Creating Table\n";
12var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
13
14echo "INSERT into table\n";
15var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
17
18echo "SELECTING results\n";
19$result = $db->query("SELECT * FROM test ORDER BY id ASC");
20while ($row = $result->fetchArray(SQLITE3_NUM)) {
21    $totalColumns = $result->numColumns();
22    for ($i = 0; $i < $totalColumns; $i++) {
23        echo "Name: " . $result->columnName($i) . " - Type: " . $result->columnType($i) . "\n";
24    }
25}
26$result->finalize();
27
28echo "Closing database\n";
29var_dump($db->close());
30echo "Done\n";
31?>
32--EXPECT--
33Creating Table
34bool(true)
35INSERT into table
36bool(true)
37bool(true)
38SELECTING results
39Name: time - Type: 1
40Name: id - Type: 3
41Name: time - Type: 1
42Name: id - Type: 3
43Closing database
44bool(true)
45Done
46