Home
last modified time | relevance | path

Searched refs:db (Results 76 – 100 of 868) sorted by relevance

12345678910>>...35

/php-src/ext/pdo_mysql/tests/
H A Dgh11587.phpt14 $db = MySQLPDOTest::factory();
25 $db->exec($createTestTable);
31 $db->exec($insertTestTable);
34 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
36 $results = $db->query('SELECT * FROM test_11587');
44 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
46 $results = $db->query('SELECT * FROM test_11587');
56 $results = $db->query('SELECT * FROM test_11587');
66 $results = $db->query('SELECT * FROM test_11587');
78 $db = MySQLPDOTest::factory();
[all …]
H A Dbug_42499.phpt13 $db = MySQLPDOTest::factory();
15 function bug_42499($db) {
16 $db->exec("DROP TABLE IF EXISTS test_42499");
23 $db->exec('SELECT id FROM test_42499');
29 $db = MySQLPDOTest::factory();
30 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
32 bug_42499($db);
35 $db = MySQLPDOTest::factory();
38 bug_42499($db);
45 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_prepare_emulated_myisam_index.phpt13 $db = MySQLPDOTest::factory();
14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
21 $stmt = @$db->prepare($query);
23 $stmt = $db->prepare($query);
26 $tmp = $db->errorInfo();
80 $db->errorCode(), implode(' ', $db->errorInfo()));
132 $db->quote('%ro%'));
139 $db->quote('%ro%'));
140 $stmt = prepex(15, $db, $sql, array(1));
155 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
[all …]
H A Dpdo_mysql_prepare_native_anonymous_placeholder.phpt13 $db = MySQLPDOTest::factory();
18 $stmt = @$db->prepare($query);
20 $stmt = $db->prepare($query);
23 $tmp = $db->errorInfo();
86 $db->errorCode(), implode(' ', $db->errorInfo()));
216 $db->quote('%ro%'));
217 $stmt = prepex(30, $db, $sql, array(-1));
222 $db->quote('%ro%'));
223 $stmt = prepex(31, $db, $sql, array(1));
234 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
[all …]
H A Dpdo_mysql_stmt_variable_columncount.phpt13 $db = MySQLPDOTest::factory();
44 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
45 $stmt = $db->prepare("CALL {$procedure}(?)");
58 $db = MySQLPDOTest::factory();
76 $db->exec('SET @numcols = 1');
77 $stmt = $db->prepare("CALL {$procedure}()");
82 $db->exec('SET @numcols = 1');
89 $db = MySQLPDOTest::factory();
92 $db->exec('SET @numcols = 1');
98 $db->exec('SET @numcols = 1');
[all …]
H A Dpdo_mysql_local_infile_directory_denied.phpt16 function exec_and_count($offset, &$db, $sql, $exp) {
18 $ret = $db->exec($sql);
22 $db->errorCode(), implode(' ', $db->errorInfo()));
27 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
35 $db = MySQLPDOTest::factoryWithAttr([
41 …exec_and_count(2, $db, sprintf('CREATE TABLE test_local_inifile_dir_denied(id INT NOT NULL PRIMARY…
46 if (exec_and_count(3, $db, $sql, false)) {
47 $stmt = $db->query('SELECT id, col1 FROM test_local_inifile_dir_denied ORDER BY id ASC');
61 $db->errorCode(), implode(' ', $db->errorInfo()));
69 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_fetch_both.phpt13 $db = MySQLPDOTest::factory();
15 function fetch($offset, &$db, $query, $expect = null) {
17 $stmt = $db->query('SELECT 1');
20 $stmt = $db->query('SELECT 1');
23 $stmt = $db->query('SELECT 1');
41 $e->getMessage(), $db->errroCode(), implode(' ', $db->errorInfo()));
46 fetch(2, $db, 'SELECT 1', array(0 => '1', '1' => '1'));
49 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
H A Dpdo_mysql_prepare_emulated_myisam.phpt13 $db = MySQLPDOTest::factory();
14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
19 $stmt = @$db->prepare($query);
21 $stmt = $db->prepare($query);
24 $tmp = $db->errorInfo();
77 $db->errorCode(), implode(' ', $db->errorInfo()));
85 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
125 $db->quote('%ro%'));
132 $db->quote('%ro%'));
143 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
[all …]
H A Dpdo_mysql_bit.phpt19 @$db->exec($sql);
20 if ($db->errorCode() != 0) {
25 $stmt = $db->prepare('INSERT INTO test_mysql_bit(id, label) VALUES (?, ?)');
32 $stmt = $db->query('SELECT id, label FROM test_mysql_bit');
40 $db = MySQLPDOTest::factory();
41 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
42 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
43 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
45 test_type($db, 20, 'BIT(8)', 1);
52 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_exec_select.phpt12 function exec_and_count($offset, &$db, $sql, $exp) {
14 $ret = $db->exec($sql);
18 $db->errorCode(), implode(' ', $db->errorInfo()));
24 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
32 $db = MySQLPDOTest::factory();
38 exec_and_count(4, $db, "INSERT INTO test_mysql_exec_select(id, col1) VALUES (1, 'a')", 1);
41 $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
42 exec_and_count(5, $db, 'SELECT id FROM test_mysql_exec_select', 0);
48 $db->errorCode(), implode(' ', $db->errorInfo()));
56 $db = MySQLPDOTest::factory();
[all …]
/php-src/ext/pgsql/tests/
H A D13pg_select_9.phpt17 $db = pg_connect($conn_str);
19 pg_query($db, "INSERT INTO {$table_name} VALUES(1234, 'AAA', 'BBB')");
22 pg_query($db, "SET bytea_output = 'hex'");
26 $res = pg_select($db, $table_name, $ids) or print "Error\n";
28 echo pg_select($db, $table_name, $ids, PGSQL_DML_STRING)."\n";
33 $converted = pg_select($db, $table_name, [5 => 'AAA']);
38 $converted = pg_select($db, $table_name, ['AAA']);
43 $converted = pg_select($db, $table_name, ['num' => []]);
53 $converted = pg_select($db, $table_name, ['num' => $db]);
67 $db = pg_connect($conn_str);
[all …]
H A D12pg_insert_9.phpt17 $db = pg_connect($conn_str);
20 pg_query($db, "SET standard_conforming_strings = 0");
24 pg_insert($db, $table_name, $fields) or print "Error in test 1\n";
25 echo pg_insert($db, $table_name, $fields, PGSQL_DML_STRING)."\n";
27 var_dump( pg_insert($db, $table_name, $fields, PGSQL_DML_EXEC) );
31 $converted = pg_insert($db, $table_name, [5 => 'AAA']);
36 $converted = pg_insert($db, $table_name, ['AAA']);
41 $converted = pg_insert($db, $table_name, ['num' => []]);
51 $converted = pg_insert($db, $table_name, ['num' => $db]);
64 $db = pg_connect($conn_str);
[all …]
H A D15pg_delete.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)");
21 echo pg_delete($db, $table_name, $ids, PGSQL_DML_STRING)."\n";
22 echo pg_delete($db, $table_name, $ids, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n";
23 if (!pg_delete($db, $table_name, $ids)) {
35 $db = pg_connect($conn_str);
36 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
H A D14pg_update_9.phpt17 $db = pg_connect($conn_str);
18 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
19 pg_query($db, "INSERT INTO {$table_name} VALUES(1, 'ABC', null)");
20 pg_query($db, "INSERT INTO {$table_name} VALUES(1, 'ABC', null)");
22 pg_query($db, "SET standard_conforming_strings = 0");
27 pg_update($db, $table_name, $fields, $ids) or print "Error in test 1\n";
28 echo pg_update($db, $table_name, $fields, $ids, PGSQL_DML_STRING)."\n";
29 echo pg_update($db, $table_name, $fields, $ids, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n";
38 $db = pg_connect($conn_str);
39 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
H A D06copy.phpt13 $db = pg_connect($conn_str);
14 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
16 $rows = pg_copy_to($db, $table_name);
18 pg_query($db, "DELETE FROM $table_name");
20 pg_copy_from($db, $table_name, $rows);
30 $db = pg_connect($conn_str);
31 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
H A D06_bug73498.phpt14 $db = pg_connect($conn_str);
15 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
16 pg_query($db, "CREATE VIEW {$view_name} as SELECT * FROM {$table_name}");
17 pg_query($db, "INSERT INTO {$table_name} DEFAULT VALUES");
19 $rows = pg_copy_to($db, "(SELECT * FROM {$view_name})");
31 $db = pg_connect($conn_str);
32 pg_query($db, "DROP VIEW IF EXISTS {$view_name}");
33 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
/php-src/ext/pdo_odbc/tests/
H A Dmax_columns.phpt13 $db = PDOTest::test_factory('ext/pdo_odbc/tests/common.phpt');
14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
16 if (false === $db->exec('CREATE TABLE test_max_columns (id INT NOT NULL PRIMARY KEY, data varchar(m…
19 … die("BORK: don't know how to create a long column here:\n" . implode(", ", $db->errorInfo()));
24 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
28 $db->beginTransaction();
29 $insert = $db->prepare('INSERT INTO test_max_columns VALUES (?, ?)');
34 $db->commit();
36 foreach ($db->query('SELECT id, data from test_max_columns') as $row) {
51 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
[all …]
/php-src/ext/pdo_dblib/tests/
H A Dstringify_uniqueidentifier.phpt8 $db = getDbConnection();
15 $db = getDbConnection();
25 $db->setAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER, true);
26 var_dump(true === $db->getAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER));
27 $db->setAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER, false);
34 $stmt = $db->query($sql);
43 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
44 $stmt = $db->query($sql);
46 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
57 $db->setAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER, true);
[all …]
H A Ddatetime2.phpt8 $db = getDbConnection();
9 if (in_array($db->getAttribute(PDO::DBLIB_ATTR_TDS_VERSION), ['4.2', '4.6', '5.0', '6.0', '7.0', '7…
15 $db = getDbConnection();
19 var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT));
21 $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);
H A Dpdodblib_002.phpt15 $db = connectToDb();
16 if (!$db instanceof Pdo\Dblib) {
17 echo "Wrong class type. Should be Pdo\Dblib but is " . get_class($db) . "\n";
20 $db->query("CREATE TABLE #pdo_dblib_002(name VARCHAR(32))");
21 $db->query("INSERT INTO #pdo_dblib_002 VALUES('PHP'), ('PHP6')");
23 foreach ($db->query('SELECT name FROM #pdo_dblib_002') as $row) {
32 $db = getDbConnection();
33 $db->query('DROP TABLE IF EXISTS #pdo_dblib_002');
/php-src/ext/pdo/tests/
H A Dbug_71447.phpt17 $db = PDOTest::factory();
21 $db->exec('CREATE TABLE test71447(id int)');
22 $db->exec('INSERT INTO test71447 VALUES(1)');
25 $stmt = $db->prepare("
35 $stmt = $db->prepare("
45 $stmt = $db->prepare("
55 $stmt = $db->prepare("
65 $stmt = $db->prepare("
75 $stmt = $db->prepare("
86 $stmt = $db->prepare("
[all …]
H A Dpdo_032.phpt16 $db = PDOTest::factory();
18 $db->exec('CREATE TABLE test032(id int NOT NULL PRIMARY KEY, val VARCHAR(10))');
19 $db->exec("INSERT INTO test032 VALUES(1, 'A')");
20 $db->exec("INSERT INTO test032 VALUES(2, 'B')");
21 $db->exec("INSERT INTO test032 VALUES(3, 'C')");
24 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER);
25 $stmt = $db->prepare('SELECT * from test032');
31 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_UPPER);
32 $stmt = $db->prepare('SELECT * from test032');
41 $db = PDOTest::factory();
[all …]
/php-src/ext/sqlite3/tests/
H A Dbug68760.phpt12 $db = new SQLite3(":memory:");
13 $db->exec("CREATE TABLE test (col1 string)");
14 $db->exec("INSERT INTO test VALUES ('a1')");
15 $db->exec("INSERT INTO test VALUES ('a10')");
16 $db->exec("INSERT INTO test VALUES ('a2')");
19 $db->createCollation('NATURAL_CMP', 'oopsFunction');
20 $naturalSort = $db->query("SELECT col1 FROM test ORDER BY col1 COLLATE NATURAL_CMP");
24 $db->close();
/php-src/ext/pdo_pgsql/tests/
H A Dbug71885_2.phpt12 $db = PDOTest::factory();
13 if (version_compare($db->getAttribute(PDO::ATTR_SERVER_VERSION), '9.4.0') < 0) {
22 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
23 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
24 $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_NUM);
26 $jsonb = $db->quote(json_encode(['a' => 1]));
29 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, $emulate);
31 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ?? ?");
35 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ???");
H A Dbug_49985.phpt15 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
16 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
18 $db->exec("CREATE TABLE b49985 (a int PRIMARY KEY)");
22 $db->beginTransaction();
23 $stmt = $db->prepare("INSERT INTO b49985 (a) VALUES (?)");
25 $db->commit();
28 $db->rollback();
36 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
37 $db->query('DROP TABLE IF EXISTS b49985 CASCADE');

Completed in 28 milliseconds

12345678910>>...35