Home
last modified time | relevance | path

Searched refs:db (Results 251 – 275 of 855) sorted by relevance

1...<<11121314151617181920>>...35

/php-src/ext/pdo/tests/
H A Dpecl_bug_5772.phpt16 $db = PDOTest::factory();
18 $db->exec("CREATE TABLE test5772 (id int NOT NULL, PRIMARY KEY (id))");
19 $db->exec("INSERT INTO test5772 (id) VALUES (1)");
25 foreach ($db->query("SELECT * FROM test5772")->fetchAll(PDO::FETCH_FUNC, 'heLLO') as $row) {
32 $db = PDOTest::factory();
33 PDOTest::dropTableIfExists($db, "test5772");
H A Dpecl_bug_5809.phpt16 $db = PDOTest::factory();
18 $db->exec("CREATE TABLE test5809 (id int NOT NULL, PRIMARY KEY (id))");
19 $db->exec("INSERT INTO test5809 (id) VALUES (1)");
23 $stmt = $db->prepare('SELECT * FROM test5809 WHERE id = ?');
30 $db = PDOTest::factory();
31 PDOTest::dropTableIfExists($db, "test5809");
H A Dbug_36428.phpt18 $db = PDOTest::factory();
19 $db->exec("CREATE TABLE test36428 (a VARCHAR(10))");
20 $db->exec("INSERT INTO test36428 (a) VALUES ('xyz')");
21 $res = $db->query("SELECT a FROM test36428");
28 $db = PDOTest::factory();
29 PDOTest::dropTableIfExists($db, "test36428");
H A Dbug_39656.phpt17 $db = PDOTest::factory();
19 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
21 $db->exec("CREATE TABLE test39656 (id INTEGER NOT NULL PRIMARY KEY, usr VARCHAR( 256 ) NOT NULL)");
22 $db->exec("INSERT INTO test39656 (id, usr) VALUES (1, 'user')");
24 $stmt = $db->prepare("SELECT * FROM test39656 WHERE id = ?");
40 $db = PDOTest::factory();
41 PDOTest::dropTableIfExists($db, "test39656");
H A Dpdo_013.phpt16 $db = PDOTest::factory();
18 $db->exec('CREATE TABLE test013(id int NOT NULL PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))');
19 $db->exec("INSERT INTO test013 VALUES(1, 'A', 'Group1')");
20 $db->exec("INSERT INTO test013 VALUES(2, 'B', 'Group2')");
24 $stmt = $db->prepare($SELECT);
46 foreach ($db->query($SELECT, PDO::FETCH_CLASS, TestClass::class) as $data)
53 $stmt = $db->query($SELECT, PDO::FETCH_CLASS, TestClass::class, array('WOW'));
63 $db = PDOTest::factory();
64 PDOTest::dropTableIfExists($db, "test013");
H A Dbug_42917.phpt16 $db = PDOTest::factory();
18 $db->exec("CREATE TABLE test42917 (a varchar(100), b varchar(100), c varchar(100))");
21 $db->exec("INSERT INTO test42917 (a,b,c) VALUES('test".$i."','".$i."','".$i."')");
24 $res = $db->query("SELECT a,b FROM test42917");
32 $db = PDOTest::factory();
33 PDOTest::dropTableIfExists($db, "test42917");
H A Ddebug_emulated_prepares.phpt12 $db = PDOTest::factory();
13 if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'pgsql') die('skip pgsql has its own test for this …
14 if (!@$db->getAttribute(PDO::ATTR_EMULATE_PREPARES) && !@$db->setAttribute(PDO::ATTR_EMULATE_PREPAR…
21 $db = PDOTest::factory();
22 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
24 $stmt = $db->query('SELECT 1');
29 $stmt = $db->prepare('SELECT :bool, :int, :string, :null');
H A Dbug_65946.phpt16 $db = PDOTest::factory();
17 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
18 $db->exec('CREATE TABLE test65946(id int)');
19 $db->exec('INSERT INTO test65946 VALUES(1)');
20 switch ($db->getAttribute(PDO::ATTR_DRIVER_NAME)) {
38 $stmt = $db->prepare($sql);
47 $db = PDOTest::factory();
48 PDOTest::dropTableIfExists($db, "test65946");
/php-src/ext/sqlite3/tests/
H A Dsqlite3_defensive.phpt18 $db = new SQLite3(':memory:');
19 var_dump($db->exec('CREATE TABLE test (a, b);'));
22 var_dump($db->exec('PRAGMA writable_schema = ON;'));
25 var_dump($db->querySingle('SELECT COUNT(*) FROM sqlite_master;'));
28 var_dump($db->querySingle('DELETE FROM sqlite_master;'));
31 var_dump($db->querySingle('SELECT COUNT(*) FROM sqlite_master;'));
H A Dsqlite3_01_open-mb.phpt8 $db_file = __DIR__ . DIRECTORY_SEPARATOR . '私はガラスを食べられます.db';
9 $db = new SQLite3($db_file);
12 var_dump($db);
13 var_dump($db->close());
H A Dsqlite3_busyTimeout.phpt10 var_dump($db->busyTimeout(0));
11 var_dump($db->busyTimeout(-1000));
12 var_dump($db->busyTimeout(1000));
13 $db->close();
H A Dbug45798.phpt10 $db->exec('CREATE TABLE test (time INTEGER, id STRING)');
12 $db->exec("INSERT INTO test (time, id) VALUES (" . time() . ", 'a')");
13 $db->exec("INSERT INTO test (time, id) VALUES (" . time() . ", 'b')");
15 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
26 $db->close();
/php-src/ext/pdo_odbc/tests/
H A Dpdoodbc_001.phpt15 $db = new PdoOdbc($config['ENV']['PDOTEST_DSN'], $config['ENV']['PDOTEST_USER'], $config['ENV']['PD…
17 $db->query("CREATE TABLE pdoodbc_001 (id INT, name TEXT)");
18 $db->query("INSERT INTO pdoodbc_001 VALUES (NULL, 'PHP'), (NULL, 'PHP6')");
20 foreach ($db->query('SELECT name FROM pdoodbc_001') as $row) {
29 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
30 $db->exec("DROP TABLE IF EXISTS pdoodbc_001");
H A Dbug80783a.phpt18 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
19 $db->exec("CREATE TABLE bug80783a (name NVARCHAR(MAX))");
22 $db->exec("INSERT INTO bug80783a VALUES('$string')");
24 $stmt = $db->prepare("SELECT name FROM bug80783a");
35 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
36 $db->exec("DROP TABLE IF EXISTS bug80783a");
/php-src/ext/pdo_dblib/tests/
H A Dbug_47588.phpt14 $db = getDbConnection();
15 $db->query('CREATE TABLE "Test Table47588" ("My Field" int, "Another Field" varchar(32) not null de…
16 $db->query('INSERT INTO "Test Table47588" ("My Field") values(1), (2), (3)');
17 $rs = $db->query('SELECT * FROM "Test Table47588"');
24 $db = getDbConnection();
25 $db->exec('DROP TABLE IF EXISTS "Test Table47588"');
/php-src/ext/pgsql/tests/
H A D16pg_result_status.phpt12 $db = pg_connect($conn_str);
13 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
16 $result = pg_query($db, "BEGIN;END");
26 $db = pg_connect($conn_str);
27 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
H A D08escape.phpt46 $db = pg_connect($conn_str);
50 $escaped_data = pg_escape_bytea($db, $data);
51 pg_query($db, "DELETE FROM ".$table_name." WHERE num = 10000;");
53 pg_query($db, $sql);
58 $result = pg_query($db, $sql);
67 @pg_query($db, "SET bytea_output = 'escape'");
70 $result = pg_query($db, $sql);
79 $after = pg_escape_literal($db, $before);
92 $after = pg_escape_identifier($db, $before);
109 $db = pg_connect($conn_str);
[all …]
H A D21pg_get_notify.phpt13 $db = pg_connect($conn_str);
14 pg_query($db, 'LISTEN test_msg');
15 pg_query($db, 'NOTIFY test_msg');
17 $msg = pg_get_notify($db);
/php-src/ext/pdo_pgsql/tests/
H A Dbug70861.phpt15 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
17 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
20 @$db->query("SET bytea_output = 'escape'");
24 $db->query('CREATE TABLE test70861 (id SERIAL NOT NULL, blob1 BYTEA)');
36 $stmt = $db->prepare("INSERT INTO test70861 (blob1) VALUES (:foo)", array(PDO::ATTR_CURSOR => PDO::…
48 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
49 $db->query('DROP TABLE IF EXISTS test70861 CASCADE');
H A Dbug73959.phpt16 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
17 $db->setAttribute(PDO::ATTR_PERSISTENT, false);
18 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
19 $db->setAttribute(PDO::PGSQL_ATTR_DISABLE_PREPARES, true);
22 $db->lastInsertId('nonexistent_seq');
/php-src/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_closecursor_empty.phpt13 $db = MySQLPDOTest::factory();
19 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
20 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
23 $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
24 MySQLPDOTest::createTestTable($table, $db);
26 $stmt = $db->prepare("SELECT id, label FROM {$table} WHERE id > ? ORDER BY id ASC LIMIT 2");
59 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
67 $db = MySQLPDOTest::factory();
68 $db->exec('DROP TABLE IF EXISTS pdo_mysql_stmt_closecursor_empty');
H A Dbug_38546.phpt13 $db = MySQLPDOTest::factory();
15 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
18 $db->exec("SET sql_mode='STRICT_TRANS_TABLES'");
26 $db->exec($query);
49 foreach ($db->query('SELECT * FROM test_38546') as $row) {
75 foreach ($db->query('SELECT * FROM test_38546') as $row) {
101 foreach ($db->query('SELECT * FROM test_38546') as $row) {
128 foreach ($db->query('SELECT * FROM test_38546') as $row) {
155 foreach ($db->query('SELECT * FROM test_38546') as $row) {
189 $db = MySQLPDOTest::factory();
[all …]
/php-src/ext/pdo_sqlite/tests/
H A Dgh9032.phpt9 $db = new PDO("sqlite::memory:", null, null, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
11 $db->exec('attach database \':memory:\' AS "db1"');
12 var_dump($db->exec('create table db1.r (id int)'));
15 $st = $db->prepare('attach database :a AS "db2"');
17 var_dump($db->exec('create table db2.r (id int)'));
/php-src/ext/pdo_sqlite/tests/subclasses/
H A Dpdo_sqlite_createaggregate.phpt9 $db = new PdoSqlite('sqlite::memory:');
11 $db->query('CREATE TABLE test_pdo_sqlite_createaggregate (id INT AUTO INCREMENT, name TEXT)');
13 $db->query('INSERT INTO test_pdo_sqlite_createaggregate VALUES (NULL, "PHP"), (NULL, "PHP6")');
15 $db->createAggregate('testing', function(&$a, $b) { $a .= $b; return $a; }, function(&$v) { return …
17 foreach ($db->query('SELECT testing(name) FROM test_pdo_sqlite_createaggregate') as $row) {
/php-src/ext/dba/tests/
H A Dbug65708.phpt13 $name = 'bug65708.db';
15 $db = get_any_db($name);
23 dba_exists($key, $db);
28 dba_close($db);
34 $db_name = 'bug65708.db';

Completed in 47 milliseconds

1...<<11121314151617181920>>...35