Home
last modified time | relevance | path

Searched refs:db (Results 176 – 200 of 724) sorted by relevance

12345678910>>...29

/PHP-5.5/ext/pdo/tests/
H A Dpdo_007.phpt15 $db = PDOTest::factory();
17 $db->exec('CREATE TABLE test(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))');
18 $db->exec("INSERT INTO test VALUES('A', 'A')");
19 $db->exec("INSERT INTO test VALUES('B', 'A')");
20 $db->exec("INSERT INTO test VALUES('C', 'C')");
22 $stmt = $db->prepare('SELECT id, val from test');
H A Dpdo_020.phpt15 $db = PDOTest::factory();
17 $db->exec('CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(16))');
18 $db->exec("INSERT INTO test VALUES(1, 'A', 'A')");
19 $db->exec("INSERT INTO test VALUES(2, 'B', 'B')");
20 $db->exec("INSERT INTO test VALUES(3, 'C', 'C')");
24 $stmt = $db->query($sql);
H A Dbug65946.phpt15 $db = PDOTest::factory();
16 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
17 $db->exec('CREATE TABLE test(id int)');
18 $db->exec('INSERT INTO test VALUES(1)');
19 $stmt = $db->prepare('SELECT * FROM test LIMIT :limit');
H A Dpdo_027.phpt15 $db = PDOTest::factory();
17 $db->exec('create table test (id int, name varchar(10))');
18 $db->exec("INSERT INTO test (id,name) VALUES(1,'test1')");
19 $db->exec("INSERT INTO test (id,name) VALUES(2,'test2')");
21 foreach ($db->query("SELECT * FROM test", PDO::FETCH_LAZY) as $v) {
H A Dbug_35671.phpt15 $db = PDOTest::factory();
17 $db->exec('CREATE TABLE test (field1 VARCHAR(32), field2 VARCHAR(32), field3 VARCHAR(32))');
18 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
20 $insert = $db->prepare("insert into test (field1, field2, field3) values (:value1, :value2, :value3…
31 var_dump($db->query("SELECT * from test")->fetchAll(PDO::FETCH_ASSOC));
/PHP-5.5/ext/sqlite3/tests/
H A Dsqlite3_32_last_insert_rowid_param.phpt11 $db = new SQLite3(':memory:');
14 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
17 var_dump($db->exec('INSERT INTO test (time, id) VALUES(2, 1)'));
21 $db->lastInsertRowID("");
27 var_dump($db->close());
H A Dsqlite3_prepare_wrongparams.phpt11 $db = new SQLite3(':memory:');
12 $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)');
13 $db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')");
15 $stmt = $db->prepare();
H A Dsqlite3_14_querysingle.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 var_dump($db->querySingle("SELECT id FROM test WHERE id = 'a'"));
20 var_dump($db->querySingle("SELECT id, time FROM test WHERE id = 'a'", true));
H A Dsqlite3_21_security.phpt10 $file = uniqid() . '.db';
13 $db = new SQLite3($directory . $file);
14 var_dump($db);
15 var_dump($db->close());
20 $db = new SQLite3('../bad' . $file);
H A Dsqlite3_prepared_stmt_clear_with_params.phpt10 $db = new SQLite3(':memory:');
13 $db->exec('CREATE TABLE test (time INTEGER, id STRING)');
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
18 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
21 var_dump($db->close());
/PHP-5.5/ext/mysqli/tests/
H A Dmysqli_pconn_twice.phpt19 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
21 $host, $user, $db, $port, $socket);
23 if (true !== ($tmp = my_mysqli_real_connect($link, $host, $user, $passwd, $db, $port, $socket)))
37 if (!$link = new my_mysqli($host, $user, $passwd, $db, $port, $socket))
39 $host, $user, $db, $port, $socket);
42 if (true !== ($tmp = $link->real_connect($host, $user, $passwd, $db, $port, $socket)))
56 if (NULL !== ($tmp = $link->connect($host, $user, $passwd, $db, $port, $socket)))
59 if (!$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket))
61 $host, $user, $db, $port, $socket);
63 if (NULL !== ($tmp = $link->connect($host, $user, $passwd, $db, $port, $socket)))
H A D049.phpt14 $mysql = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
16 $mysql->select_db($db);
22 if ($row[0] != $db)
23 printf("[001] Expecting '%s' got '%s'\n", $db, $row[0]);
/PHP-5.5/ext/mysql/tests/
H A Dmysql_select_db.phpt18 if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket))
20 $host, $user, $db, $port, $socket);
22 if (!is_null($tmp = @mysql_select_db($db, $link, "foo")))
25 /* does not make too much sense, unless we have access to at least one more database than $db */
26 if (!mysql_select_db($db, $link))
27 printf("[004] Cannot select DB %s, [%d] %s\n", $db, mysql_errno($link), mysql_error($link));
35 if ($row['dbname'] !== (string)$db)
36 printf("[007] Expecting database '%s', found '%s'\n", $db, $row['dbname']);
44 // ($db) was done by mysql__connect() already and the previous test
63 if (false !== ($tmp = mysql_select_db($db, $link)))
/PHP-5.5/ext/pdo_mysql/tests/
H A Dbug66141.phpt12 $db = MySQLPDOTest::factory();
16 $quotedInput0 = $db->quote($input);
18 $db->query('set session sql_mode="NO_BACKSLASH_ESCAPES"');
22 $quotedInput1 = $db->quote($input);
24 $db->query('something that throws an exception');
26 $quotedInput2 = $db->quote($input);
H A Dpdo_mysql___construct_options_libmysql.phpt22 $db = new PDO($dsn, $user, $pass, array($option => $value));
23 if (!is_object($db) || (!$ignore_diff && ($value !== ($tmp = @$db->getAttribute($option)))))
53 $db = new PDO($dsn, $user, $pass);
56 $tmp = @$db->getAttribute($option);
74 (is_object($db)) ? $db->errorCode() : 'n/a',
75 (is_object($db)) ? implode(' ', $db->errorInfo()) : 'n/a');
H A Dbug_41698.phpt14 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
18 $db->exec('CREATE TABLE test(floatval DECIMAL(8,6))');
19 $db->exec('INSERT INTO test VALUES(2.34)');
21 $stmt = $db->prepare('INSERT INTO test VALUES(?)');
23 var_dump($db->query('SELECT * from test')->fetchAll(PDO::FETCH_ASSOC));
H A Dlast_insert_id.phpt13 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
15 print_r($db->query("CREATE TABLE test (id int auto_increment primary key, num int)"));
17 print_r($db->query("INSERT INTO test (id, num) VALUES (23, 42)"));
19 print_r($db->query("INSERT INTO test (num) VALUES (451)"));
21 print_r($db->lastInsertId());
H A Dpdo_mysql_attr_connection_status.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
15 $status = $db->getAttribute(PDO::ATTR_CONNECTION_STATUS);
27 if (false !== $db->setAttribute(PDO::ATTR_CONNECTION_STATUS, 'my own connection status'))
30 $status2 = $db->getAttribute(PDO::ATTR_CONNECTION_STATUS);
/PHP-5.5/ext/pgsql/tests/
H A D03sync_query.phpt10 $db = pg_connect($conn_str);
12 $result = pg_query($db, "SELECT * FROM ".$table_name.";");
55 pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";"));
56 pg_num_fields(pg_query($db, "SELECT * FROM ".$table_name.";"));
64 $result = pg_query($db, "INSERT INTO ".$table_name." VALUES (9999, 'ABC');");
68 pg_close($db);
H A D14pg_update_9.phpt14 $db = pg_connect($conn_str);
15 pg_query($db, "SET standard_conforming_strings = 0");
20 pg_update($db, $table_name, $fields, $ids) or print "Error in test 1\n";
21 echo pg_update($db, $table_name, $fields, $ids, PGSQL_DML_STRING)."\n";
H A D18pg_escape_bytea_before.phpt14 $db = pg_connect($conn_str);
15 @pg_query($db, "SET bytea_output = 'escape'");
17 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, E\''.$esc_image.'\');');
18 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
H A D18pg_escape_bytea_esc.phpt11 $db = pg_connect($conn_str);
12 @pg_query($db, "SET bytea_output = 'escape'");
17 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');');
18 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
H A D18pg_escape_bytea_hex.phpt14 $db = pg_connect($conn_str);
15 @pg_query($db, "SET bytea_output = 'hex'");
20 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');');
21 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
/PHP-5.5/ext/sybase_ct/tests/
H A Dtest_unbuffered_no_full_fetch.phpt14 $db= sybase_connect_ex();
15 var_dump($db);
18 $q= sybase_unbuffered_query('select name from master..systypes', $db);
22 $q= sybase_unbuffered_query('select name from master..systypes', $db);
27 $q= sybase_unbuffered_query('select name from master..systypes', $db);
31 sybase_close($db);
H A Dbug28354.phpt14 $db= sybase_connect_ex();
20 var_dump(sybase_select_db(TEMPDB, $db));
21 if (!sybase_select_single($db, 'select object_id("'.$sp_name.'")')) {
33 $r= sybase_query('exec '.$sp_name, $db);
39 sybase_close($db);

Completed in 33 milliseconds

12345678910>>...29