Home
last modified time | relevance | path

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

12345678910>>...35

/php-src/ext/pgsql/tests/
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 …]
H A D30nb_async_query_params.phpt16 $db = pg_connect($conn_str);
17 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
18 pg_query($db, "INSERT INTO {$table_name} (num) VALUES(1000)");
20 $db_socket = pg_socket($db);
27 nb_flush($db, $db_socket);
30 nb_consume($db, $db_socket);
32 if (!($result = pg_get_result($db))) {
65 nb_flush($db, $db_socket);
71 pg_close($db);
80 $db = pg_connect($conn_str);
[all …]
H A Dbug77047.phpt16 $db = pg_connect($conn_str);
18 pg_query($db, "CREATE TABLE {$table_name} (
23 pg_insert($db, $table_name, array("t" => "13:31"));
27 pg_insert($db, $table_name, array("t" => "13:31:13"));
28 pg_insert($db, $table_name, array("t" => "1:2:3"));
30 pg_insert($db, $table_name, array("t" => "xyz"));
34 pg_insert($db, $table_name, array("t" => NULL));
35 pg_insert($db, $table_name, array("t" => ""));
37 $res = pg_query($db, "SELECT t FROM {$table_name}");
48 $db = pg_connect($conn_str);
[all …]
H A D25async_query_params.phpt15 $db = pg_connect($conn_str);
16 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
17 pg_query($db, "INSERT INTO {$table_name} (num) VALUES(1000)");
19 if (!pg_send_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100))) {
22 while(pg_connection_busy($db)); // busy wait: intended
23 if (pg_connection_status($db) === PGSQL_CONNECTION_BAD) {
26 if (!($result = pg_get_result($db)))
50 pg_num_rows(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)));
66 pg_close($db);
75 $db = pg_connect($conn_str);
[all …]
H A Dbug37100_9.phpt16 $db = pg_connect($conn_str);
18 pg_query($db, "CREATE TABLE {$table_name} (binfield byteA) ;");
19 pg_query($db, "INSERT INTO {$table_name} VALUES (decode('0103AA000812','hex'))");
22 $data = pg_query($db, "SELECT binfield FROM {$table_name}");
29 $data = pg_query($db, $sql);
35 pg_close($db);
37 $db = pg_connect($conn_str);
38 pg_close($db);
47 $db = pg_connect($conn_str);
48 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
H A D24sync_query_prepared.phpt15 $db = pg_connect($conn_str);
16 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
17 pg_query($db, "INSERT INTO {$table_name} (num) VALUES(1000)");
19 $result = pg_prepare($db, "php_test", "SELECT * FROM ".$table_name." WHERE num > \$1;");
22 $result = pg_execute($db, "php_test", array(100));
45 pg_num_rows(pg_execute($db, "php_test", array(100)));
46 pg_num_fields(pg_execute($db, "php_test", array(100)));
57 $result = pg_execute($db, "php_test2", array(9999, "A'BC"));
61 pg_close($db);
70 $db = pg_connect($conn_str);
[all …]
/php-src/ext/pdo_mysql/tests/
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 …]
H A Dbug_39858.phpt13 $db = MySQLPDOTest::factory();
14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
16 function bug_39858($db) {
20 $db->exec("
30 $stmt = $db->prepare("CALL {$procedure}()");
36 $stmt = $db->prepare("CALL {$procedure}()");
45 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
46 bug_39858($db);
49 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
50 bug_39858($db);
[all …]
H A Dpdo_mysql_quote.phpt13 $db = MySQLPDOTest::factory();
15 var_dump($db->quote('foo', PDO::PARAM_STR));
16 var_dump($db->quote('foo', PDO::PARAM_STR | PDO::PARAM_STR_CHAR));
17 var_dump($db->quote('über', PDO::PARAM_STR | PDO::PARAM_STR_NATL));
19 var_dump($db->getAttribute(PDO::ATTR_DEFAULT_STR_PARAM) === PDO::PARAM_STR_CHAR);
20 $db->setAttribute(PDO::ATTR_DEFAULT_STR_PARAM, PDO::PARAM_STR_NATL);
21 var_dump($db->getAttribute(PDO::ATTR_DEFAULT_STR_PARAM) === PDO::PARAM_STR_NATL);
23 var_dump($db->quote('foo', PDO::PARAM_STR | PDO::PARAM_STR_CHAR));
24 var_dump($db->quote('über', PDO::PARAM_STR));
25 var_dump($db->quote('über', PDO::PARAM_STR | PDO::PARAM_STR_NATL));
H A Dnative_types.phpt15 $db = MySQLPDOTest::factory();
16 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
18 $db->exec('CREATE TABLE test_native_types (i INT, f FLOAT)');
19 $db->exec('INSERT INTO test_native_types VALUES (42, 42.5)');
21 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
22 var_dump($db->query('SELECT * FROM test_native_types')->fetchAll(PDO::FETCH_ASSOC));
24 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
25 var_dump($db->query('SELECT * FROM test_native_types')->fetchAll(PDO::FETCH_ASSOC));
30 $db = MySQLPDOTest::factory();
31 $db->exec('DROP TABLE IF EXISTS test_native_types');
H A Dpdo_mysql_attr_fetch_table_names.phpt13 $db = MySQLPDOTest::factory();
16 MySQLPDOTest::createTestTable($table, $db);
18 $db->setAttribute(PDO::ATTR_FETCH_TABLE_NAMES, true);
19 var_dump($db->getAttribute(PDO::ATTR_FETCH_TABLE_NAMES));
20 $stmt = $db->query("SELECT label FROM {$table} LIMIT 1");
24 $db->setAttribute(PDO::ATTR_FETCH_TABLE_NAMES, false);
25 var_dump($db->getAttribute(PDO::ATTR_FETCH_TABLE_NAMES));
26 $stmt = $db->query("SELECT label FROM {$table} LIMIT 1");
35 $db = MySQLPDOTest::factory();
36 $db->query('DROP TABLE IF EXISTS pdo_mysql_attr_fetch_table_names');
H A Dpdo_mysql_attr_multi_statements.phpt22 $db = new PDO($dsn, $user, $pass);
23 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
24 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
27 $db->exec($create);
31 $info = $db->errorInfo();
33 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
36 $stmt = $db->query('SELECT 1 AS value;');
42 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
45 $info = $db->errorInfo();
51 $stmt = $db->query('SELECT 1 AS value;');
[all …]
H A Dpdo_mysql_stmt_multiquery.phpt16 function mysql_stmt_multiquery_wrong_usage($db) {
37 $db = MySQLPDOTest::factory();
38 MySQLPDOTest::createTestTable($table, $db);
40 mysql_stmt_multiquery_wrong_usage($db);
41 mysql_stmt_multiquery_proper_usage($db);
44 $db = MySQLPDOTest::factory();
45 MySQLPDOTest::createTestTable($table, $db);
47 mysql_stmt_multiquery_wrong_usage($db);
48 mysql_stmt_multiquery_proper_usage($db);
52 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
[all …]
H A Dpdo_mysql_multi_stmt_nextrowset.phpt13 $db = MySQLPDOTest::factory();
14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
18 MySQLPDOTest::createTestTable($table, $db);
20 function test_proc($db) {
24 $db->exec("DROP PROCEDURE IF EXISTS {$procedure}");
26 $stmt = $db->query("CALL {$procedure}()");
47 test_proc($db);
55 test_proc($db);
64 $info = $db->errorInfo();
69 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
[all …]
H A Dbug_44707.phpt13 $db = MySQLPDOTest::factory();
14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
16 function bug_44707($db) {
31 $stmt = $db->query('SELECT * FROM test_44707');
40 $stmt = $db->query('SELECT * FROM test_44707');
48 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
49 bug_44707($db);
53 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
54 bug_44707($db);
61 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_get_attribute.phpt13 $db = MySQLPDOTest::factory();
15 function set_and_get($offset, $db, $attribute, $value) {
18 if (!$db->setAttribute($attribute, $value)) {
30 $tmp = $db->getAttribute($attribute);
39 $db->errorCode(), implode(' ', $db->errorInfo()));
46 set_and_get(1, $db, PDO::ATTR_AUTOCOMMIT, true);
48 set_and_get(2, $db, PDO::ATTR_AUTOCOMMIT, 0);
49 set_and_get(3, $db, PDO::ATTR_AUTOCOMMIT, -1);
51 set_and_get(4, $db, PDO::ATTR_AUTOCOMMIT, $obj);
53 set_and_get(5, $db, PDO::MYSQL_ATTR_LOCAL_INFILE, 1);
[all …]
H A Dpdo_mysql___construct_options.phpt22 if (!is_object($db) || ($value !== ($tmp = @$db->getAttribute($option))))
71 printf("[001] Expecting NULL got %s/%s\n", gettype($db), $db);
76 printf("[002] Expecting object got %s/%s¸\n", gettype($db), $db);
82 $db = new PDO($dsn, $user, $pass);
86 $tmp = @$db->getAttribute($option);
94 if (!is_object($db) || !$db->getAttribute(PDO::ATTR_AUTOCOMMIT))
98 if (!is_object($db) || $db->getAttribute(PDO::ATTR_AUTOCOMMIT))
113 if (!is_object($db))
122 if (!is_object($db))
165 (is_object($db)) ? $db->errorCode() : 'n/a',
[all …]
H A Dpdo_mysql_prepare_emulated.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);
96 $stmt = prepex(4, $db, 'SELECT 1 AS "one"');
153 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
161 $db = MySQLPDOTest::factory();
[all …]
H A Dpdomysql_003.phpt15 $db = Pdo::connect(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS);
16 if (!$db instanceof Pdo\Mysql) {
17 echo "Wrong class type. Should be Pdo\Mysql but is " . get_class($db) . "\n";
20 $assertWarnings = function ($db, $q, $count) {
21 $db->query($q);
22 printf("Query %s produced %d warnings\n", $q, $db->getWarningCount());
24 $assertWarnings($db, 'SELECT 1 = 1', 0);
25 $assertWarnings($db, 'SELECT 1 = "A"', 1);
/php-src/ext/pdo_odbc/tests/
H A Dautocommit.phpt18 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
19 $db->exec("CREATE TABLE {$table} (id INT, name VARCHAR(255))");
20 unset($db);
22 $db = new PDO(getenv('PDOTEST_DSN'), getenv('PDOTEST_USER'), getenv('PDOTEST_PASS'), [
26 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, 1);
27 $db->query("INSERT INTO {$table} (id, name) VALUES (1, 'test')");
28 unset($db);
30 $db = new PDO(getenv('PDOTEST_DSN'), getenv('PDOTEST_USER'), getenv('PDOTEST_PASS'));
32 $r = $db->query("SELECT * FROM {$table}");
40 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
[all …]
H A Dautocommit_change_mode.phpt19 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, true);
20 var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT));
24 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, false);
25 var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT));
29 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, false);
34 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, true);
41 $db->beginTransaction();
61 $db->rollback();
64 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, false);
67 $db->beginTransaction();
[all …]
/php-src/ext/pdo_pgsql/tests/
H A Dcopy_from.phpt42 $db->beginTransaction();
49 $db->rollback();
52 $db->beginTransaction();
58 $db->rollback();
67 $db->rollback();
76 $db->rollback();
86 $db->rollback();
95 $db->rollback();
104 $db->rollback();
113 $db->rollback();
[all …]
/php-src/ext/dba/tests/
H A Dbug36436.phpt13 $db_name = 'bug36436.db';
15 $db = set_up_db_ex('db4', $db_name, LockFlag::DbLock, persistent: true);
17 var_dump($db, dba_fetch('key1', $db));
19 var_dump(dba_firstkey($db));
20 var_dump(dba_nextkey($db));
22 dba_close($db);
28 $db_name = 'bug36436.db';
/php-src/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_filename_uri.phpt9 $db = new PDO('sqlite:file::memory:?cache=shared');
11 var_dump($db->exec('CREATE TABLE test_sqlite_filename_uri (id INT);'));
14 $db = new PDO('sqlite:file::memory:?cache=shared');
16 var_dump($db->exec('SELECT * from test_sqlite_filename_uri'));
19 $filename = "file:" . __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_filename_uri.db";
21 $db = new PDO('sqlite:' . $filename);
23 var_dump($db->exec('CREATE TABLE test_sqlite_filename_uri (id INT);'));
26 $filename = "file:" . __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_filename_uri.db?mode=ro";
28 $db = new PDO('sqlite:' . $filename);
30 var_dump($db->exec('CREATE TABLE test_sqlite_filename_uri_2 (id INT);'));
[all …]

Completed in 34 milliseconds

12345678910>>...35