/php-src/ext/pdo_odbc/tests/ |
H A D | pdoodbc_002.phpt | 15 $db = Pdo\Odbc::connect($config['ENV']['PDOTEST_DSN'], $config['ENV']['PDOTEST_USER'], $config['ENV… 16 if (!$db instanceof Pdo\Odbc) { 17 echo "Wrong class type. Should be Pdo\Odbc but is " . get_class($db) . "\n"; 20 $db->exec('CREATE TABLE pdoodbc_002(id INT NOT NULL PRIMARY KEY, name VARCHAR(10))'); 21 $db->exec("INSERT INTO pdoodbc_002 VALUES(1, 'A'), (2, 'B'), (3, 'C')"); 23 foreach ($db->query('SELECT name FROM pdoodbc_002') as $row) { 32 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 33 $db->exec("DROP TABLE IF EXISTS pdoodbc_002");
|
/php-src/ext/sqlite3/tests/ |
H A D | sqlite3_trampoline_setauthorizer_null.phpt | 8 $db = new SQLite3(':memory:'); 9 $db->enableExceptions(true); 11 $db->setAuthorizer(null); 14 var_dump($db->querySingle('SELECT 1;')); 18 var_dump($db->querySingle('CREATE TABLE test (a, b);'));
|
H A D | sqlite3_24_last_insert_rowid.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->lastInsertRowID()); 17 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')")); 18 var_dump($db->lastInsertRowID()); 21 var_dump($db->close());
|
H A D | sqlite3_enable_exceptions.phpt | 11 $db = new SQLite3(':memory:'); 12 var_dump($db->enableExceptions(true)); 14 $db->query("SELECT * FROM non_existent_table"); 18 var_dump($db->enableExceptions(false)); 19 $db->query("SELECT * FROM non_existent_table"); 21 var_dump($db->close());
|
/php-src/ext/dba/tests/ |
H A D | dba_array_keys_var_non_string.phpt | 13 $name = 'array_keys_non_string.db'; 15 $db = get_any_db($name); 20 var_dump(dba_insert($key, 'Test', $db)); 22 var_dump(dba_fetch($key, $db)); 25 dba_close($db); 31 $db_name = 'array_keys_non_string.db';
|
/php-src/ext/pdo_sqlite/tests/subclasses/ |
H A D | pdosqlite_001.phpt | 8 $db = new Pdo\Sqlite('sqlite::memory:'); 10 $db->query('CREATE TABLE pdosqlite_001 (id INT AUTO INCREMENT, name TEXT)'); 12 $db->query('INSERT INTO pdosqlite_001 VALUES (NULL, "PHP")'); 13 $db->query('INSERT INTO pdosqlite_001 VALUES (NULL, "PHP6")'); 15 $db->createFunction('testing', function($v) { return strtolower($v); }, 1, Pdo\Sqlite::DETERMINISTI… 17 foreach ($db->query('SELECT testing(name) FROM pdosqlite_001') as $row) {
|
/php-src/ext/pdo_dblib/tests/ |
H A D | pdodblib_001.phpt | 14 $db = getDbConnection(Pdo\Dblib::class); 16 $db->query("CREATE TABLE #pdo_dblib_001(name VARCHAR(32)); "); 17 $db->query("INSERT INTO #pdo_dblib_001 VALUES('PHP'), ('PHP6');"); 19 foreach ($db->query('SELECT name FROM #pdo_dblib_001') as $row) { 28 $db = getDbConnection(); 29 $db->query('DROP TABLE IF EXISTS #pdo_dblib_001');
|
H A D | bug_69592.phpt | 14 $db = getDbConnection(); 21 var_dump($db->getAttribute(PDO::DBLIB_ATTR_SKIP_EMPTY_ROWSETS)); 23 $stmt = $db->query($sql); 30 $db->setAttribute(PDO::DBLIB_ATTR_SKIP_EMPTY_ROWSETS, true); 31 var_dump($db->getAttribute(PDO::DBLIB_ATTR_SKIP_EMPTY_ROWSETS)); 33 $stmt = $db->query($sql); 38 var_dump($db->getAttribute(PDO::DBLIB_ATTR_SKIP_EMPTY_ROWSETS));
|
H A D | datetime_convert.phpt | 14 $db = getDbConnection(); 18 var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT)); 20 $stmt = $db->query($sql); 24 $db->setAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT, 1); 25 var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT)); 26 $stmt = $db->query($sql);
|
/php-src/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_native_mixed_style.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->query("DELETE FROM {$table}"); 23 $stmt = $db->prepare("INSERT INTO {$table}(id, label) VALUES (1, ?), (2, ?)"); 25 …$stmt = $db->prepare("SELECT id, label FROM {$table} WHERE id = :placeholder AND label = (SELECT l… 34 $db = MySQLPDOTest::factory(); 35 $db->exec('DROP TABLE IF EXISTS pdo_mysql_prepare_native_mixed_style');
|
H A D | pdo_mysql_prepare_native_clear_error.phpt | 13 $db = MySQLPDOTest::factory(); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 20 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 21 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 25 $db->exec("INSERT INTO test_prepare_native_clear_error(id, label) VALUES (1, 'row1')"); 34 …$stmt = $db->prepare('SELECT id, label FROM test_prepare_native_clear_error WHERE id > :placeholde… 43 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 44 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 63 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 71 $db = MySQLPDOTest::factory(); [all …]
|
H A D | bug63176.phpt | 2 Bug #63176 (Segmentation fault when instantiate 2 persistent PDO to the same db server) 23 public $db; 27 …$this->db = new PDO2(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS, [PDO::ATTR_PERS… 29 …$this->db = new PDO3(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS, [PDO::ATTR_PERS… 31 $this->db->query('SELECT 1')->fetchAll(); 45 ["db"]=> 52 ["db"]=>
|
H A D | pdo_mysql_stmt_blobfromstream.phpt | 34 function blob_from_stream($offset, $db, $file, $blob) { 57 $db->exec($sql); 77 var_export($db->errorInfo(), true)); 116 $db = MySQLPDOTest::factory(); 124 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 125 blob_from_stream(10, $db, $file, $blob); 130 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 131 blob_from_stream(30, $db, $file, $blob); 135 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 143 $db = MySQLPDOTest::factory(); [all …]
|
/php-src/ext/pgsql/tests/ |
H A D | 28large_object_import_oid.phpt | 17 $db = pg_connect($conn_str); 20 pg_exec($db, 'BEGIN'); 21 $oid = pg_lo_import($db, __FILE__, 21003); 24 pg_lo_unlink ($db, $oid); 25 pg_exec($db, 'COMMIT'); 28 pg_exec($db, 'BEGIN'); 32 pg_lo_unlink ($db, $oid); 33 pg_exec($db, 'COMMIT'); 50 pg_lo_import($db, __FILE__, -15); 70 pg_lo_import($db, __FILE__, []); [all …]
|
H A D | 18pg_escape_bytea_before.phpt | 17 $db = pg_connect($conn_str); 18 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); 20 @pg_query($db, "SET bytea_output = 'escape'"); 22 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, E\''.$esc_image.'\');'); 23 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876'); 39 $db = pg_connect($conn_str); 40 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
|
H A D | 17result.phpt | 14 $db = pg_connect($conn_str); 15 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); 16 pg_query($db, "INSERT INTO {$table_name} VALUES(1, 'ABC', null)"); 17 pg_query($db, "INSERT INTO {$table_name} VALUES(1, 'ABC', null)"); 20 $result = pg_query($db, $sql) or die('Cannot query db'); 37 $db = pg_connect($conn_str); 38 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
|
H A D | 29nb_async_connect.phpt | 15 if (!$db = pg_connect($conn_str, PGSQL_CONNECT_ASYNC)) { 17 } elseif (pg_connection_status($db) === PGSQL_CONNECTION_BAD) { 19 } elseif ($db_socket = pg_socket($db)) { 26 switch ($status = pg_connect_poll($db)) { 41 assert(pg_connection_status($db) === PGSQL_CONNECTION_OK); 44 pg_close($db);
|
/php-src/ext/pdo/tests/ |
H A D | bug_35671.phpt | 16 $db = PDOTest::factory(); 18 $db->exec('CREATE TABLE test35671 (field1 VARCHAR(32), field2 VARCHAR(32), field3 VARCHAR(32))'); 19 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 21 $insert = $db->prepare("insert into test35671 (field1, field2, field3) values (:value1, :value2, :v… 32 var_dump($db->query("SELECT * from test35671")->fetchAll(PDO::FETCH_ASSOC)); 38 $db = PDOTest::factory(); 39 PDOTest::dropTableIfExists($db, "test35671");
|
H A D | pdo_006.phpt | 16 $db = PDOTest::factory(); 18 $db->exec('CREATE TABLE test006(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); 19 $db->exec("INSERT INTO test006 VALUES(1, 'A')"); 20 $db->exec("INSERT INTO test006 VALUES(2, 'A')"); 21 $db->exec("INSERT INTO test006 VALUES(3, 'C')"); 23 $stmt = $db->prepare('SELECT val, id from test006'); 35 $db = PDOTest::factory(); 36 PDOTest::dropTableIfExists($db, "test006");
|
H A D | pdo_007.phpt | 16 $db = PDOTest::factory(); 18 $db->exec('CREATE TABLE test007(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))'); 19 $db->exec("INSERT INTO test007 VALUES('A', 'A')"); 20 $db->exec("INSERT INTO test007 VALUES('B', 'A')"); 21 $db->exec("INSERT INTO test007 VALUES('C', 'C')"); 23 $stmt = $db->prepare('SELECT id, val from test007'); 35 $db = PDOTest::factory(); 36 PDOTest::dropTableIfExists($db, "test007");
|
H A D | pdo_033.phpt | 17 $db = PDOTest::factory(); 21 $quoted = $db->quote($unquoted); 25 $db->query("CREATE TABLE test033 (t char($len))"); 26 $db->query("INSERT INTO test033 (t) VALUES($quoted)"); 28 $stmt = $db->prepare('SELECT * from test033'); 36 $db = PDOTest::factory(); 37 PDOTest::dropTableIfExists($db, "test033");
|
/php-src/ext/pdo_pgsql/tests/ |
H A D | copy_to.phpt | 15 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 16 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 17 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 21 $db->beginTransaction(); 36 $db->commit(); 39 var_dump($db->pgsqlCopyToArray('test_copy_to')); 41 var_dump($db->pgsqlCopyToArray('test_copy_to',";","NULL")); 47 var_dump($db->pgsqlCopyToArray('test_error')); 55 var_dump($db->pgsqlCopyToFile('test_copy_to',$filename)); 85 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); [all …]
|
/php-src/ext/pdo_mysql/tests/inc/ |
H A D | mysql_pdo_test.inc | 23 $db = new $classname($dsn, $user, $pass, $attr); 24 if (!$db) { 31 return $db; 42 $db->exec("DROP TABLE IF EXISTS {$table}"); 84 static function getClientVersion($db) { 88 static function getServerVersion($db) { 146 foreach ($db->query("SHOW ENGINES") as $row) { 166 $db = self::factory(); 173 $db = self::factory(); 187 $db = self::factory(); [all …]
|
/php-src/ext/mysqli/tests/ |
H A D | mysqli_change_user.phpt | 13 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 15 $host, $user, $db, $port, $socket); 22 $host, $user, $db, $port, $socket); 30 $host, $user, $db, $port, $socket); 52 if ($tmp['dbname'] != $db) 62 $host, $user, $db, $port, $socket); 72 $host, $user, $db, $port, $socket); 76 (empty db = no db send with COM_CHANGE_USER) */ 91 mysqli_change_user($link, $user, $passwd, $db); 98 $host, $user, $db, $port, $socket); [all …]
|
/php-src/ext/pdo_sqlite/tests/ |
H A D | bug70862.phpt | 8 $db = new PDO('sqlite::memory:'); 9 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 11 $db->exec('CREATE TABLE test_70862(field BLOB)'); 13 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 27 $stmt = $db->prepare('INSERT INTO test_70862(field) VALUES (:para)');
|