/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 | 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 | 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 | 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();
|
H A D | bug45798.phpt | 10 $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 D | pdoodbc_001.phpt | 15 $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 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_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/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/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');
|
H A D | bug73959.phpt | 16 $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 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');
|
H A D | bug_38546.phpt | 13 $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 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 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 D | bug65708.phpt | 13 $name = 'bug65708.db'; 15 $db = get_any_db($name); 23 dba_exists($key, $db); 28 dba_close($db); 34 $db_name = 'bug65708.db';
|