/php-src/ext/pgsql/tests/ |
H A D | bug64609.phpt | 18 $db = pg_connect($conn_str); 19 pg_query($db, "BEGIN"); 20 pg_query($db, "CREATE TYPE {$type_name} AS ENUM ('ok', 'ko')"); 21 pg_query($db, "CREATE TABLE {$table_name} (a {$type_name})"); 24 $converted = pg_convert($db, $table_name, $fields); 26 pg_query($db, "ROLLBACK");
|
H A D | gh10672.phpt | 16 $db = pg_connect($conn_str); 17 pg_query($db, "CREATE TABLE {$table_name} (bar text);"); 20 pg_query($db, 'BEGIN'); 23 $oid = pg_lo_create($db); 26 die(pg_last_error($db)); 30 $lob = pg_lo_open($db, $oid, 'w'); 33 die(pg_last_error($db));
|
H A D | gh8253.phpt | 18 $db = pg_connect($conn_str); 19 pg_query($db, "CREATE TABLE {$table_name} (bar text);"); 20 pg_insert($db, $table_name, $a); 21 $res = pg_query($db, "SELECT * FROM {$table_name}"); 29 $db = pg_connect($conn_str); 30 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
|
/php-src/ext/sqlite3/tests/ |
H A D | bug73068.phpt | 13 $db = new \SQLite3(':memory:') ; 15 $db->exec("CREATE TABLE IF NOT EXISTS t1(a INT UNIQUE, b INT)"); 16 $db->exec("INSERT OR REPLACE INTO t1(a,b) VALUES('1','2')"); 18 $r = $db->query("SELECT * FROM t1 WHERE a='1' AND b='2'"); 21 $db->exec("DELETE FROM t1 WHERE a='1' AND b='2'"); 23 $r = $db->query("SELECT * FROM t1;"); 26 $db->close();
|
H A D | sqlite3_25_create_aggregate.phpt | 25 var_dump($db->exec('CREATE TABLE test (a INTEGER, b INTEGER)')); 28 var_dump($db->exec("INSERT INTO test (a, b) VALUES (1, -1)")); 29 var_dump($db->exec("INSERT INTO test (a, b) VALUES (2, -2)")); 30 var_dump($db->exec("INSERT INTO test (a, b) VALUES (3, -3)")); 31 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)")); 32 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)")); 34 $db->createAggregate('S', 'sum_list_step', 'sum_list_finalize', 1); 36 print_r($db->querySingle("SELECT S(a), S(b) FROM test", true)); 39 var_dump($db->close());
|
H A D | sqlite3_31_open.phpt | 12 $db = new SQLite3(__DIR__ . '/db1.db'); 13 $db->open(__DIR__ . '/db1.db'); 20 <?php @unlink(__DIR__ . '/db1.db'); ?>
|
H A D | sqlite3_37_createfunction_flags.phpt | 15 var_dump($db->createfunction($func, $func, 1, SQLITE3_DETERMINISTIC)); 16 var_dump($db->querySingle('SELECT strtoupper("test")')); 19 var_dump($db->createfunction($func2, $func2, 1, SQLITE3_DETERMINISTIC)); 20 var_dump($db->querySingle('SELECT strtolower("TEST")')); 22 var_dump($db->createfunction($func, $func2, 1, SQLITE3_DETERMINISTIC)); 23 var_dump($db->querySingle('SELECT strtoupper("tEst")'));
|
H A D | gh9032.phpt | 9 $db = new SQLite3(":memory:"); 10 $db->enableExceptions(true); 12 $db->exec('attach database \':memory:\' AS "db1"'); 13 var_dump($db->exec('create table db1.r (id int)')); 16 $st = $db->prepare('attach database :a AS "db2"'); 19 var_dump($db->exec('create table db2.r (id int)'));
|
/php-src/ext/pdo_mysql/tests/ |
H A D | bug_41698.phpt | 13 $db = MySQLPDOTest::factory(); 17 $db->exec('CREATE TABLE test_41698(floatval DECIMAL(8,6))'); 18 $db->exec('INSERT INTO test_41698 VALUES(2.34)'); 20 $stmt = $db->prepare('INSERT INTO test_41698 VALUES(?)'); 22 var_dump($db->query('SELECT * FROM test_41698')->fetchAll(PDO::FETCH_ASSOC)); 27 $db = MySQLPDOTest::factory(); 28 $db->exec("DROP TABLE IF EXISTS test_41698");
|
H A D | pdomysql_001.phpt | 15 $db = MySQLPDOTest::factory(Pdo\Mysql::class); 17 $db->query('CREATE TABLE pdomysql_001 (id INT, name TEXT)'); 19 $db->query('INSERT INTO pdomysql_001 VALUES (NULL, "PHP")'); 20 $db->query('INSERT INTO pdomysql_001 VALUES (NULL, "PHP6")'); 22 foreach ($db->query('SELECT name FROM pdomysql_001') as $row) { 31 $db = MySQLPDOTest::factory(); 32 $db->exec('DROP TABLE IF EXISTS pdomysql_001');
|
H A D | bug44327.phpt | 13 $db = MySQLPDOTest::factory(); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 16 $stmt = $db->prepare("SELECT 1 AS \"one\""); 26 $db->exec("CREATE TABLE test_44327 (id INT)"); 27 $db->exec("INSERT INTO test_44327(id) VALUES (1)"); 28 $stmt = $db->prepare("SELECT id FROM test_44327"); 36 $stmt = $db->prepare('foo'); 44 $db = MySQLPDOTest::factory(); 45 $db->exec("DROP TABLE test_44327");
|
H A D | pdo_mysql_stmt_closecursor.phpt | 14 $db = MySQLPDOTest::factory(); 18 function pdo_mysql_stmt_closecursor($db) { 119 MySQLPDOTest::createTestTable($table, $db); 120 pdo_mysql_stmt_closecursor($db); 124 MySQLPDOTest::createTestTable($table, $db); 125 pdo_mysql_stmt_closecursor($db); 133 MySQLPDOTest::createTestTable($table, $db); 135 pdo_mysql_stmt_closecursor($db); 140 pdo_mysql_stmt_closecursor($db); 144 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | pdo_mysql_stmt_fetch_non_select.phpt | 13 $db = MySQLPDOTest::factory(); 16 MySQLPDOTest::createTestTable($table, $db); 21 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 78 $db->exec('DEALLOCATE PREPARE mystmt'); 84 var_export($db->errorInfo(), true)); 112 $db->exec('DEALLOCATE PREPARE mystmt'); 118 var_export($db->errorInfo(), true)); 145 $db->exec('DEALLOCATE PREPARE mystmt'); 151 var_export($db->errorInfo(), true)); 183 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | last_insert_id.phpt | 13 $db = MySQLPDOTest::factory(); 15 print_r($db->query("CREATE TABLE test_last_insert_id (id INT AUTO_INCREMENT PRIMARY KEY, num INT)")… 17 print_r($db->query("INSERT INTO test_last_insert_id (id, num) VALUES (23, 42)")); 19 print_r($db->query("INSERT INTO test_last_insert_id (num) VALUES (451)")); 21 print_r($db->lastInsertId()); 26 $db = MySQLPDOTest::factory(); 27 $db->query('DROP TABLE IF EXISTS test_last_insert_id');
|
H A D | pdo_mysql_attr_driver_name.phpt | 13 $db = MySQLPDOTest::factory(); 15 assert(('' == $db->errorCode()) || ('00000' == $db->errorCode())); 17 $name = $db->getAttribute(PDO::ATTR_DRIVER_NAME); 20 if (false !== $db->setAttribute(PDO::ATTR_DRIVER_NAME, 'mydriver')) 23 $new_name = $db->getAttribute(PDO::ATTR_DRIVER_NAME);
|
H A D | pdo_mysql_prepare_emulated_placeholder_everywhere.phpt | 14 $db = MySQLPDOTest::factory(); 18 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 19 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 23 …$db->exec("INSERT INTO test_prepare_emulated_placeholder_everywhere(id, label) VALUES (1, 'row1')"… 27 … $stmt = $db->prepare('SELECT ? FROM test_prepare_emulated_placeholder_everywhere WHERE ? > ?'); 38 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 39 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 42 … $stmt = $db->prepare('SELECT ? FROM test_prepare_emulated_placeholder_everywhere WHERE ? > ?'); 52 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 60 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pecl_bug_5802.phpt | 13 $db = MySQLPDOTest::factory(); 15 $db->exec('create table test_pcl_bug_5802 ( bar char(3) NULL )'); 16 $stmt = $db->prepare('insert into test_pcl_bug_5802 (bar) values(:bar)') or var_dump($db->errorInfo… 30 $stmt = $db->prepare('select * from test_pcl_bug_5802') or var_dump($db->errorInfo()); 40 $db = MySQLPDOTest::factory(); 41 $db->exec('DROP TABLE IF EXISTS test_pcl_bug_5802');
|
H A D | pdo_mysql_prepare_native_column.phpt | 13 $db = MySQLPDOTest::factory(); 16 MySQLPDOTest::createTestTable($table, $db); 18 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 19 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 22 $stmt = $db->prepare("SELECT :param FROM {$table} ORDER BY id ASC LIMIT 1"); 26 $db->prepare("SELECT :placeholder FROM {$table} WHERE :placeholder > :placeholder"); 36 $db = MySQLPDOTest::factory(); 37 $db->exec('DROP TABLE IF EXISTS pdo_mysql_prepare_native_column');
|
/php-src/ext/pdo_sqlite/tests/subclasses/ |
H A D | pdo_sqlite_createcollation.phpt | 9 $db = new Pdo\Sqlite('sqlite::memory:'); 10 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 12 $db->query('CREATE TABLE test_pdo_sqlite_createcollation (id INT AUTO INCREMENT, name TEXT)'); 14 $db->query('INSERT INTO test_pdo_sqlite_createcollation VALUES (NULL, "1"), (NULL, "2"), (NULL, "10… 16 $db->createCollation('MYCOLLATE', function($a, $b) { return strnatcmp($a, $b); }); 18 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name COLLATE MYCOLL… 23 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name');
|
/php-src/ext/pdo/tests/ |
H A D | pdo_003.phpt | 16 $db = PDOTest::factory(); 18 $db->exec('CREATE TABLE test003(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); 19 $db->exec("INSERT INTO test003 VALUES(1, 'A')"); 20 $db->exec("INSERT INTO test003 VALUES(2, 'B')"); 21 $db->exec("INSERT INTO test003 VALUES(3, 'C')"); 23 $stmt = $db->prepare('SELECT * from test003'); 31 $db = PDOTest::factory(); 32 PDOTest::dropTableIfExists($db, "test003");
|
H A D | pdo_004.phpt | 16 $db = PDOTest::factory(); 18 $db->exec('CREATE TABLE test004(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); 19 $db->exec("INSERT INTO test004 VALUES(1, 'A')"); 20 $db->exec("INSERT INTO test004 VALUES(2, 'B')"); 21 $db->exec("INSERT INTO test004 VALUES(3, 'C')"); 23 $stmt = $db->prepare('SELECT * from test004'); 31 $db = PDOTest::factory(); 32 PDOTest::dropTableIfExists($db, "test004");
|
H A D | pdo_027.phpt | 16 $db = PDOTest::factory(); 18 $db->exec('create table test027 (id int, name varchar(10))'); 19 $db->exec("INSERT INTO test027 (id,name) VALUES(1,'test1')"); 20 $db->exec("INSERT INTO test027 (id,name) VALUES(2,'test2')"); 22 foreach ($db->query("SELECT * FROM test027", PDO::FETCH_LAZY) as $v) { 30 $db = PDOTest::factory(); 31 PDOTest::dropTableIfExists($db, "test027");
|
/php-src/ext/pdo_sqlite/tests/ |
H A D | pdo_fetch_func_001.phpt | 8 $db = new PDO('sqlite::memory:'); 9 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); 14 $st = $db->query('SELECT * FROM test_fetch_func_001'); 22 $st = $db->query('SELECT name FROM test_fetch_func_001'); 26 $st = $db->query('SELECT * FROM test_fetch_func_001'); 33 $st = $db->query('SELECT * FROM test_fetch_func_001'); 40 $st = $db->query('SELECT * FROM test_fetch_func_001'); 47 $st = $db->query('SELECT * FROM test_fetch_func_001'); 66 public function __construct($db) { 84 new bar($db); [all …]
|
H A D | gh13991.phpt | 6 <?php if (file_exists(getcwd() . '/13991db')) die('skip File "13991db" already exists.'); ?> 9 $dbfile = '13991db'; 10 $db = new PDO('sqlite:' . $dbfile, null, null, [PDO::ATTR_PERSISTENT => true]); 15 @unlink(getcwd() . '/13991db');
|
/php-src/ext/pdo_firebird/tests/ |
H A D | pdofirebird_002.phpt | 15 $db = connectToDb(); 16 if (!$db instanceof Pdo\Firebird) { 17 echo "Wrong class type. Should be Pdo\Firebird but is " . get_class($db) . "\n"; 20 $db->query('CREATE TABLE pdofirebird_002 (idx INT NOT NULL PRIMARY KEY, name VARCHAR(20))'); 22 $db->exec("INSERT INTO pdofirebird_002 VALUES(1, 'A')"); 23 $db->exec("INSERT INTO pdofirebird_002 VALUES(2, 'B')"); 24 $db->exec("INSERT INTO pdofirebird_002 VALUES(3, 'C')"); 26 foreach ($db->query('SELECT name FROM pdofirebird_002') as $row) {
|