Home
last modified time | relevance | path

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

12345678910>>...31

/PHP-7.1/ext/pdo_mysql/tests/
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_stmt_nextrowset.phpt10 $db = MySQLPDOTest::factory();
40 function test_proc1($db) {
75 test_proc1($db);
76 test_proc2($db);
82 test_proc1($db);
83 test_proc2($db);
91 test_proc1($db);
92 test_proc2($db);
99 test_proc1($db);
100 test_proc2($db);
[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));
30 if (!$db->setAttribute($attribute, $value)) {
42 $tmp = $db->getAttribute($attribute);
52 $db->errorCode(), implode(' ', $db->errorInfo()));
59 set_and_get(1, $db, PDO::ATTR_AUTOCOMMIT, 1);
61 set_and_get(2, $db, PDO::ATTR_AUTOCOMMIT, 0);
62 set_and_get(3, $db, PDO::ATTR_AUTOCOMMIT, -1);
64 set_and_get(4, $db, PDO::ATTR_AUTOCOMMIT, $obj);
[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 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_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 …]
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_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_variable_columncount.phpt10 $db = MySQLPDOTest::factory();
25 $db = MySQLPDOTest::factory();
59 $stmt = $db->prepare('CALL p(?)');
72 $db = MySQLPDOTest::factory();
90 $db->exec('SET @numcols = 1');
91 $stmt = $db->prepare('CALL p()');
96 $db->exec('SET @numcols = 1');
103 $db = MySQLPDOTest::factory();
106 $db->exec('SET @numcols = 1');
112 $db->exec('SET @numcols = 1');
[all …]
H A Dpdo_mysql_exec_select.phpt11 function exec_and_count($offset, &$db, $sql, $exp) {
15 $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));
39 exec_and_count(2, $db, 'DROP TABLE IF EXISTS test', 0);
45 exec_and_count(5, $db, 'SELECT id FROM test', 0);
51 $db->errorCode(), implode(' ', $db->errorInfo()));
59 $db = MySQLPDOTest::factory();
[all …]
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_attr_multi_statements.phpt8 $db = MySQLPDOTest::factory();
21 $db = new PDO($dsn, $user, $pass);
22 $db->exec(sprintf('DROP TABLE IF EXISTS %s', $table));
24 $db->exec($create);
28 $info = $db->errorInfo();
30 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
33 $stmt = $db->query('SELECT 1 AS value;');
40 $info = $db->errorInfo();
43 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
46 $stmt = $db->query('SELECT 1 AS value;');
[all …]
/PHP-7.1/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 Dcopy_from.phpt40 $db->beginTransaction();
47 $db->rollback();
50 $db->beginTransaction();
56 $db->rollback();
65 $db->rollback();
74 $db->rollback();
84 $db->rollback();
93 $db->rollback();
102 $db->rollback();
111 $db->rollback();
[all …]
/PHP-7.1/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 D09notice.phpt20 $db = pg_connect($conn_str);
28 var_dump(pg_last_notice($db));
29 var_dump(pg_last_notice($db, PGSQL_NOTICE_ALL));
31 pg_query($db, "BEGIN;");
32 pg_query($db, "BEGIN;");
33 pg_query($db, "BEGIN;");
34 pg_query($db, "BEGIN;");
37 var_dump(pg_last_notice($db));
38 var_dump(pg_last_notice($db, PGSQL_NOTICE_ALL));
43 var_dump(pg_last_notice($db, PGSQL_NOTICE_ALL));
[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 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");
H A D30nb_async_query_params.phpt14 $db = pg_connect($conn_str);
16 $version = pg_version($db);
22 $db_socket = pg_socket($db);
25 $sent = pg_send_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100));
29 nb_flush($db, $db_socket);
32 nb_consume($db, $db_socket);
34 if (!($result = pg_get_result($db))) {
53 pg_num_rows(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)));
54 pg_num_fields(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)));
67 nb_flush($db, $db_socket);
[all …]
/PHP-7.1/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 …]
/PHP-7.1/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');
H A Dpdo_sqlite_lastinsertid.phpt8 $db = new pdo('sqlite::memory:');
9 $db->query('CREATE TABLE IF NOT EXISTS foo (id INT AUTO INCREMENT, name TEXT)');
10 $db->query('INSERT INTO foo VALUES (NULL, "PHP")');
11 $db->query('INSERT INTO foo VALUES (NULL, "PHP6")');
12 var_dump($db->query('SELECT * FROM foo'));
13 var_dump($db->errorInfo());
14 var_dump($db->lastInsertId());
16 $db->query('DROP TABLE foo');
/PHP-7.1/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);

Completed in 99 milliseconds

12345678910>>...31