Home
last modified time | relevance | path

Searched refs:db (Results 176 – 200 of 868) sorted by relevance

12345678910>>...35

/php-src/ext/pdo_odbc/tests/
H A Dpdoodbc_002.phpt15 $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 Dsqlite3_trampoline_setauthorizer_null.phpt8 $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 Dsqlite3_24_last_insert_rowid.phpt12 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 Dsqlite3_enable_exceptions.phpt11 $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 Ddba_array_keys_var_non_string.phpt13 $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 Dpdosqlite_001.phpt8 $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 Dpdodblib_001.phpt14 $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 Dbug_69592.phpt14 $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 Ddatetime_convert.phpt14 $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 Dpdo_mysql_prepare_native_mixed_style.phpt13 $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 Dpdo_mysql_prepare_native_clear_error.phpt13 $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 Dbug63176.phpt2 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 Dpdo_mysql_stmt_blobfromstream.phpt34 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 D28large_object_import_oid.phpt17 $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 D18pg_escape_bytea_before.phpt17 $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 D17result.phpt14 $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 D29nb_async_connect.phpt15 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 Dbug_35671.phpt16 $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 Dpdo_006.phpt16 $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 Dpdo_007.phpt16 $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 Dpdo_033.phpt17 $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 Dcopy_to.phpt15 $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 Dmysql_pdo_test.inc23 $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 Dmysqli_change_user.phpt13 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 Dbug70862.phpt8 $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)');

Completed in 24 milliseconds

12345678910>>...35