Home
last modified time | relevance | path

Searched refs:db (Results 51 – 75 of 751) sorted by relevance

12345678910>>...31

/PHP-7.1/ext/pdo_pgsql/tests/
H A Dis_in_transaction.phpt13 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
15 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
19 $db->beginTransaction();
22 var_dump($db->inTransaction());
29 $db->commit();
32 var_dump($db->inTransaction());
34 $db->beginTransaction();
44 var_dump($db->inTransaction());
45 $db->rollBack();
[all …]
/PHP-7.1/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_errorinfo.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
14 MySQLPDOTest::createTestTable($db);
27 MySQLPDOTest::createTestTable($db);
29 $db->exec('DROP TABLE test');
32 var_dump($db->errorInfo());
36 $e->getMessage(), $db->errorInfo(), implode(' ', $db->errorInfo()));
48 MySQLPDOTest::createTestTable($db);
51 $db->exec('DROP TABLE test');
54 var_dump($db->errorInfo());
[all …]
H A Dpdo_mysql___construct_options.phpt21 if (!is_object($db) || ($value !== ($tmp = @$db->getAttribute($option))))
72 printf("[001] Expecting NULL got %s/%s\n", gettype($db), $db);
77 printf("[002] Expecting object got %s/%s¸\n", gettype($db), $db);
85 $db = new PDO($dsn, $user, $pass);
88 $tmp = @$db->getAttribute($option);
96 if (!is_object($db) || !$db->getAttribute(PDO::ATTR_AUTOCOMMIT))
100 if (!is_object($db) || $db->getAttribute(PDO::ATTR_AUTOCOMMIT))
115 if (!is_object($db))
124 if (!is_object($db))
162 (is_object($db)) ? $db->errorCode() : 'n/a',
[all …]
H A Dpdo_mysql_multi_stmt_nextrowset.phpt8 $db = MySQLPDOTest::factory();
25 $db = MySQLPDOTest::factory();
28 MySQLPDOTest::createTestTable($db);
30 function test_proc($db) {
32 $db->exec('DROP PROCEDURE IF EXISTS p');
34 $stmt = $db->query('CALL p()');
56 test_proc($db);
63 test_proc($db);
72 $info = $db->errorInfo();
75 @$db->exec('DROP PROCEDURE IF EXISTS p');
[all …]
H A Dbug_39858.phpt9 $db = MySQLPDOTest::factory();
26 $db = MySQLPDOTest::factory();
29 function bug_39858($db) {
31 $db->exec("DROP PROCEDURE IF EXISTS p");
32 $db->exec("
42 $stmt = $db->prepare("CALL p()");
48 $stmt = $db->prepare("CALL p()");
59 bug_39858($db);
63 bug_39858($db);
70 $db = MySQLPDOTest::factory();
[all …]
H A Dbug_42499.phpt11 $db = MySQLPDOTest::factory();
25 $db = MySQLPDOTest::factory();
27 function bug_42499($db) {
29 $db->exec('DROP TABLE IF EXISTS test');
36 $db->exec('SELECT id FROM test');
43 $db = MySQLPDOTest::factory();
46 bug_42499($db);
49 $db = MySQLPDOTest::factory();
52 bug_42499($db);
54 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_stmt_multiquery.phpt13 function mysql_stmt_multiquery_wrong_usage($db) {
22 function mysql_stmt_multiquery_proper_usage($db) {
34 $db = MySQLPDOTest::factory();
35 MySQLPDOTest::createTestTable($db);
37 mysql_stmt_multiquery_wrong_usage($db);
38 mysql_stmt_multiquery_proper_usage($db);
41 $db = MySQLPDOTest::factory();
42 MySQLPDOTest::createTestTable($db);
44 mysql_stmt_multiquery_wrong_usage($db);
45 mysql_stmt_multiquery_proper_usage($db);
[all …]
H A Dpdo_mysql___construct.phpt22 (isset($db) && is_object($db)) ? $db->errorCode() : 'n/a',
23 (isset($db) && is_object($db)) ? implode(' ', $db->errorInfo()) : 'n/a');
32 if (NULL !== ($db = @new PDO()))
62 $db = new PDO($dsn, $user, $pass);
139 $db = @new PDO($dsn, $user, $pass);
147 $db = PDO_MYSQL_TEST_DB;
185 $db = new PDO($dsn, $user, $pass);
206 $db = new PDO($dsn, $user, $pass);
247 $db = new PDO($dsn, $user, $pass);
289 (is_object($db)) ? $db->errorCode() : 'n/a',
[all …]
H A Dpdo_mysql_prepare_emulated_anonymous.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
16 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
20 $db->exec('DROP TABLE IF EXISTS test');
31 $stmt = $db->prepare('SELECT id, label FROM test');
37 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
41 $db->exec('DELETE FROM test');
50 $stmt = $db->prepare('SELECT id, label FROM test');
56 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
64 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_bit.phpt18 $db->exec('DROP TABLE IF EXISTS test');
20 @$db->exec($sql);
21 if ($db->errorCode() != 0) {
33 $stmt = $db->query('SELECT id, label FROM test');
41 $db = MySQLPDOTest::factory();
42 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
43 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
44 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
46 test_type($db, 20, 'BIT(8)', 1);
53 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_stmt_errorcode.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
15 $db->exec('DROP TABLE IF EXISTS ihopeitdoesnotexist');
19 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
20 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
23 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
30 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
35 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
36 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
39 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
[all …]
H A Dpdo_mysql_fetch_both.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
15 function fetch($offset, &$db, $query, $expect = null) {
18 $stmt = $db->query('SELECT 1');
21 $stmt = $db->query('SELECT 1');
24 $stmt = $db->query('SELECT 1');
44 $e->getMessage(), $db->errroCode(), implode(' ', $db->errorInfo()));
52 fetch(2, $db, 'SELECT 1', array(0 => '1', '1' => '1'));
56 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
H A Dpdo_mysql_prepare_match_against.phpt12 $db = MySQLPDOTest::factory();
16 $db->exec('DROP TABLE IF EXISTS test');
17 $db->exec('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM');
18 $db->exec('CREATE FULLTEXT INDEX idx1 ON test(label)');
20 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)');
24 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)');
28 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (?)');
35 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
44 $db = MySQLPDOTest::factory();
45 $db->exec('DROP TABLE IF EXISTS test');
H A Dpdo_mysql_prepare_native_dup_named_placeholder.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
17 $db->exec('DROP TABLE IF EXISTS test');
20 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
40 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
62 $db->exec('DELETE FROM test');
67 $stmt = $db->prepare($sql);
81 $stmt = $db->prepare($sql);
92 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
100 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_prepare_native_placeholder_everywhere.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
15 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
16 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
19 $db->exec('DROP TABLE IF EXISTS test');
21 $db->exec("INSERT INTO test(id, label) VALUES (1, 'row1')");
33 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
34 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
57 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
65 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_prepare_load_data.phpt10 $db = MySQLPDOTest::factory();
11 $stmt = $db->query('SELECT USER() as _user');
37 $ret = $db->exec($sql);
41 $db->errorCode(), implode(' ', $db->errorInfo()));
47 if (42000 == $db->errorCode()) {
54 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
62 $db = MySQLPDOTest::factory();
66 MySQLPDOTest::createTestTable($db, MySQLPDOTest::detect_transactional_mysql_engine($db));
96 $stmt = $db->query("SELECT 1 as 'one'");
110 $db->errorCode(),
[all …]
H A Dpdo_mysql_prepare_native_column.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
14 MySQLPDOTest::createTestTable($db);
16 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
17 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
20 $stmt = $db->prepare("SELECT :param FROM test ORDER BY id ASC LIMIT 1");
24 $db->prepare('SELECT :placeholder FROM test WHERE :placeholder > :placeholder');
34 $db = MySQLPDOTest::factory();
35 $db->exec('DROP TABLE IF EXISTS test');
H A Dpdo_mysql_attr_max_buffer_size.phpt24 $db = new PDO($dsn, $user, $pass,
32 $db->exec('DROP TABLE IF EXISTS test');
33 $db->exec(sprintf('CREATE TABLE test(id INT, val LONGBLOB) ENGINE = %s', PDO_MYSQL_TEST_ENGINE));
36 $db->exec('INSERT INTO test(id, val) VALUES (1, REPEAT("01234567890", 10240))');
38 $stmt = $db->prepare('SELECT id, val FROM test');
48 $db->exec('DROP TABLE IF EXISTS test');
54 (is_object($db)) ? $db->errorCode() : 'n/a',
55 (is_object($db)) ? implode(' ', $db->errorInfo()) : 'n/a');
69 $db = MySQLPDOTest::factory();
70 $db->exec('DROP TABLE IF EXISTS test');
/PHP-7.1/ext/sqlite3/tests/
H A Dbug68760.phpt14 $db = new SQLite3(":memory:");
15 $db->exec("CREATE TABLE test (col1 string)");
16 $db->exec("INSERT INTO test VALUES ('a1')");
17 $db->exec("INSERT INTO test VALUES ('a10')");
18 $db->exec("INSERT INTO test VALUES ('a2')");
21 $db->createCollation('NATURAL_CMP', 'oopsFunction');
22 $naturalSort = $db->query("SELECT col1 FROM test ORDER BY col1 COLLATE NATURAL_CMP");
26 $db->close();
/PHP-7.1/ext/pdo_dblib/tests/
H A Dpdo_dblib_quote.phpt11 var_dump($db->quote(true, PDO::PARAM_BOOL));
12 var_dump($db->quote(false, PDO::PARAM_BOOL));
13 var_dump($db->quote(42, PDO::PARAM_INT));
14 var_dump($db->quote(null, PDO::PARAM_NULL));
15 var_dump($db->quote('\'', PDO::PARAM_STR));
16 var_dump($db->quote('foo', PDO::PARAM_STR));
17 var_dump($db->quote('über', PDO::PARAM_STR));
/PHP-7.1/ext/pgsql/tests/
H A D25async_query_params.phpt13 $db = pg_connect($conn_str);
15 $version = pg_version($db);
17 if (!pg_send_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100))) {
20 while(pg_connection_busy($db)); // busy wait: intended
21 if (pg_connection_status($db) === PGSQL_CONNECTION_BAD) {
24 if (!($result = pg_get_result($db)))
48 pg_num_rows(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)));
49 pg_num_fields(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)));
57 …if (!pg_send_query_params($db, "INSERT INTO ".$table_name." VALUES (\$1, \$2);", array(9999, "A'BC…
65 pg_close($db);
H A D28large_object_import_oid.phpt15 $db = pg_connect($conn_str);
18 pg_exec($db, 'begin');
19 $oid = pg_lo_import($db, __FILE__, 21003);
22 pg_lo_unlink ($db, $oid);
23 pg_exec($db, 'commit');
26 pg_exec($db, 'begin');
27 $oid = pg_lo_import($db, __FILE__, "21004");
30 pg_lo_unlink ($db, $oid);
31 pg_exec($db, 'commit');
35 $oid = pg_lo_import($db, __FILE__, 21005);
/PHP-7.1/ext/pdo/tests/
H A Dbug_71447.phpt16 $db = PDOTest::factory();
19 $db->setAttribute (\PDO::ATTR_EMULATE_PREPARES, false);
20 $db->exec('CREATE TABLE test(id int)');
21 $db->exec('INSERT INTO test VALUES(1)');
24 $stmt = $db->prepare("
34 $stmt = $db->prepare("
44 $stmt = $db->prepare("
54 $stmt = $db->prepare("
64 $stmt = $db->prepare("
74 $stmt = $db->prepare("
[all …]
/PHP-7.1/ext/pdo_odbc/tests/
H A Dmax_columns.phpt10 $db = PDOTest::test_factory('ext/pdo_odbc/tests/common.phpt');
11 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
13 if (false === $db->exec('CREATE TABLE TEST (id INT NOT NULL PRIMARY KEY, data varchar(max))')) {
14 if (false === $db->exec('CREATE TABLE TEST (id INT NOT NULL PRIMARY KEY, data longtext)')) {
15 if (false === $db->exec('CREATE TABLE TEST (id INT NOT NULL PRIMARY KEY, data CLOB)')) {
16 die("BORK: don't know how to create a long column here:\n" . implode(", ", $db->errorInfo()));
21 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
25 $db->beginTransaction();
26 $insert = $db->prepare('INSERT INTO TEST VALUES (?, ?)');
31 $db->commit();
[all …]
/PHP-7.1/ext/pdo_oci/tests/
H A Dbug54379.phpt15 $db = PDOTest::test_factory('ext/pdo_oci/tests/common.phpt');
16 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
18 $db->exec("DROP TABLE test");
21 $db->exec("CREATE TABLE test (col1 NVARCHAR2(20))");
22 $db->exec("INSERT INTO test VALUES('12345678901234567890')");
23 $db->exec("INSERT INTO test VALUES('あいうえおかきくけこさしすせそたちつてと')");
24 $stmt = $db->prepare("SELECT * FROM test");
27 $db->exec("DROP TABLE test");

Completed in 29 milliseconds

12345678910>>...31