Home
last modified time | relevance | path

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

12345678910>>...35

/php-src/ext/pdo_sqlite/tests/subclasses/
H A Dpdosqlite_002.phpt8 $db = Pdo::connect('sqlite::memory:');
9 if (!$db instanceof PdoSqlite) {
10 echo "Wrong class type. Should be PdoSqlite 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, PdoSqlite::DETERMINISTIC…
19 foreach ($db->query('SELECT testing(name) FROM pdosqlite_002') as $row) {
/php-src/ext/pdo_dblib/tests/
H A Dpdodblib_002.phpt15 $db = connectToDb();
16 if (!$db instanceof PdoDblib) {
17 echo "Wrong class type. Should be PdoDblib but is " . get_class($db) . "\n";
20 $db->query("CREATE TABLE #pdo_dblib_002(name VARCHAR(32))");
21 $db->query("INSERT INTO #pdo_dblib_002 VALUES('PHP'), ('PHP6')");
23 foreach ($db->query('SELECT name FROM #pdo_dblib_002') as $row) {
32 $db = getDbConnection();
33 $db->query('DROP TABLE IF EXISTS #pdo_dblib_002');
/php-src/ext/pdo_mysql/tests/
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_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_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_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 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 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_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 …]
H A Dpdo_mysql_stmt_errorcode.phpt13 $db = MySQLPDOTest::factory();
15 $db->exec('DROP TABLE IF EXISTS pdo_mysql_stmt_errorcode_ihopeitdoesnotexist');
19 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
20 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
23 …$stmt = $db->prepare('SELECT id FROM pdo_mysql_stmt_errorcode_ihopeitdoesnotexist ORDER BY id ASC'…
30 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
35 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
36 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
39 …$stmt = $db->prepare('SELECT id FROM pdo_mysql_stmt_errorcode_ihopeitdoesnotexist ORDER BY id ASC'…
45 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
H A Dpdomysql_002.phpt15 $db = Pdo::connect(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS);
16 if (!$db instanceof PdoMysql) {
17 echo "Wrong class type. Should be PdoMysql but is " . get_class($db) . "\n";
20 $db->exec('CREATE TABLE pdomysql_002(id INT NOT NULL PRIMARY KEY, name VARCHAR(10))');
21 $db->exec("INSERT INTO pdomysql_002 VALUES(1, 'A'), (2, 'B'), (3, 'C')");
23 foreach ($db->query('SELECT name FROM pdomysql_002') as $row) {
32 $db = MySQLPDOTest::factory();
33 $db->query('DROP TABLE pdomysql_002');
/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 …]
H A Dpdo_002.phpt16 $db = PDOTest::factory();
18 $db->exec('CREATE TABLE test002(id int NOT NULL PRIMARY KEY, val VARCHAR(10))');
19 $db->exec("INSERT INTO test002 VALUES(1, 'A')");
20 $db->exec("INSERT INTO test002 VALUES(2, 'B')");
21 $db->exec("INSERT INTO test002 VALUES(3, 'C')");
23 $stmt = $db->prepare('SELECT * from test002');
31 $db = PDOTest::factory();
32 PDOTest::dropTableIfExists($db, "test002");
/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 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}");
H A D04async_query.phpt13 $db = pg_connect($conn_str);
14 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
15 pg_query($db, "INSERT INTO {$table_name} DEFAULT VALUES");
17 if (!pg_send_query($db, "SELECT * FROM ".$table_name.";")) {
20 while(pg_connection_busy($db)); // busy wait: intended
21 if (pg_connection_status($db) === PGSQL_CONNECTION_BAD) {
24 if (!($result = pg_get_result($db)))
49 pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";"));
50 pg_num_fields(pg_query($db, "SELECT * FROM ".$table_name.";"));
74 $db = pg_connect($conn_str);
[all …]
/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 …]
/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';
/php-src/ext/pdo_pgsql/tests/
H A Dbug72633.phpt17 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
19 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
21 $db->query('CREATE TABLE test72633 (id SERIAL NOT NULL, field1 VARCHAR(10))');
23 $stmt = $db->prepare("INSERT INTO test72633 (field1) VALUES ('test')");
30 var_dump($db->lastInsertId());
34 var_dump($db->lastInsertId('test72633_id_seq'));
40 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
41 $db->query('DROP TABLE IF EXISTS test72633');

Completed in 23 milliseconds

12345678910>>...35