Home
last modified time | relevance | path

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

12345678910>>...35

/php-src/ext/dba/tests/
H A Ddba_array_keys_inifile.phpt13 $name = __DIR__ . '/array_keys_basic.db';
15 $db = dba_open($name, 'c', 'inifile');
18 var_dump(dba_insert(['group', ''], 'Empty name', $db));
19 var_dump(dba_insert(['', 'name'], 'Empty group', $db));
20 var_dump(dba_insert(['', ''], 'Empty keys', $db));
21 var_dump(dba_fetch(['group', 'name'], $db));
22 var_dump(dba_fetch(['group', ''], $db));
23 var_dump(dba_fetch(['', 'name'], $db));
24 var_dump(dba_fetch(['', ''], $db));
25 dba_close($db);
[all …]
H A Ddba_array_keys.phpt13 $name = 'array_keys_basic.db';
15 $db = get_any_db($name);
18 var_dump(dba_insert(['group', ''], 'Empty name', $db));
19 var_dump(dba_insert(['', 'name'], 'Empty group', $db));
20 var_dump(dba_insert(['', ''], 'Empty keys', $db));
21 var_dump(dba_fetch(['group', 'name'], $db));
22 var_dump(dba_fetch(['group', ''], $db));
23 var_dump(dba_fetch(['', 'name'], $db));
24 var_dump(dba_fetch(['', ''], $db));
25 dba_close($db);
[all …]
/php-src/ext/pdo_mysql/tests/
H A Dpdo_mysql_exec.phpt14 $ret = $db->exec($sql);
18 $db->errorCode(), implode(' ', $db->errorInfo()));
23 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
31 $db = MySQLPDOTest::factory();
52 printf("[016] [%s] %s\n", $db->errorCode(), implode(' ', $db->errorInfo()));
62 $db->errorCode(), implode(' ', $db->errorInfo()));
104 $db->errorCode(), implode(' ', $db->errorInfo()));
142 $db->errorCode(), implode(' ', $db->errorInfo()));
156 $db->errorCode(), var_export($db->errorInfo(), true));
164 $db->errorCode(), implode(' ', $db->errorInfo()));
[all …]
H A Dpdo_mysql_commit.phpt13 $db = MySQLPDOTest::factory();
16 … MySQLPDOTest::createTestTable($table, $db, MySQLPDOTest::detect_transactional_mysql_engine($db));
25 …$db->exec(sprintf('CREATE TABLE %s (id INT) ENGINE=%s', $table2, MySQLPDOTest::detect_transactiona…
27 $db->commit();
47 if (true !== ($tmp = $db->commit()))
49 $db->errorCode(), implode(' ', $db->errorInfo()));
61 $db = MySQLPDOTest::factory();
68 if (true !== ($tmp = $db->commit()))
70 $db->errorCode(), implode(' ', $db->errorInfo()));
83 $db->errorCode(), implode(' ', $db->errorInfo()));
[all …]
H A Dpdo_mysql_attr_case.phpt13 $db = MySQLPDOTest::factory();
34 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
40 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
48 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
52 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
56 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
62 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
70 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
76 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
84 var_export($db->errorInfo(), true), var_export($db->errorCode(), true));
[all …]
H A Dpdo_mysql_attr_autocommit.phpt13 $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))
57 … MySQLPDOTest::createTestTable($table, $db, MySQLPDOTest::detect_transactional_mysql_engine($db));
68 $db->query('ROLLBACK');
73 if (!$db->setAttribute(PDO::ATTR_AUTOCOMMIT, 0))
77 $db->query('ROLLBACK');
83 $db->query('COMMIT');
[all …]
H A Dpdo_mysql_types_zerofill.phpt16 $db->exec('DROP TABLE IF EXISTS test_mysql_types_zerofill');
18 $db->exec($sql);
19 if ($db->errorCode() != 0) {
38 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
78 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
90 $db = MySQLPDOTest::factory();
92 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
93 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
95 $stmt = $db->prepare('SELECT @@sql_mode AS _mode');
125 $db = MySQLPDOTest::factory();
[all …]
H A Dbug_44454.phpt13 $db = MySQLPDOTest::factory();
15 function bug_44454($db) {
17 $db->exec('DROP TABLE IF EXISTS test_44454');
33 $db->exec('DROP TABLE IF EXISTS test_44454');
41 $stmt = $db->query('SELECT a, b FROM test_44454');
57 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
58 bug_44454($db);
61 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
62 bug_44454($db);
69 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_stmt_columncount.phpt13 $db = MySQLPDOTest::factory();
16 MySQLPDOTest::createTestTable($table, $db);
23 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
24 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
31 $stmt = $db->query("SELECT * FROM {$table}");
36 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
41 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
49 $stmt = $db->query("SELECT * FROM {$table}");
54 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
62 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_prepare_emulated_anonymous_placeholders.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();
78 $db->errorCode(), implode(' ', $db->errorInfo()));
86 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
87 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
91 prepex(3, $db, '', [], ['execute' => ['sqlstate' => '42000']]);
152 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
[all …]
H A Dpdo_mysql_stmt_errorinfo.phpt13 $db = MySQLPDOTest::factory();
16 MySQLPDOTest::createTestTable($table , $db);
29 MySQLPDOTest::createTestTable($table, $db);
31 $db->exec("DROP TABLE {$table}");
34 var_dump($db->errorInfo());
38 $e->getMessage(), $db->errorInfo(), implode(' ', $db->errorInfo()));
50 MySQLPDOTest::createTestTable($table, $db);
53 $db->exec("DROP TABLE {$table}");
56 var_dump($db->errorInfo());
60 $e->getMessage(), $db->errorInfo(), implode(' ', $db->errorInfo()));
[all …]
/php-src/ext/pdo_pgsql/tests/
H A Dgh9411.phpt15 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
19 $db->beginTransaction();
20 $oid = $db->pgsqlLOBCreate();
21 var_dump($lob = $db->pgsqlLOBOpen($oid, 'wb'));
23 $db->rollback();
26 $db->beginTransaction();
27 $oid = $db->pgsqlLOBCreate();
28 var_dump($lob = $db->pgsqlLOBOpen($oid, 'wb'));
30 $db->commit();
33 $db->beginTransaction();
[all …]
H A Dbug68199.phpt12 $db = PDOTest::factory();
25 $pid = $db->pgsqlGetPid();
29 var_dump($db->pgsqlGetNotify());
32 $db->exec("LISTEN channel_bug68199");
33 var_dump($db->pgsqlGetNotify());
37 $db->exec("NOTIFY channel_bug68199, 'payload'");
38 $notify = $db->pgsqlGetNotify();
46 $db->exec("NOTIFY channel_bug68199, 'payload'");
47 $notify = $db->pgsqlGetNotify();
55 $notify = $db->pgsqlGetNotify(PDO::FETCH_NUM);
[all …]
H A Dgetnotify.phpt19 $pid = $db->pgsqlGetPid();
23 var_dump($db->pgsqlGetNotify());
26 $db->exec("LISTEN channel_getnotify");
27 var_dump($db->pgsqlGetNotify());
31 $db->exec("NOTIFY channel_getnotify");
32 $notify = $db->pgsqlGetNotify();
39 $db->exec("NOTIFY channel_getnotify");
40 $notify = $db->pgsqlGetNotify();
46 $db->exec("NOTIFY channel_getnotify");
53 $db->exec("NOTIFY channel_getnotify");
[all …]
H A Dis_in_transaction.phpt15 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
17 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
21 $db->beginTransaction();
24 var_dump($db->inTransaction());
31 $db->commit();
34 var_dump($db->inTransaction());
36 $db->beginTransaction();
46 var_dump($db->inTransaction());
47 $db->rollBack();
51 var_dump($db->inTransaction());
[all …]
/php-src/ext/pgsql/tests/
H A Dgh13354.phpt11 $db = pg_connect($conn_str);
18 pg_prepare($db, 'test', $query);
44 pg_consume_input($db);
45 $res = pg_get_result($db);
50 pg_consume_input($db);
51 $res = pg_get_result($db);
58 pg_consume_input($db);
59 $res = pg_get_result($db);
64 pg_consume_input($db);
65 $res = pg_get_result($db);
[all …]
H A D9999dropdb.phpt2 PostgreSQL drop db
16 $db = pg_connect($conn_str);
17 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
19 pg_query($db, "CREATE VIEW {$view_name} as SELECT * FROM {$table_name}");
21 pg_query($db, "DROP VIEW {$view_name}");
22 pg_query($db, "DROP TABLE {$table_name}");
23 pg_query($db, "DROP TABLE {$table_name_92}");
35 $db = pg_connect($conn_str);
36 pg_query($db, "DROP VIEW IF EXISTS {$view_name}");
37 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
[all …]
H A D06copy_2.phpt13 $db = pg_connect($conn_str);
15 pg_query($db, "CREATE TABLE {$table_name} (x int)");
17 pg_query($db, "COPY {$table_name} FROM STDIN");
19 pg_put_line($db, "1\n");
20 pg_put_line($db, "\\N\n");
21 pg_put_line($db, "\\.\n");
22 pg_end_copy($db);
24 var_dump(pg_fetch_all_columns(pg_query($db, "SELECT * FROM {$table_name} ORDER BY 1")));
31 $db = pg_connect($conn_str);
32 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
H A D05large_object.phpt12 $db = pg_connect($conn_str);
15 pg_exec ($db, "BEGIN");
16 $oid = pg_lo_create ($db);
22 pg_exec ($db, "COMMIT");
25 pg_exec ($db, "BEGIN");
37 pg_exec ($db, "COMMIT");
40 pg_exec ($db, "BEGIN");
51 pg_exec ($db, "BEGIN");
57 pg_exec ($db, "BEGIN");
63 pg_exec ($db, "BEGIN");
[all …]
H A D32nb_async_query.phpt17 $db = pg_connect($conn_str);
21 $db_socket = pg_socket($db);
28 nb_flush($db, $db_socket);
31 nb_consume($db, $db_socket);
33 if (!($result = pg_get_result($db))) {
66 nb_flush($db, $db_socket);
69 nb_consume($db, $db_socket);
71 if (!($result = pg_get_result($db))) {
77 pg_close($db);
86 $db = pg_connect($conn_str);
[all …]
H A D01createdb.phpt2 PostgreSQL create db
16 $db = pg_connect($conn_str);
17 if (!($q = @pg_query($db, "SELECT * FROM ".$table_name)) || !@pg_num_rows($q))
19 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); // Create table here
25 $v = pg_version($db);
28 pg_query($db, "CREATE TABLE {$table_name_92} (textary text[], jsn json)"); // Create table here
35 pg_query($db, "CREATE VIEW {$view_name} AS SELECT * FROM {$table_name}");
37 pg_close($db);
47 $db = pg_connect($conn_str);
48 pg_query($db, "DROP TABLE IF EXISTS {$table_name} cascade");
[all …]
H A D09notice.phpt21 $db = pg_connect($conn_str);
23 _set_lc_messages($db);
29 var_dump(pg_last_notice($db));
30 var_dump(pg_last_notice($db, PGSQL_NOTICE_ALL));
32 pg_query($db, "BEGIN;");
33 pg_query($db, "BEGIN;");
34 pg_query($db, "BEGIN;");
35 pg_query($db, "BEGIN;");
38 var_dump(pg_last_notice($db));
39 var_dump(pg_last_notice($db, PGSQL_NOTICE_ALL));
[all …]
/php-src/ext/pdo/tests/
H A Dbug_64172.phpt17 $db = PDOTest::factory();
19 $db->exec("CREATE TABLE test64172 (x int)");
20 $db->exec("INSERT INTO test64172 VALUES (1)");
23 $db->query('SELECT * FROM bad_table');
27 var_dump(is_int($db->errorInfo()[1])) . "\n";
30 $stmt = $db->query('SELECT * FROM test64172');
33 var_dump($db->errorInfo());
36 $db->exec("INSERT INTO bad_table VALUES(1)");
40 var_dump(is_int($db->errorInfo()[1])) . "\n";
44 var_dump($db->errorInfo());
[all …]
/php-src/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_transaction.phpt8 $db = new PDO('sqlite::memory:');
9 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
11 $db->beginTransaction();
13 $db->query('CREATE TABLE test_pdo_sqlite_transaction (id INT AUTO INCREMENT, name TEXT)');
14 $db->commit();
16 $db->beginTransaction();
17 $db->query('INSERT INTO test_pdo_sqlite_transaction VALUES (NULL, "PHP"), (NULL, "PHP6")');
18 $db->rollback();
20 $r = $db->query('SELECT COUNT(*) FROM test_pdo_sqlite_transaction');
23 $db->query('DROP TABLE test_pdo_sqlite_transaction');
/php-src/ext/mysqli/tests/
H A Dbug66043.phpt12 if (!$db = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
16 if (!$db->query("DROP TABLE IF EXISTS test")) {
17 printf("[002] [%d] %s\n", mysqli_errno($db), mysqli_error($db));
21 if (!$db->query("CREATE TABLE test(str TEXT)")) {
22 printf("[003] [%d] %s\n", mysqli_errno($db), mysqli_error($db));
26 if (!$db->query("INSERT INTO test(str) VALUES ('Test')")) {
31 $stmt = $db->stmt_init();
33 printf("[004] [%d] %s\n", mysqli_errno($db), mysqli_error($db));

Completed in 109 milliseconds

12345678910>>...35