| /PHP-7.4/ext/sqlite3/tests/ |
| H A D | sqlite3_05_delete.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
27 var_dump($db->exec("DELETE FROM test WHERE id = 'a'"));
|
| H A D | sqlite3_06_prepared_stmt.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
|
| H A D | sqlite3_07_prepared_stmt.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
|
| H A D | sqlite3_08_udf.phpt | 17 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
20 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
21 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
|
| H A D | sqlite3_09_blob_bound_param.phpt | 13 var_dump($db->exec('CREATE TABLE test (id STRING, data BLOB)'));
|
| H A D | sqlite3_10_bound_value_name.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
|
| H A D | sqlite3_11_numrows.phpt | 19 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
22 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
23 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
|
| H A D | sqlite3_12_unfinalized_stmt_cleanup.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
|
| H A D | sqlite3_13_skip_all_cleanup.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
|
| H A D | sqlite3_14_querysingle.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
|
| H A D | sqlite3_15_open_error-win.phpt | 12 $sysroot = exec('echo %systemroot%');
19 exec($cmd);
29 exec($cmd);
|
| H A D | sqlite3_16_select_no_results.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
|
| H A D | sqlite3_18_changes.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
19 var_dump($db->exec("UPDATE test SET id = 'c'"));
|
| H A D | sqlite3_19_columninfo.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
|
| H A D | sqlite3_23_escape_string.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", '" . SQLite3::escapeString…
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
|
| H A D | sqlite3_24_last_insert_rowid.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
17 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
|
| H A D | sqlite3_25_create_aggregate.phpt | 25 var_dump($db->exec('CREATE TABLE test (a INTEGER, b INTEGER)'));
28 var_dump($db->exec("INSERT INTO test (a, b) VALUES (1, -1)"));
29 var_dump($db->exec("INSERT INTO test (a, b) VALUES (2, -2)"));
30 var_dump($db->exec("INSERT INTO test (a, b) VALUES (3, -3)"));
31 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)"));
32 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)"));
|
| H A D | sqlite3_26_reset_prepared_stmt.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
|
| H A D | sqlite3_27_reset_prepared_stmt_result.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
|
| H A D | sqlite3_28_clear_bindings.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
|
| H A D | sqlite3_30_blobopen.phpt | 13 var_dump($db->exec('CREATE TABLE test (id STRING, data BLOB)'));
|
| H A D | sqlite3_35_stmt_readonly.phpt | 17 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
20 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
21 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
|
| H A D | sqlite3_36_create_collation.phpt | 12 $db->exec('CREATE TABLE t (s varchar(4))');
|
| H A D | sqlite3_38_backup.phpt | 11 $db->exec('CREATE TABLE test (a, b);');
12 $db->exec('INSERT INTO test VALUES (42, \'php\');');
35 var_dump($db->exec('BEGIN EXCLUSIVE;'));
|
| H A D | sqlite3_blob_bind_resource.phpt | 11 var_dump($db->exec('CREATE TABLE test (id STRING, data BLOB)'));
|
