/php-src/ext/pdo/tests/ |
H A D | pecl_bug_5772.phpt | 16 $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 D | pecl_bug_5809.phpt | 16 $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 D | bug_36428.phpt | 18 $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 D | bug_39656.phpt | 17 $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 D | bug_42917.phpt | 16 $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 D | pdo_013.phpt | 16 $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 D | debug_emulated_prepares.phpt | 12 $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 D | bug_65946.phpt | 16 $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 D | sqlite3_defensive.phpt | 18 $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 D | sqlite3_01_open-mb.phpt | 8 $db_file = __DIR__ . DIRECTORY_SEPARATOR . '私はガラスを食べられます.db'; 9 $db = new SQLite3($db_file); 12 var_dump($db); 13 var_dump($db->close());
|
H A D | sqlite3_busyTimeout.phpt | 10 var_dump($db->busyTimeout(0)); 11 var_dump($db->busyTimeout(-1000)); 12 var_dump($db->busyTimeout(1000)); 13 $db->close();
|
/php-src/ext/pdo_dblib/tests/ |
H A D | bug_47588.phpt | 14 $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/pdo_odbc/tests/ |
H A D | pdoodbc_001.phpt | 15 $db = new Pdo\Odbc($config['ENV']['PDOTEST_DSN'], $config['ENV']['PDOTEST_USER'], $config['ENV']['P… 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 D | bug80783a.phpt | 18 $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_mysql/tests/ |
H A D | pdo_mysql_stmt_unbuffered_2050.phpt | 15 $db = MySQLPDOTest::factory(); 21 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 22 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 26 MySQLPDOTest::createTestTable($table, $db); 27 $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true); 28 $stmt = $db->query("SELECT id, label FROM {$table} WHERE id = 1"); 34 MySQLPDOTest::createTestTable($table, $db); 35 $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false); 109 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 117 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_stmt_closecursor_empty.phpt | 13 $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');
|
/php-src/ext/mysqli/tests/ |
H A D | mysqli_change_user_old.phpt | 16 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 18 $host, $user, $db, $port, $socket); 33 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { 35 $host, $user, $db, $port, $socket); 47 if (true !== ($tmp = mysqli_change_user($link, $user, $passwd, $db))) 57 if ($tmp['dbname'] != $db) 69 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { 71 $host, $user, $db, $port, $socket); 81 $host, $user, $db, $port, $socket); 85 (empty db = no db send with COM_CHANGE_USER) */ [all …]
|
/php-src/ext/pgsql/tests/ |
H A D | 16pg_result_status.phpt | 12 $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 D | 08escape.phpt | 46 $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 D | 21pg_get_notify.phpt | 13 $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/dba/ |
H A D | config.m4 | 480 db-5.3 481 db-5.1 482 db-5.0 483 db-4.8 484 db-4.7 485 db-4.6 486 db-4.5 492 db-4 494 db 539 [db-3.3 db-3.2 db-3.1 db-3.0 db-3 db3 db], [all …]
|
/php-src/ext/pdo_pgsql/tests/ |
H A D | bug70861.phpt | 15 $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');
|
/php-src/ext/pdo_sqlite/tests/ |
H A D | pdo_sqlite_parser.phpt | 8 $filename = __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_parser.db"; 11 $db = new PDO('sqlite:' . $filename, null, null, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]); 15 $db->exec("CREATE TABLE {$table} (`a``?` int NOT NULL)"); 16 $db->exec("INSERT INTO {$table} VALUES (1)"); 26 $stmt = $db->prepare($query); 41 $stmt = $db->prepare($query); 49 $filename = __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_parser.db";
|
H A D | gh9032.phpt | 9 $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 D | pdo_sqlite_createaggregate.phpt | 9 $db = new Pdo\Sqlite('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) {
|