Home
last modified time | relevance | path

Searched refs:db (Results 151 – 175 of 868) sorted by relevance

12345678910>>...35

/php-src/ext/pgsql/tests/
H A Dbug64609.phpt18 $db = pg_connect($conn_str);
19 pg_query($db, "BEGIN");
20 pg_query($db, "CREATE TYPE {$type_name} AS ENUM ('ok', 'ko')");
21 pg_query($db, "CREATE TABLE {$table_name} (a {$type_name})");
24 $converted = pg_convert($db, $table_name, $fields);
26 pg_query($db, "ROLLBACK");
H A Dgh10672.phpt16 $db = pg_connect($conn_str);
17 pg_query($db, "CREATE TABLE {$table_name} (bar text);");
20 pg_query($db, 'BEGIN');
23 $oid = pg_lo_create($db);
26 die(pg_last_error($db));
30 $lob = pg_lo_open($db, $oid, 'w');
33 die(pg_last_error($db));
H A Dgh8253.phpt18 $db = pg_connect($conn_str);
19 pg_query($db, "CREATE TABLE {$table_name} (bar text);");
20 pg_insert($db, $table_name, $a);
21 $res = pg_query($db, "SELECT * FROM {$table_name}");
29 $db = pg_connect($conn_str);
30 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
/php-src/ext/sqlite3/tests/
H A Dbug73068.phpt13 $db = new \SQLite3(':memory:') ;
15 $db->exec("CREATE TABLE IF NOT EXISTS t1(a INT UNIQUE, b INT)");
16 $db->exec("INSERT OR REPLACE INTO t1(a,b) VALUES('1','2')");
18 $r = $db->query("SELECT * FROM t1 WHERE a='1' AND b='2'");
21 $db->exec("DELETE FROM t1 WHERE a='1' AND b='2'");
23 $r = $db->query("SELECT * FROM t1;");
26 $db->close();
H A Dsqlite3_25_create_aggregate.phpt25 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)"));
34 $db->createAggregate('S', 'sum_list_step', 'sum_list_finalize', 1);
36 print_r($db->querySingle("SELECT S(a), S(b) FROM test", true));
39 var_dump($db->close());
H A Dsqlite3_31_open.phpt12 $db = new SQLite3(__DIR__ . '/db1.db');
13 $db->open(__DIR__ . '/db1.db');
20 <?php @unlink(__DIR__ . '/db1.db'); ?>
H A Dsqlite3_37_createfunction_flags.phpt15 var_dump($db->createfunction($func, $func, 1, SQLITE3_DETERMINISTIC));
16 var_dump($db->querySingle('SELECT strtoupper("test")'));
19 var_dump($db->createfunction($func2, $func2, 1, SQLITE3_DETERMINISTIC));
20 var_dump($db->querySingle('SELECT strtolower("TEST")'));
22 var_dump($db->createfunction($func, $func2, 1, SQLITE3_DETERMINISTIC));
23 var_dump($db->querySingle('SELECT strtoupper("tEst")'));
H A Dgh9032.phpt9 $db = new SQLite3(":memory:");
10 $db->enableExceptions(true);
12 $db->exec('attach database \':memory:\' AS "db1"');
13 var_dump($db->exec('create table db1.r (id int)'));
16 $st = $db->prepare('attach database :a AS "db2"');
19 var_dump($db->exec('create table db2.r (id int)'));
/php-src/ext/pdo_mysql/tests/
H A Dbug_41698.phpt13 $db = MySQLPDOTest::factory();
17 $db->exec('CREATE TABLE test_41698(floatval DECIMAL(8,6))');
18 $db->exec('INSERT INTO test_41698 VALUES(2.34)');
20 $stmt = $db->prepare('INSERT INTO test_41698 VALUES(?)');
22 var_dump($db->query('SELECT * FROM test_41698')->fetchAll(PDO::FETCH_ASSOC));
27 $db = MySQLPDOTest::factory();
28 $db->exec("DROP TABLE IF EXISTS test_41698");
H A Dpdomysql_001.phpt15 $db = MySQLPDOTest::factory(Pdo\Mysql::class);
17 $db->query('CREATE TABLE pdomysql_001 (id INT, name TEXT)');
19 $db->query('INSERT INTO pdomysql_001 VALUES (NULL, "PHP")');
20 $db->query('INSERT INTO pdomysql_001 VALUES (NULL, "PHP6")');
22 foreach ($db->query('SELECT name FROM pdomysql_001') as $row) {
31 $db = MySQLPDOTest::factory();
32 $db->exec('DROP TABLE IF EXISTS pdomysql_001');
H A Dbug44327.phpt13 $db = MySQLPDOTest::factory();
14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
16 $stmt = $db->prepare("SELECT 1 AS \"one\"");
26 $db->exec("CREATE TABLE test_44327 (id INT)");
27 $db->exec("INSERT INTO test_44327(id) VALUES (1)");
28 $stmt = $db->prepare("SELECT id FROM test_44327");
36 $stmt = $db->prepare('foo');
44 $db = MySQLPDOTest::factory();
45 $db->exec("DROP TABLE test_44327");
H A Dpdo_mysql_stmt_closecursor.phpt14 $db = MySQLPDOTest::factory();
18 function pdo_mysql_stmt_closecursor($db) {
119 MySQLPDOTest::createTestTable($table, $db);
120 pdo_mysql_stmt_closecursor($db);
124 MySQLPDOTest::createTestTable($table, $db);
125 pdo_mysql_stmt_closecursor($db);
133 MySQLPDOTest::createTestTable($table, $db);
135 pdo_mysql_stmt_closecursor($db);
140 pdo_mysql_stmt_closecursor($db);
144 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
[all …]
H A Dpdo_mysql_stmt_fetch_non_select.phpt13 $db = MySQLPDOTest::factory();
16 MySQLPDOTest::createTestTable($table, $db);
21 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
78 $db->exec('DEALLOCATE PREPARE mystmt');
84 var_export($db->errorInfo(), true));
112 $db->exec('DEALLOCATE PREPARE mystmt');
118 var_export($db->errorInfo(), true));
145 $db->exec('DEALLOCATE PREPARE mystmt');
151 var_export($db->errorInfo(), true));
183 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
[all …]
H A Dlast_insert_id.phpt13 $db = MySQLPDOTest::factory();
15 print_r($db->query("CREATE TABLE test_last_insert_id (id INT AUTO_INCREMENT PRIMARY KEY, num INT)")…
17 print_r($db->query("INSERT INTO test_last_insert_id (id, num) VALUES (23, 42)"));
19 print_r($db->query("INSERT INTO test_last_insert_id (num) VALUES (451)"));
21 print_r($db->lastInsertId());
26 $db = MySQLPDOTest::factory();
27 $db->query('DROP TABLE IF EXISTS test_last_insert_id');
H A Dpdo_mysql_attr_driver_name.phpt13 $db = MySQLPDOTest::factory();
15 assert(('' == $db->errorCode()) || ('00000' == $db->errorCode()));
17 $name = $db->getAttribute(PDO::ATTR_DRIVER_NAME);
20 if (false !== $db->setAttribute(PDO::ATTR_DRIVER_NAME, 'mydriver'))
23 $new_name = $db->getAttribute(PDO::ATTR_DRIVER_NAME);
H A Dpdo_mysql_prepare_emulated_placeholder_everywhere.phpt14 $db = MySQLPDOTest::factory();
18 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
19 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
23 …$db->exec("INSERT INTO test_prepare_emulated_placeholder_everywhere(id, label) VALUES (1, 'row1')"…
27 … $stmt = $db->prepare('SELECT ? FROM test_prepare_emulated_placeholder_everywhere WHERE ? > ?');
38 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
39 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
42 … $stmt = $db->prepare('SELECT ? FROM test_prepare_emulated_placeholder_everywhere WHERE ? > ?');
52 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
60 $db = MySQLPDOTest::factory();
[all …]
H A Dpecl_bug_5802.phpt13 $db = MySQLPDOTest::factory();
15 $db->exec('create table test_pcl_bug_5802 ( bar char(3) NULL )');
16 $stmt = $db->prepare('insert into test_pcl_bug_5802 (bar) values(:bar)') or var_dump($db->errorInfo…
30 $stmt = $db->prepare('select * from test_pcl_bug_5802') or var_dump($db->errorInfo());
40 $db = MySQLPDOTest::factory();
41 $db->exec('DROP TABLE IF EXISTS test_pcl_bug_5802');
H A Dpdo_mysql_prepare_native_column.phpt13 $db = MySQLPDOTest::factory();
16 MySQLPDOTest::createTestTable($table, $db);
18 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
19 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
22 $stmt = $db->prepare("SELECT :param FROM {$table} ORDER BY id ASC LIMIT 1");
26 $db->prepare("SELECT :placeholder FROM {$table} WHERE :placeholder > :placeholder");
36 $db = MySQLPDOTest::factory();
37 $db->exec('DROP TABLE IF EXISTS pdo_mysql_prepare_native_column');
/php-src/ext/pdo_sqlite/tests/subclasses/
H A Dpdo_sqlite_createcollation.phpt9 $db = new Pdo\Sqlite('sqlite::memory:');
10 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
12 $db->query('CREATE TABLE test_pdo_sqlite_createcollation (id INT AUTO INCREMENT, name TEXT)');
14 $db->query('INSERT INTO test_pdo_sqlite_createcollation VALUES (NULL, "1"), (NULL, "2"), (NULL, "10…
16 $db->createCollation('MYCOLLATE', function($a, $b) { return strnatcmp($a, $b); });
18 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name COLLATE MYCOLL…
23 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name');
/php-src/ext/pdo/tests/
H A Dpdo_003.phpt16 $db = PDOTest::factory();
18 $db->exec('CREATE TABLE test003(id int NOT NULL PRIMARY KEY, val VARCHAR(10))');
19 $db->exec("INSERT INTO test003 VALUES(1, 'A')");
20 $db->exec("INSERT INTO test003 VALUES(2, 'B')");
21 $db->exec("INSERT INTO test003 VALUES(3, 'C')");
23 $stmt = $db->prepare('SELECT * from test003');
31 $db = PDOTest::factory();
32 PDOTest::dropTableIfExists($db, "test003");
H A Dpdo_004.phpt16 $db = PDOTest::factory();
18 $db->exec('CREATE TABLE test004(id int NOT NULL PRIMARY KEY, val VARCHAR(10))');
19 $db->exec("INSERT INTO test004 VALUES(1, 'A')");
20 $db->exec("INSERT INTO test004 VALUES(2, 'B')");
21 $db->exec("INSERT INTO test004 VALUES(3, 'C')");
23 $stmt = $db->prepare('SELECT * from test004');
31 $db = PDOTest::factory();
32 PDOTest::dropTableIfExists($db, "test004");
H A Dpdo_027.phpt16 $db = PDOTest::factory();
18 $db->exec('create table test027 (id int, name varchar(10))');
19 $db->exec("INSERT INTO test027 (id,name) VALUES(1,'test1')");
20 $db->exec("INSERT INTO test027 (id,name) VALUES(2,'test2')");
22 foreach ($db->query("SELECT * FROM test027", PDO::FETCH_LAZY) as $v) {
30 $db = PDOTest::factory();
31 PDOTest::dropTableIfExists($db, "test027");
/php-src/ext/pdo_sqlite/tests/
H A Dpdo_fetch_func_001.phpt8 $db = new PDO('sqlite::memory:');
9 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
14 $st = $db->query('SELECT * FROM test_fetch_func_001');
22 $st = $db->query('SELECT name FROM test_fetch_func_001');
26 $st = $db->query('SELECT * FROM test_fetch_func_001');
33 $st = $db->query('SELECT * FROM test_fetch_func_001');
40 $st = $db->query('SELECT * FROM test_fetch_func_001');
47 $st = $db->query('SELECT * FROM test_fetch_func_001');
66 public function __construct($db) {
84 new bar($db);
[all …]
H A Dgh13991.phpt6 <?php if (file_exists(getcwd() . '/13991db')) die('skip File "13991db" already exists.'); ?>
9 $dbfile = '13991db';
10 $db = new PDO('sqlite:' . $dbfile, null, null, [PDO::ATTR_PERSISTENT => true]);
15 @unlink(getcwd() . '/13991db');
/php-src/ext/pdo_firebird/tests/
H A Dpdofirebird_002.phpt15 $db = connectToDb();
16 if (!$db instanceof Pdo\Firebird) {
17 echo "Wrong class type. Should be Pdo\Firebird but is " . get_class($db) . "\n";
20 $db->query('CREATE TABLE pdofirebird_002 (idx INT NOT NULL PRIMARY KEY, name VARCHAR(20))');
22 $db->exec("INSERT INTO pdofirebird_002 VALUES(1, 'A')");
23 $db->exec("INSERT INTO pdofirebird_002 VALUES(2, 'B')");
24 $db->exec("INSERT INTO pdofirebird_002 VALUES(3, 'C')");
26 foreach ($db->query('SELECT name FROM pdofirebird_002') as $row) {

Completed in 31 milliseconds

12345678910>>...35