Home
last modified time | relevance | path

Searched refs:db (Results 226 – 250 of 868) sorted by relevance

12345678910>>...35

/php-src/ext/pdo_sqlite/tests/subclasses/
H A Dpdo_sqlite_createafunction_trampoline.phpt8 $db = new Pdo\Sqlite('sqlite::memory:');
10 $db->query('CREATE TABLE test_pdo_sqlite_createaggregate_trampoline (a INTEGER, b INTEGER)');
12 $stmt = $db->query('INSERT INTO test_pdo_sqlite_createaggregate_trampoline VALUES (1, -1), (2, -2),…
21 var_dump($db->createFunction('strtoupper', [new TrampolineTest(), 'strtoupper']));
23 foreach ($db->query('SELECT strtoupper("test")') as $row) {
27 foreach ($db->query('SELECT strtoupper("test")') as $row) {
/php-src/ext/pdo_mysql/tests/
H A Dbug_45120.phpt13 $db = MySQLPDOTest::factory();
15 function bug_45120($db) {
16 $stmt = $db->prepare("SELECT 1 AS 'one'");
33 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
34 bug_45120($db);
37 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
38 bug_45120($db);
H A Dbug_33689.phpt13 $db = MySQLPDOTest::factory();
15 $db->exec('CREATE TABLE test_33689 (bar INT NOT NULL)');
16 $db->exec('INSERT INTO test_33689 VALUES(1)');
18 var_dump($db->query('SELECT * FROM test_33689'));
19 foreach ($db->query('SELECT * FROM test_33689') as $row) {
23 $stmt = $db->prepare('SELECT * FROM test_33689');
40 $db = MySQLPDOTest::factory();
41 $db->exec('DROP TABLE IF EXISTS test_33689');
H A Dbug78152.phpt13 $db = MySQLPDOTest::factory();
16 MySQLPDOTest::createTestTable($table, $db);
18 var_dump($db->exec("INSERT INTO {$table} (id, label) VALUES (41, 'x'); INSERT INTO {$table}_bad (id…
19 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
21 …var_dump($db->exec("INSERT INTO {$table} (id, label) VALUES (42, 'x'); INSERT INTO {$table}_bad (i…
29 $db = MySQLPDOTest::factory();
30 $db->exec('DROP TABLE IF EXISTS bug78152_pdo_mysql');
/php-src/ext/sqlite3/tests/
H A Dbug53463.phpt8 $db = new SQLite3(':memory:');
10 $db->exec('CREATE TABLE test (whatever INTEGER)');
11 $db->exec('INSERT INTO test (whatever) VALUES (1)');
13 $result = $db->query('SELECT * FROM test');
22 $db->close();
H A Dsqlite3_trampoline_create_aggregate.phpt30 var_dump($db->exec('CREATE TABLE test (a INTEGER, b INTEGER)'));
33 var_dump($db->exec("INSERT INTO test (a, b) VALUES (1, -1)"));
34 var_dump($db->exec("INSERT INTO test (a, b) VALUES (2, -2)"));
35 var_dump($db->exec("INSERT INTO test (a, b) VALUES (3, -3)"));
36 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)"));
37 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)"));
39 $db->createAggregate('S', $step, $finalize, 1);
41 print_r($db->querySingle("SELECT S(a), S(b) FROM test", true));
44 var_dump($db->close());
H A Dsqlite3_38_extended_error.phpt10 $db->query("CREATE TABLE dog ( id INTEGER PRIMARY KEY, name TEXT, annoying INTEGER )");
13 $result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
14 echo "First Error Code: " . $db->lastErrorCode() . PHP_EOL;
17 $result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
18 echo "Second Error Code: " . $db->lastErrorCode() . PHP_EOL;
19 echo "Second Extended Error Code: " . $db->lastExtendedErrorCode() . PHP_EOL;
22 var_dump($db->close());
H A Dsqlite3_18_changes.phpt12 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'"));
22 var_dump($db->changes());
25 var_dump($db->close());
H A Dsqlite3_36_create_collation.phpt10 $db->createCollation('NAT', 'strnatcmp');
12 $db->exec('CREATE TABLE t (s varchar(4))');
14 $stmt = $db->prepare('INSERT INTO t VALUES (?)');
20 $defaultSort = $db->query('SELECT s FROM t ORDER BY s'); //memcmp() sort
21 $naturalSort = $db->query('SELECT s FROM t ORDER BY s COLLATE NAT'); //strnatcmp() sort
33 $db->close();
/php-src/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_createfunction.phpt8 $db = new PDO('sqlite::memory:');
10 $db->query('CREATE TABLE test_pdo_sqlite_createfunction (id INT AUTO INCREMENT, name TEXT)');
12 $db->query('INSERT INTO test_pdo_sqlite_createfunction VALUES (NULL, "PHP"), (NULL, "PHP6")');
15 $db->sqliteCreateFunction('testing', function($v) { return strtolower($v); });
18 foreach ($db->query('SELECT testing(name) FROM test_pdo_sqlite_createfunction') as $row) {
H A Dpdo_sqlite_open_basedir.phpt11 $filename = 'pdo_sqlite_filename.db';
13 $db = new PDO('sqlite:' . $filename);
15 var_dump($db->exec('CREATE TABLE test_sqlite_open_basedir (id INT);'));
18 $filename = '..' . DIRECTORY_SEPARATOR . 'pdo_sqlite_filename.db';
26 'pdo_sqlite_filename.db',
27 '..' . DIRECTORY_SEPARATOR . 'pdo_sqlite_filename.db',
H A Dbug_42589.phpt8 $db = new PDO("sqlite::memory:");
9 $options = $db->query('PRAGMA compile_options')->fetchAll(PDO::FETCH_COLUMN);
15 $db = new PDO("sqlite::memory:");
17 $db->exec('CREATE TABLE test_42589 (field1 VARCHAR(10))');
18 $db->exec('INSERT INTO test_42589 VALUES("test")');
20 $result = $db->query('SELECT * FROM test_42589 t1 LEFT JOIN test_42589 t2 ON t1.field1 = t2.field1'…
/php-src/ext/pdo/tests/
H A Dpdo_030.phpt60 $db = PDOTest::factory('PDODatabase');
61 var_dump(get_class($db));
63 $db->exec('CREATE TABLE test030(id INT NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(16))');
65 $stmt = $db->prepare("INSERT INTO test030 VALUES(?, ?, ?)");
75 var_dump($db->getAttribute(PDO::ATTR_STATEMENT_CLASS));
76 $db->setAttribute(PDO::ATTR_STATEMENT_CLASS, array('PDOStatementx', array($db)));
77 var_dump($db->getAttribute(PDO::ATTR_STATEMENT_CLASS));
78 $stmt = $db->query('SELECT * FROM test030');
94 $db = PDOTest::factory();
95 PDOTest::dropTableIfExists($db, "test030");
H A Dbug_44173.phpt16 $db = PDOTest::factory();
18 $db->exec("CREATE TABLE test44173 (x int)");
19 $db->exec("INSERT INTO test44173 VALUES (1)");
24 $stmt = $db->query("SELECT * FROM test44173", PDO::FETCH_LAZY, 0, []);
33 $stmt = $db->query("SELECT * FROM test44173", 'abc');
40 $stmt = $db->query("SELECT * FROM test44173", PDO::FETCH_CLASS, 0, 0, 0);
49 $stmt = $db->query("SELECT * FROM test44173", PDO::FETCH_INTO);
58 $stmt = $db->query("SELECT * FROM test44173", PDO::FETCH_COLUMN);
67 $stmt = $db->query("SELECT * FROM test44173", PDO::FETCH_CLASS);
78 $db = PDOTest::factory();
[all …]
H A Dpdo_023.phpt62 $db = PDOTest::factory('PDODatabaseX');
63 $db->testMethod();
64 var_dump($db);
66 $db->query('CREATE TABLE test023(id INT NOT NULL PRIMARY KEY, val VARCHAR(10))');
67 $db->query("INSERT INTO test023 VALUES(0, 'A')");
68 $db->query("INSERT INTO test023 VALUES(1, 'B')");
71 $stmt = $db->query('SELECT val, id FROM test023');
76 $db = NULL;
83 $db = PDOTest::factory();
84 PDOTest::dropTableIfExists($db, "test023");
H A Dpdo_034.phpt16 $db = PDOTest::factory();
18 $db->exec("CREATE TABLE test034 (a varchar(100), b varchar(100), c varchar(100))");
21 $db->exec("INSERT INTO test034 (a,b,c) VALUES('test".$i."','".$i."','".$i."')");
24 var_dump($db->query("SELECT a,b FROM test034")->fetch(PDO::FETCH_KEY_PAIR));
25 var_dump($db->query("SELECT a,b FROM test034")->fetchAll(PDO::FETCH_KEY_PAIR));
26 var_dump($db->query("SELECT * FROM test034")->fetch(PDO::FETCH_KEY_PAIR));
27 var_dump($db->query("SELECT a,a FROM test034")->fetchAll(PDO::FETCH_KEY_PAIR));
33 $db = PDOTest::factory();
34 PDOTest::dropTableIfExists($db, "test034");
H A Dpdo_021.phpt16 $db = PDOTest::factory();
18 if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') {
19 $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
22 $db->exec('CREATE TABLE test021(id INT NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(16))');
24 $select = $db->prepare('SELECT COUNT(id) FROM test021');
37 $stmt = $db->prepare("INSERT INTO test021 VALUES(?, ?, ?)");
46 $stmt2 = $db->prepare("INSERT INTO test021 VALUES(:first, :second, :third)");
61 $db = PDOTest::factory();
62 PDOTest::dropTableIfExists($db, "test021");
H A Dpdo_012.phpt16 $db = PDOTest::factory();
18 $db->exec('CREATE TABLE test012(id int NOT NULL PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))');
19 $db->exec("INSERT INTO test012 VALUES(1, 'A', 'Group1')");
20 $db->exec("INSERT INTO test012 VALUES(2, 'B', 'Group2')");
24 $stmt = $db->query($SELECT, PDO::FETCH_NUM);
40 $stmt = $db->query($SELECT, PDO::FETCH_CLASS, TestClass::class);
45 $stmt = $db->query($SELECT, PDO::FETCH_NUM);
53 $db = PDOTest::factory();
54 PDOTest::dropTableIfExists($db, "test012");
H A Dbug_72368.phpt16 $db = PDOTest::factory();
17 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
22 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
24 $stmt = $db->prepare($sql);
31 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
33 $stmt = $db->prepare($sql);
H A Dpecl_bug_5217.phpt16 $db = PDOTest::factory();
18 $ser = serialize($db);
20 $db = unserialize($ser);
21 $db->exec('CREATE TABLE test5217 (id int NOT NULL PRIMARY KEY, val VARCHAR(10))');
31 $db = PDOTest::factory();
32 PDOTest::dropTableIfExists($db, "test5217");
/php-src/ext/pgsql/tests/
H A D27large_object_oid.phpt17 $db = pg_connect($conn_str);
20 pg_exec ($db, "BEGIN");
21 $oid = pg_lo_create ($db, 21000);
24 pg_lo_unlink ($db, $oid);
25 pg_exec ($db, "COMMIT");
28 pg_exec ($db, "BEGIN");
29 $oid = pg_lo_create ($db, "21001");
32 pg_lo_unlink ($db, $oid);
33 pg_exec ($db, "COMMIT");
H A D22pg_fetch_object.phpt20 $db = pg_connect($conn_str);
21 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
22 pg_query($db, "INSERT INTO {$table_name} VALUES(0, 'ABC', null)");
25 $result = pg_query($db, $sql) or die('Cannot query db');
43 $db = pg_connect($conn_str);
44 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
/php-src/ext/pdo_odbc/tests/
H A Dgh9372.phpt17 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
18 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
20 $db->exec("CREATE TABLE gh9372 (col VARCHAR(10))");
21 $db->exec("INSERT INTO gh9372 VALUES ('something')");
23 $stmt = $db->prepare("SELECT * FROM gh9372 WHERE col = ?");
33 $stmt = $db->prepare("SELECT * FROM gh9372 WHERE col = ?");
49 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
50 $db->exec("DROP TABLE gh9372");
/php-src/ext/pdo_pgsql/tests/
H A Dbug70313.phpt15 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
16 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
18 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
20 $stmt = $db->prepare(");");
27 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
29 $stmt = $db->prepare(");");
/php-src/ext/mysqli/tests/
H A Dbug77935.phpt14 $db = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
15 $db->query('DROP PROCEDURE IF EXISTS testSp');
16 $db->query(<<<'SQL'
27 $stmt = $db->prepare("CALL testSp()");
38 $link = new mysqli($host, $user, $passwd, $db, $port, $socket);

Completed in 29 milliseconds

12345678910>>...35