Home
last modified time | relevance | path

Searched refs:db (Results 26 – 50 of 777) sorted by relevance

12345678910>>...32

/PHP-7.4/ext/pdo/tests/
H A Dbug_64172.phpt16 $db = PDOTest::factory();
18 @$db->exec("DROP TABLE test");
19 $db->exec("CREATE TABLE test (x int)");
20 $db->exec("INSERT INTO test VALUES (1)");
23 $db->query('SELECT * FROM bad_table');
27 var_dump(is_int($db->errorInfo()[1])) . "\n";
30 $stmt = $db->query('SELECT * FROM test');
33 var_dump($db->errorInfo());
43 $db->exec("INSERT INTO test VALUES (2)");
44 var_dump($db->errorInfo());
[all …]
/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_exec.phpt15 $ret = $db->exec($sql);
19 $db->errorCode(), implode(' ', $db->errorInfo()));
25 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
33 $db = MySQLPDOTest::factory();
34 MySQLPDOTest::createTestTable($db, MySQLPDOTest::detect_transactional_mysql_engine($db));
54 printf("[016] [%s] %s\n", $db->errorCode(), implode(' ', $db->errorInfo()));
65 $db->errorCode(), implode(' ', $db->errorInfo()));
107 $db->errorCode(), implode(' ', $db->errorInfo()));
144 $db->errorCode(), implode(' ', $db->errorInfo()));
159 $db->errorCode(), var_export($db->errorInfo(), true));
[all …]
H A Dpdo_mysql_attr_autocommit.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
25 if (!$db->setAttribute(PDO::ATTR_AUTOCOMMIT, 0))
33 if (!$db->query('SET autocommit = 1'))
40 if (!$db->query('SET autocommit = 0'))
43 if (!$db->setAttribute(PDO::ATTR_AUTOCOMMIT, 1))
56 MySQLPDOTest::createTestTable($db, MySQLPDOTest::detect_transactional_mysql_engine($db));
67 $db->query('ROLLBACK');
75 $db->query('DELETE FROM test WHERE id = 100');
76 $db->query('ROLLBACK');
[all …]
H A Dpdo_mysql_attr_case.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
31 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
37 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
45 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
49 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
53 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
59 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
67 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
73 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
[all …]
H A Dpdo_mysql_get_attribute.phpt8 $db = MySQLPDOTest::factory();
15 $db = MySQLPDOTest::factory();
16 MySQLPDOTest::createTestTable($db, MySQLPDOTest::detect_transactional_mysql_engine($db));
18 function set_and_get($offset, $db, $attribute, $value) {
23 if (!$db->setAttribute($attribute, $value)) {
35 $tmp = $db->getAttribute($attribute);
45 $db->errorCode(), implode(' ', $db->errorInfo()));
52 set_and_get(1, $db, PDO::ATTR_AUTOCOMMIT, 1);
54 set_and_get(2, $db, PDO::ATTR_AUTOCOMMIT, 0);
55 set_and_get(3, $db, PDO::ATTR_AUTOCOMMIT, -1);
[all …]
H A Dpdo_mysql_types_zerofill.phpt15 $db->exec('DROP TABLE IF EXISTS test');
17 @$db->exec($sql);
18 if ($db->errorCode() != 0) {
37 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
38 $stmt = $db->query('SELECT id, label FROM test');
78 $stmt = $db->query('SELECT id, label FROM test');
89 $db = MySQLPDOTest::factory();
91 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
94 $stmt = $db->prepare('SELECT @@sql_mode AS _mode');
124 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_prepare_emulated.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
22 $stmt = $db->prepare($query);
25 $tmp = $db->errorInfo();
79 $db->errorCode(), implode(' ', $db->errorInfo()));
92 prepex(3, $db, '',
183 $db->quote('%ro%'));
190 $db->quote('%ro%'));
292 $db->quote('%ro%'));
299 $db->quote('%ro%'));
[all …]
H A Dbug_pecl_7976.phpt9 $db = MySQLPDOTest::factory();
24 $db = MySQLPDOTest::factory();
26 function bug_pecl_7976($db) {
28 $db->exec('DROP PROCEDURE IF EXISTS p');
31 $stmt = $db->query('CALL p()');
35 $stmt = $db->query('CALL p()');
42 $db = MySQLPDOTest::factory();
44 bug_pecl_7976($db);
47 $db = MySQLPDOTest::factory();
49 bug_pecl_7976($db);
[all …]
H A Dpdo_mysql_quote.phpt12 $db = MySQLPDOTest::factory();
14 var_dump($db->quote('foo', PDO::PARAM_STR));
15 var_dump($db->quote('foo', PDO::PARAM_STR | PDO::PARAM_STR_CHAR));
16 var_dump($db->quote('über', PDO::PARAM_STR | PDO::PARAM_STR_NATL));
18 var_dump($db->getAttribute(PDO::ATTR_DEFAULT_STR_PARAM) === PDO::PARAM_STR_CHAR);
19 $db->setAttribute(PDO::ATTR_DEFAULT_STR_PARAM, PDO::PARAM_STR_NATL);
20 var_dump($db->getAttribute(PDO::ATTR_DEFAULT_STR_PARAM) === PDO::PARAM_STR_NATL);
22 var_dump($db->quote('foo', PDO::PARAM_STR | PDO::PARAM_STR_CHAR));
23 var_dump($db->quote('über', PDO::PARAM_STR));
24 var_dump($db->quote('über', PDO::PARAM_STR | PDO::PARAM_STR_NATL));
H A Dpdo_mysql_exec_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()));
63 $db = MySQLPDOTest::factory();
64 MySQLPDOTest::createTestTable($db, MySQLPDOTest::detect_transactional_mysql_engine($db));
108 $db->errorCode(), implode(' ', $db->errorInfo()));
116 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_stmt_columncount.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
14 MySQLPDOTest::createTestTable($db);
21 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
22 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
29 $stmt = $db->query('SELECT * FROM test');
34 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
39 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
40 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
47 $stmt = $db->query('SELECT * FROM test');
[all …]
H A Dbug_44454.phpt16 function bug_44454($db) {
20 $db->exec('DROP TABLE IF EXISTS test');
22 $db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
24 $stmt = $db->query('SELECT a, b FROM test');
36 $db->exec('DROP TABLE IF EXISTS test');
44 $stmt = $db->query('SELECT a, b FROM test');
61 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
62 bug_44454($db);
66 bug_44454($db);
73 $db = MySQLPDOTest::factory();
[all …]
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_prepare_native.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
22 $stmt = $db->prepare($query);
25 $tmp = $db->errorInfo();
90 $db->errorCode(), implode(' ', $db->errorInfo()));
103 prepex(3, $db, '',
190 $db->quote('%ro%'));
196 $db->quote('%go%'));
315 $db->quote('%ro%'));
321 $db->quote('%ro%'));
[all …]
/PHP-7.4/ext/pdo_pgsql/tests/
H A Dgetnotify.phpt17 $pid = $db->pgsqlGetPid();
21 var_dump($db->pgsqlGetNotify());
24 $db->exec("LISTEN notifies_phpt");
25 var_dump($db->pgsqlGetNotify());
29 $db->exec("NOTIFY notifies_phpt");
30 $notify = $db->pgsqlGetNotify();
37 $db->exec("NOTIFY notifies_phpt");
38 $notify = $db->pgsqlGetNotify();
44 $db->exec("NOTIFY notifies_phpt");
51 $db->exec("NOTIFY notifies_phpt");
[all …]
H A Dbug68199.phpt10 $db = PDOTest::factory();
23 $pid = $db->pgsqlGetPid();
27 var_dump($db->pgsqlGetNotify());
30 $db->exec("LISTEN notifies_phpt");
31 var_dump($db->pgsqlGetNotify());
35 $db->exec("NOTIFY notifies_phpt, 'payload'");
36 $notify = $db->pgsqlGetNotify();
44 $db->exec("NOTIFY notifies_phpt, 'payload'");
45 $notify = $db->pgsqlGetNotify();
52 $db->exec("NOTIFY notifies_phpt, 'payload'");
[all …]
H A Dis_in_transaction.phpt13 $db = PDOTest::test_factory(__DIR__ . '/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.4/ext/pgsql/tests/
H A D32nb_async_query.phpt14 $db = pg_connect($conn_str);
16 $version = pg_version($db);
22 $db_socket = pg_socket($db);
29 nb_flush($db, $db_socket);
32 nb_consume($db, $db_socket);
34 if (!($result = pg_get_result($db))) {
54 pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";"));
67 nb_flush($db, $db_socket);
70 nb_consume($db, $db_socket);
72 if (!($result = pg_get_result($db))) {
[all …]
H A D01createdb.phpt2 PostgreSQL create db
11 $db = pg_connect($conn_str);
12 if (!@pg_num_rows(@pg_query($db, "SELECT * FROM ".$table_name)))
14 pg_query($db,$table_def); // Create table here
16 pg_query($db,"INSERT INTO ".$table_name." VALUES ($i, 'ABC');");
24 if (version_compare($v['server'], '9.2', '>=') && !@pg_num_rows(@pg_query($db, "SELECT * FROM ".$ta…
26 pg_query($db,$table_def_92); // Create table here
33 pg_query($db,$view_def);
35 pg_close($db);
H A D09notice.phpt19 $db = pg_connect($conn_str);
27 var_dump(pg_last_notice($db));
28 var_dump(pg_last_notice($db, PGSQL_NOTICE_ALL));
30 pg_query($db, "BEGIN;");
31 pg_query($db, "BEGIN;");
32 pg_query($db, "BEGIN;");
33 pg_query($db, "BEGIN;");
36 var_dump(pg_last_notice($db));
37 var_dump(pg_last_notice($db, PGSQL_NOTICE_ALL));
42 var_dump(pg_last_notice($db, PGSQL_NOTICE_ALL));
[all …]
H A Dbug77047.phpt13 $db = pg_connect($conn_str);
15 pg_query($db, "DROP TABLE IF EXISTS bug77047");
16 pg_query($db, "CREATE TABLE bug77047 (
20 pg_insert($db, "bug77047", array("t" => "13:31"));
21 pg_insert($db, "bug77047", array("t" => "13:31:13"));
22 pg_insert($db, "bug77047", array("t" => "1:2:3"));
23 pg_insert($db, "bug77047", array("t" => "xyz"));
24 pg_insert($db, "bug77047", array("t" => NULL));
25 pg_insert($db, "bug77047", array("t" => ""));
27 $res = pg_query($db, "SELECT t FROM bug77047");
/PHP-7.4/ext/pdo_oci/tests/
H A Dpdo_oci_stream_2a.phpt15 $db = PDOTest::factory();
18 $stmt = $db->prepare($query);
22 $stmt = $db->prepare($query);
25 function do_insert($db, $id, $data1, $data2)
27 $db->beginTransaction();
40 $db->commit();
57 do_insert($db, $i * 10 + 2, $a2, $a9);
58 do_insert($db, $i * 10 + 3, $a3, $a8);
59 do_insert($db, $i * 10 + 4, $a4, $a7);
60 do_insert($db, $i * 10 + 5, $a5, $a6);
[all …]
H A Dpdo_oci_stmt_getcolumnmeta.phpt16 $db = PDOTest::factory();
17 $db->exec(<<<SQL
28 $db->exec("CREATE TABLE test(id INT)");
30 $db->beginTransaction();
125 $db->exec(<<<SQL
138 $stmt = $db->prepare($sql);
143 $db->errorCode(), var_export($db->errorInfo(), true));
207 $db->exec(<<<SQL
234 $stmt = $db->prepare($sql);
274 $e->getMessage(), $db->errorInfo(), implode(' ', $db->errorInfo()));
[all …]
/PHP-7.4/ext/dba/tests/
H A Dbug36436.phpt14 $db = dba_popen($db_filename, 'c', 'db4');
16 dba_insert('X', 'XYZ', $db);
17 dba_insert('Y', '123', $db);
19 var_dump($db, dba_fetch('X', $db));
21 var_dump(dba_firstkey($db));
22 var_dump(dba_nextkey($db));
24 dba_close($db);
/PHP-7.4/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_createcollation.phpt8 $db = new PDO('sqlite::memory:');
9 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
11 $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)');
13 $db->query('INSERT INTO foobar VALUES (NULL, "1")');
14 $db->query('INSERT INTO foobar VALUES (NULL, "2")');
15 $db->query('INSERT INTO foobar VALUES (NULL, "10")');
17 $db->sqliteCreateCollation('MYCOLLATE', function($a, $b) { return strnatcmp($a, $b); });
19 $result = $db->query('SELECT name FROM foobar ORDER BY name COLLATE MYCOLLATE');
24 $result = $db->query('SELECT name FROM foobar ORDER BY name');
29 $db->query('DROP TABLE foobar');

Completed in 41 milliseconds

12345678910>>...32