Home
last modified time | relevance | path

Searched refs:db (Results 101 – 125 of 868) sorted by relevance

12345678910>>...35

/php-src/ext/pdo_dblib/tests/
H A Dconfig.inc7 function driver_supports_batch_statements_without_select($db) {
8 $version = $db->getAttribute(PDO::DBLIB_ATTR_VERSION);
38 function setAttributes(PDO $db) {
39 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
40 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
47 $db = new $class($dsn, $user, $pass, $attributes);
49 setAttributes($db);
55 return $db;
62 $db = PDO::connect($dsn, $user, $pass);
63 setAttributes($db);
[all …]
H A Dtimeout.phpt15 $db = getDbConnection();
20 $db = getDbConnection();
21 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
22 $db->setAttribute(PDO::ATTR_TIMEOUT, 1);
23 $stmt = $db->prepare($sql);
34 $db = getDbConnection();
35 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
36 $db->setAttribute(PDO::DBLIB_ATTR_QUERY_TIMEOUT, 1);
37 $stmt = $db->prepare($sql);
49 $stmt = $db->prepare($sql);
[all …]
/php-src/ext/pdo_mysql/tests/
H A Dpdo_mysql_local_infile_directory_allowed.phpt16 function exec_and_count($offset, &$db, $sql, $exp) {
18 $ret = $db->exec($sql);
22 $db->errorCode(), implode(' ', $db->errorInfo()));
27 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
35 $db = MySQLPDOTest::factoryWithAttr([
41 …exec_and_count(2, $db, sprintf('CREATE TABLE test_local_inifile_dir_allowed(id INT NOT NULL PRIMAR…
46 if (exec_and_count(3, $db, $sql, 3)) {
47 $stmt = $db->query('SELECT id, col1 FROM test_local_inifile_dir_allowed ORDER BY id ASC');
71 $db->errorCode(), implode(' ', $db->errorInfo()));
79 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_local_infile_overrides_local_infile_directory.phpt16 function exec_and_count($offset, &$db, $sql, $exp) {
18 $ret = $db->exec($sql);
22 $db->errorCode(), implode(' ', $db->errorInfo()));
27 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
35 $db = MySQLPDOTest::factoryWithAttr([
41 …exec_and_count(2, $db, sprintf('CREATE TABLE test_local_inifile_overrides(id INT NOT NULL PRIMARY …
46 if (exec_and_count(3, $db, $sql, 3)) {
47 $stmt = $db->query('SELECT id, col1 FROM test_local_inifile_overrides ORDER BY id ASC');
71 $db->errorCode(), implode(' ', $db->errorInfo()));
79 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_exec_load_data.phpt11 $db = MySQLPDOTest::factory();
12 $stmt = $db->query('SELECT USER() as _user');
20 $stmt = $db->query("SHOW VARIABLES LIKE 'secure_file_priv'");
33 function exec_and_count($offset, &$db, $sql, $exp) {
35 $ret = $db->exec($sql);
39 $db->errorCode(), implode(' ', $db->errorInfo()));
43 if (42000 == $db->errorCode()) {
50 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
64 $stmt = $db->query("SHOW VARIABLES LIKE 'secure_file_priv'");
78 if (exec_and_count(4, $db, $sql, 2)) {
[all …]
H A Dpdo_mysql_prepare_native_placeholder_everywhere.phpt13 $db = MySQLPDOTest::factory();
14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
17 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
18 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
22 …$db->exec("INSERT INTO test_prepare_native_named_placeholder_everywhere(id, label) VALUES (1, 'row…
24 …$stmt = $db->prepare('SELECT ?, id, label FROM test_prepare_native_named_placeholder_everywhere WH…
34 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
35 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
49 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
57 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_prepare_match_against.phpt13 $db = MySQLPDOTest::factory();
16 $db->exec('CREATE TABLE test_prepare_match_against(id INT, label CHAR(255)) ENGINE=MyISAM');
17 $db->exec('CREATE FULLTEXT INDEX idx1 ON test_prepare_match_against(label)');
19 …$stmt = $db->prepare('SELECT id, label FROM test_prepare_match_against WHERE MATCH label AGAINST (…
23 …$stmt = $db->prepare('SELECT id, label FROM test_prepare_match_against WHERE MATCH label AGAINST (…
27 …$stmt = $db->prepare('SELECT id, label FROM test_prepare_match_against WHERE MATCH label AGAINST (…
32 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
40 $db = MySQLPDOTest::factory();
41 $db->exec('DROP TABLE IF EXISTS test_prepare_match_against');
H A Dpecl_bug_5780.phpt13 $db = MySQLPDOTest::factory();
15 $db->exec("CREATE TABLE test_pecl_bug_5780 (login varchar(32) NOT NULL, data varchar(64) NOT NULL)"…
16 $db->exec("CREATE TABLE test_pecl_bug_5780_2 (login varchar(32) NOT NULL, password varchar(64) NOT …
17 $db->exec("INSERT INTO test_pecl_bug_5780_2 (login, password) VALUES ('testing', 'testing')");
18 $db->exec("INSERT INTO test_pecl_bug_5780_2 (login, password) VALUES ('test2', 'testpw2')");
20 $logstmt = $db->prepare('INSERT INTO test_pecl_bug_5780 (login, data) VALUES (:var1, :var2)');
21 $authstmt = $db->prepare('SELECT * FROM test_pecl_bug_5780_2 WHERE login = :varlog AND password = :…
32 $db = MySQLPDOTest::factory();
33 $db->exec('DROP TABLE IF EXISTS test_pecl_bug_5780');
34 $db->exec('DROP TABLE IF EXISTS test_pecl_bug_5780_2');
H A Dpdo_mysql_prepare_native_myisam_index.phpt13 $db = MySQLPDOTest::factory();
18 $stmt = @$db->prepare($query);
20 $stmt = $db->prepare($query);
23 $tmp = $db->errorInfo();
86 $db->errorCode(), implode(' ', $db->errorInfo()));
148 $db->quote('%ro%'));
149 $stmt = prepex(13, $db, $sql, array(-1));
154 $db->quote('%ro%'));
155 $stmt = prepex(14, $db, $sql, array(1));
166 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
[all …]
H A Dpdo_mysql_param_str_natl.phpt13 $db = MySQLPDOTest::factory();
15 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
17 $db->exec('CREATE TABLE test_param_str_natl (bar NCHAR(4) NOT NULL)');
19 $stmt = $db->prepare('INSERT INTO test_param_str_natl VALUES(?)');
23 var_dump($db->query('SELECT * from test_param_str_natl'));
24 foreach ($db->query('SELECT * from test_param_str_natl') AS $row) {
31 $db = MySQLPDOTest::factory();
32 $db->exec('DROP TABLE IF EXISTS test_param_str_natl');
H A Dpdo_mysql_stmt_rowcount.phpt13 $db = MySQLPDOTest::factory();
16 MySQLPDOTest::createTestTable($table, $db);
20 if (0 !== ($tmp = $db->query("SELECT id FROM {$table} WHERE 1 = 0")->rowCount()))
23 if (1 !== ($tmp = $db->query("SELECT id FROM {$table} WHERE id = 1")->rowCount()))
28 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
36 $db = MySQLPDOTest::factory();
37 $db->exec('DROP TABLE IF EXISTS pdo_mysql_stmt_rowcount');
H A Dpdo_mysql_prepare_native_dup_named_placeholder.phpt13 $db = MySQLPDOTest::factory();
14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
19 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
20 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
39 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
61 $db->exec('DELETE FROM test_prepare_native_dup_named');
66 $stmt = $db->prepare($sql);
75 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
80 $stmt = $db->prepare($sql);
89 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
[all …]
H A Dchange_column_count.phpt14 $db = MySQLPDOTest::factory();
15 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
16 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
18 $db->exec('CREATE TABLE test_change_column_count (id INTEGER PRIMARY KEY NOT NULL, name VARCHAR(255…
20 $stmt = $db->prepare('INSERT INTO test_change_column_count (id, name) VALUES(:id, :name)');
26 $stmt = $db->prepare('SELECT * FROM test_change_column_count WHERE id = :id');
30 $db->exec('ALTER TABLE test_change_column_count ADD new_col VARCHAR(255)');
37 $db = MySQLPDOTest::factory();
38 $db->exec('DROP TABLE IF EXISTS test_change_column_count');
H A Dpdo_mysql_attr_statement_class.phpt13 $db = MySQLPDOTest::factory();
14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
18 MySQLPDOTest::createTestTable($table, $db);
20 $default = $db->getAttribute(PDO::ATTR_STATEMENT_CLASS);
24 $db->setAttribute(PDO::ATTR_STATEMENT_CLASS, 'foo');
29 $db->setAttribute(PDO::ATTR_STATEMENT_CLASS, ['classname']);
35 $db->setAttribute(PDO::ATTR_STATEMENT_CLASS, ['classname', []]);
48 $db->setAttribute(PDO::ATTR_STATEMENT_CLASS, ['myclass', []]);
98 var_dump($db->getAttribute(PDO::ATTR_STATEMENT_CLASS));
131 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_attr_oracle_nulls.phpt13 $db = MySQLPDOTest::factory();
18 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, []);
23 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, new stdClass());
28 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 'pdo');
33 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 1);
37 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 0);
41 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 1);
42 $stmt = $db->query('SELECT VERSION() as _version');
49 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
55 $stmt = $db->prepare("CALL {$procedure}()");
[all …]
/php-src/ext/pdo/tests/
H A Dbug_34630.phpt16 $db = PDOTest::factory();
18 $driver = $db->getAttribute(PDO::ATTR_DRIVER_NAME);
22 $db->exec('CREATE TABLE test34630 (id int NOT NULL PRIMARY KEY, val BLOB)');
24 $db->exec('CREATE TABLE test34630 (id int NOT NULL PRIMARY KEY, val VARCHAR(256))');
26 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
36 $db->beginTransaction();
39 $insert = $db->prepare("insert into test34630 (id, val) values (1, :blob)");
45 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
46 var_dump($db->query("SELECT * from test34630")->fetchAll(PDO::FETCH_ASSOC));
52 $db = PDOTest::factory();
[all …]
/php-src/ext/pgsql/tests/
H A D10pg_convert_9.phpt17 $db = pg_connect($conn_str);
18 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
20 pg_query($db, "SET standard_conforming_strings = 0");
23 $converted = pg_convert($db, $table_name, $fields);
29 $converted = pg_convert($db, $table_name, [5 => 'AAA']);
34 $converted = pg_convert($db, $table_name, ['AAA']);
39 $converted = pg_convert($db, $table_name, ['num' => []]);
44 $converted = pg_convert($db, $table_name, ['num' => new stdClass()]);
49 $converted = pg_convert($db, $table_name, ['num' => $db]);
60 $db = pg_connect($conn_str);
[all …]
H A D23sync_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 $result = pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100));
42 pg_num_rows(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)));
43 pg_num_fields(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)));
51 $result = pg_query_params($db, "INSERT INTO ".$table_name." VALUES (\$1, \$2);", array(9999, "A'BC"…
55 pg_close($db);
64 $db = pg_connect($conn_str);
65 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
H A D18pg_escape_bytea_hex.phpt17 $db = pg_connect($conn_str);
18 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
20 @pg_query($db, "SET bytea_output = 'hex'");
23 $esc_image = pg_escape_bytea($db, $image);
25 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');');
26 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
42 $db = pg_connect($conn_str);
43 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
H A D18pg_escape_bytea_esc.phpt14 $db = pg_connect($conn_str);
15 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
17 @pg_query($db, "SET bytea_output = 'escape'");
20 $esc_image = pg_escape_bytea($db, $image);
22 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');');
23 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
39 $db = pg_connect($conn_str);
40 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
/php-src/ext/pdo_sqlite/tests/subclasses/
H A Dpdosqlite_002.phpt8 $db = Pdo::connect('sqlite::memory:');
9 if (!$db instanceof Pdo\Sqlite) {
10 echo "Wrong class type. Should be Pdo\Sqlite but is " . get_class($db) . "\n";
13 $db->query('CREATE TABLE pdosqlite_002 (id INT AUTO INCREMENT, name TEXT)');
14 $db->query('INSERT INTO pdosqlite_002 VALUES (NULL, "PHP")');
15 $db->query('INSERT INTO pdosqlite_002 VALUES (NULL, "PHP6")');
17 $db->createFunction('testing', function($v) { return strtolower($v); }, 1, Pdo\Sqlite::DETERMINISTI…
19 foreach ($db->query('SELECT testing(name) FROM pdosqlite_002') as $row) {
/php-src/ext/sqlite3/tests/
H A Dsqlite3_40_setauthorizer.phpt8 $db = new SQLite3(':memory:');
9 $db->enableExceptions(true);
11 $db->setAuthorizer(function (int $action) {
20 var_dump($db->querySingle('SELECT 1;'));
30 $db->setAuthorizer(null);
37 $db->setAuthorizer(function (int $action) {
46 var_dump($db->exec('DROP TABLE test;'));
49 $db->setAuthorizer(function () {
54 var_dump($db->querySingle('SELECT 1;'));
60 $db->setAuthorizer(function () {
[all …]
H A Dsqlite3_29_createfunction.phpt11 var_dump($db->createfunction($func, $func));
12 var_dump($db->querySingle('SELECT strtoupper("test")'));
15 var_dump($db->createfunction($func2, $func2));
16 var_dump($db->querySingle('SELECT strtolower("TEST")'));
18 var_dump($db->createfunction($func, $func2));
19 var_dump($db->querySingle('SELECT strtoupper("tEst")'));
/php-src/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_lastinsertid.phpt8 $db = new PDO('sqlite::memory:');
9 $db->query('CREATE TABLE test_pdo_sqlite_lastinsertid (id INT AUTO INCREMENT, name TEXT)');
10 $db->query('INSERT INTO test_pdo_sqlite_lastinsertid VALUES (NULL, "PHP"), (NULL, "PHP6")');
11 var_dump($db->query('SELECT * FROM test_pdo_sqlite_lastinsertid'));
12 var_dump($db->errorInfo());
13 var_dump($db->lastInsertId());
/php-src/ext/dba/tests/
H A Ddba_fetch_legacy_signature.phpt13 $name = 'legacy_fetch_signature.db';
15 $db = get_any_db($name);
17 dba_insert("key1", "This is a test insert", $db);
18 echo dba_fetch("key1", 0, $db), \PHP_EOL, dba_fetch("key1", $db, 0), \PHP_EOL;
25 dba_fetch("key1", 0, $db);
29 dba_close($db);
35 $db_name = 'legacy_fetch_signature.db';

Completed in 40 milliseconds

12345678910>>...35