Home
last modified time | relevance | path

Searched refs:db (Results 226 – 250 of 761) sorted by relevance

12345678910>>...31

/PHP-5.6/ext/pdo/tests/
H A Dpdo_013.phpt15 $db = PDOTest::factory();
17 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))');
18 $db->exec('INSERT INTO test VALUES(1, \'A\', \'Group1\')');
19 $db->exec('INSERT INTO test VALUES(2, \'B\', \'Group2\')');
23 $stmt = $db->prepare($SELECT);
42 foreach ($db->query($SELECT, PDO::FETCH_CLASS, 'Test') as $data)
49 $stmt = $db->query($SELECT, PDO::FETCH_CLASS, 'Test', array('WOW'));
H A Dbug_36798.phpt22 $db = PDOTest::factory();
24 @$db->exec("SET NAMES 'LATIN1'"); // needed for PostgreSQL
25 $db->exec("CREATE TABLE test (id INTEGER)");
26 $db->exec("INSERT INTO test (id) VALUES (1)");
28 $stmt = $db->prepare("SELECT '�' as test FROM test WHERE id = :id");
/PHP-5.6/ext/mysqli/tests/
H A Dbug64726.phpt15 $db = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
17 $result = $db->query('SELECT 1', MYSQLI_USE_RESULT);
18 $db->close();
H A Dmysqli_pconn_conn_multiple.phpt19 if (!$link = my_mysqli_connect($phost, $user, $passwd, $db, $port, $socket))
21 $phost, $user, $db, $port, $socket);
44 if (!$link = new my_mysqli($phost, $user, $passwd, $db, $port, $socket))
46 $phost, $user, $db, $port, $socket);
72 if (!$link = mysqli_connect($phost, $user, $passwd, $db, $port, $socket))
74 $phost, $user, $db, $port, $socket);
83 $host, $user, $db, $port, $socket);
106 if (!$link = new my_mysqli($host, $user, $passwd, $db, $port, $socket))
108 $host, $user, $db, $port, $socket);
134 if (!$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket))
[all …]
H A Dmysqli_change_user_oo.phpt24 if (!$mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket))
26 $host, $user, $db, $port, $socket);
40 if (false !== ($tmp = $mysqli->change_user($user . '_unknown_really', $passwd . 'non_empty', $db)))
43 if (false !== ($tmp = $mysqli->change_user($user, $passwd . '_unknown_really', $db)))
46 if (false !== ($tmp = $mysqli->change_user($user, $passwd, $db . '_unknown_really')))
50 if (!$mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket))
52 $host, $user, $db, $port, $socket);
64 if (true !== ($tmp = $mysqli->change_user($user, $passwd, $db)))
74 if ($tmp['dbname'] != $db)
75 printf("[015] Expecting database %s, got database() %s\n", $db, $tmp['dbname']);
[all …]
H A Dbug33263.phpt15 public function __construct($host, $user, $passwd, $db, $port, $socket) {
17 parent::real_connect($host, $user, $passwd, $db, $port, $socket);
21 $mysql = new test($host, $user, $passwd, $db, $port, $socket);
29 if ($database != $db)
/PHP-5.6/ext/pgsql/tests/
H A D14pg_update.phpt14 $db = pg_connect($conn_str);
18 pg_update($db, $table_name, $fields, $ids) or print "Error in test 1\n";
19 echo pg_update($db, $table_name, $fields, $ids, PGSQL_DML_STRING)."\n";
20 echo pg_update($db, $table_name, $fields, $ids, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n";
H A D07optional.phpt11 $db = pg_connect($conn_str);
12 $enc = pg_client_encoding($db);
14 pg_set_client_encoding($db, $enc);
/PHP-5.6/ext/pdo_mysql/tests/
H A Dpdo_mysql_attr_prefetch.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
14 var_dump($db->getAttribute(PDO::ATTR_PREFETCH));
15 var_dump($db->setAttribute(PDO::ATTR_PREFETCH, true));
H A Dbug_61207.phpt13 $db = MySQLPDOTest::factory();
15 $db->query('DROP TABLE IF EXISTS test');
16 $db->query('create table `test`( `id` int )');
18 $handle1 = $db->prepare('insert into test(id) values(1);
34 $handle2 = $db->prepare('select * from test where id = ?;
50 $handle3 = $db->prepare('update test set id = 2 where id = ?;
66 $handle4 = $db->prepare('insert into test(id) values(3);
83 $db->query("DROP TABLE test");
H A Dpecl_bug_5200.phpt13 $db = PDOTest::test_factory(dirname(__FILE__). '/common.phpt');
15 $db->exec("CREATE TABLE test (bar INT NOT NULL, phase enum('please_select', 'I', 'II', 'IIa', 'IIb'…
17 foreach ($db->query('DESCRIBE test phase')->fetchAll(PDO::FETCH_ASSOC) as $row) {
24 $db = MySQLPDOTest::factory();
25 $db->exec('DROP TABLE IF EXISTS test');
H A Dbug_33689.phpt14 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
16 $db->exec('CREATE TABLE test (bar INT NOT NULL)');
17 $db->exec('INSERT INTO test VALUES(1)');
19 var_dump($db->query('SELECT * from test'));
20 foreach ($db->query('SELECT * from test') as $row) {
24 $stmt = $db->prepare('SELECT * from test');
/PHP-5.6/ext/sqlite3/tests/
H A Dbug70628.phpt8 $db = new SQLite3(':memory:');
10 $db->exec("CREATE TABLE Dogs (Id INTEGER PRIMARY KEY, Breed TEXT, Name TEXT, Age INTEGER)");
12 $sth = $db->prepare("INSERT INTO Dogs (Breed, Name, Age) VALUES (:breed,:name,:age)");
26 $res = $db->query('SELECT * FROM Dogs');
33 $db->close();
H A Dsqlite3_03_insert.phpt12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
19 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
27 var_dump($db->close());
H A Dsqlite3_23_escape_string.phpt12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", '" . SQLite3::escapeString…
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
19 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
27 var_dump($db->close());
H A Dbug66550.phpt10 $db = new SQLite3(':memory:');
12 $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)');
14 $stmt = $db->prepare('SELECT bar FROM foo WHERE id=:id');
16 $db->close();
H A Dsqlite3_prepare_faultystmt.phpt10 $db = new SQLite3(':memory:');
11 $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)');
12 $db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')");
14 $stmt = $db->prepare('SELECT foo FROM bar');
H A Dsqlite3stmt_reset_params.phpt10 $db = new SQLite3(':memory:');
12 var_dump($db->exec('CREATE TABLE foobar (id INTEGER, name STRING)'));
15 var_dump($db->exec("INSERT INTO foobar (id, name) VALUES (1, 'john')"));
21 $stmt = $db->prepare($query);
33 var_dump($db->close());
H A Dsqlite3_31_changes.phpt10 $db = new SQLite3(':memory:');
11 var_dump($db);
12 var_dump($db->changes());
/PHP-5.6/ext/pdo_pgsql/tests/
H A Dbug46274_2.phpt13 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
15 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
18 @$db->query("SET bytea_output = 'escape'");
22 $db->query('CREATE TABLE test_one_blob (id SERIAL NOT NULL, blob1 BYTEA)');
24 $stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (:foo)");
50 $res = $db->query("SELECT blob1 from test_one_blob");
66 $db->query('DROP TABLE test_one_blob');
/PHP-5.6/ext/pdo_oci/tests/
H A Dbug_33707.phpt12 $db = PDOTest::test_factory('ext/pdo_oci/tests/common.phpt');
13 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
15 $rs = $db->query('select blah from a_table_that_doesnt_exist');
17 var_dump($db->errorInfo());
H A Dpdo_oci_quote1.phpt13 $db = PDOTest::factory();
15 @$db->exec("drop table poq_tab");
16 $db->query("create table poq_tab (t varchar2(100))");
17 $stmt = $db->prepare('select * from poq_tab');
24 $q = $db->quote($u);
30 $db->exec("delete from poq_tab");
32 $db->query("insert into poq_tab (t) values($q)");
39 @$db->exec("drop table poq_tab");
/PHP-5.6/ext/sqlite3/libsqlite/
H A Dsqlite3.c22237 p->db = db;
23334 m.db = db;
41122 p->db = db;
55000 p->db = db;
64808 p->db = db;
65601 db = p->db;
65977 db = p->db;
65998 db = p->db;
66456 db = p->db;
67367 db = p->db;
[all …]
/PHP-5.6/ext/pdo_sqlite/tests/
H A Dbug_42589.phpt9 $db = new PDO("sqlite::memory:");
11 $db->exec('CREATE TABLE test (field1 VARCHAR(10))');
12 $db->exec('INSERT INTO test VALUES("test")');
14 $result = $db->query('SELECT * FROM test t1 LEFT JOIN test t2 ON t1.field1 = t2.field1');
/PHP-5.6/ext/sybase_ct/tests/
H A Dtest_connect.phpt14 $db= sybase_connect_ex();
15 var_dump($db);
16 sybase_close($db);

Completed in 383 milliseconds

12345678910>>...31