/php-src/ext/pdo_sqlite/tests/subclasses/ |
H A D | pdo_sqlite_createafunction_trampoline.phpt | 8 $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 D | bug_45120.phpt | 13 $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 D | bug_33689.phpt | 13 $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 D | bug78152.phpt | 13 $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 D | bug53463.phpt | 8 $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 D | sqlite3_trampoline_create_aggregate.phpt | 30 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 D | sqlite3_38_extended_error.phpt | 10 $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 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'")); 22 var_dump($db->changes()); 25 var_dump($db->close());
|
H A D | sqlite3_36_create_collation.phpt | 10 $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 D | pdo_sqlite_createfunction.phpt | 8 $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 D | pdo_sqlite_open_basedir.phpt | 11 $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 D | bug_42589.phpt | 8 $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 D | pdo_030.phpt | 60 $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 D | bug_44173.phpt | 16 $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 D | pdo_023.phpt | 62 $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 D | pdo_034.phpt | 16 $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 D | pdo_021.phpt | 16 $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 D | pdo_012.phpt | 16 $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 D | bug_72368.phpt | 16 $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 D | pecl_bug_5217.phpt | 16 $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 D | 27large_object_oid.phpt | 17 $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 D | 22pg_fetch_object.phpt | 20 $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 D | gh9372.phpt | 17 $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 D | bug70313.phpt | 15 $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 D | bug77935.phpt | 14 $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);
|