Home
last modified time | relevance | path

Searched refs:db (Results 251 – 275 of 777) sorted by relevance

1...<<11121314151617181920>>...32

/PHP-7.4/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_65946.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 switch ($db->getAttribute(PDO::ATTR_DRIVER_NAME)) {
37 $stmt = $db->prepare($sql);
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");
H A Dbug_39398.phpt16 $db = PDOTest::factory();
17 $db->exec("CREATE TABLE test (test INT)");
20 $stmt = $db->prepare('INSERT INTO test VALUES (:boolean)');
24 var_dump($db->query("SELECT * FROM test")->fetchAll(PDO::FETCH_ASSOC));
H A Dbug_40285.phpt16 $db = PDOTest::factory();
18 $db->exec('CREATE TABLE test (field1 VARCHAR(32), field2 VARCHAR(32), field3 VARCHAR(32), field4 IN…
20 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
21 $s = $db->prepare("INSERT INTO test VALUES( ':id', 'name', 'section', 22)" );
H A Dbug_50458.phpt16 $db = PDOTest::factory();
17 $db->exec("CREATE TABLE test (a VARCHAR(10))");
18 $db->exec("INSERT INTO test (a) VALUES ('xyz')");
19 $res = $db->query("SELECT a FROM test");
/PHP-7.4/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 Dbug72571.phpt8 $db = new SQLite3(':memory:');
10 $stmt = $db->prepare("select 1 = ?");
17 $db->close();
H A Dsqlite3_38_backup.phpt11 $db->exec('CREATE TABLE test (a, b);');
12 $db->exec('INSERT INTO test VALUES (42, \'php\');');
15 var_dump($db->querySingle('SELECT COUNT(*) FROM sqlite_master;'));
20 var_dump($db->backup($db2));
35 var_dump($db->exec('BEGIN EXCLUSIVE;'));
38 var_dump($db->backup($db2));
H A Dsqlite3_20_error.phpt11 $result = $db->query("SELECT * FROM non_existent_table");
13 echo "Error Code: " . $db->lastErrorCode() . "\n";
14 echo "Error Msg: " . $db->lastErrorMsg() . "\n";
17 var_dump($db->close());
/PHP-7.4/ext/pgsql/tests/
H A D07optional.phpt11 $db = pg_connect($conn_str);
12 $enc = pg_client_encoding($db);
14 pg_set_client_encoding($db, $enc);
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 Dbug71998.phpt12 $db = pg_connect($conn_str);
58 $r = @pg_insert($db, 'tmp_statistics', $data);
62 //echo pg_last_error($db);
65 …//pg_query($db, "INSERT INTO tmp_statistics (id, remote_addr) VALUES (2, '127.0.0.1')"); // OK, re…
69 $r = pg_query($db, "SELECT * FROM tmp_statistics");
75 pg_query($db, "DROP TABLE tmp_statistics");
76 pg_close($db);
/PHP-7.4/ext/pdo_pgsql/tests/
H A Dbug72570.phpt13 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
16 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
18 $stmt = $db->prepare("SELECT 1");
H A Dbug46274_2.phpt13 $db = PDOTest::test_factory(__DIR__ . '/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-7.4/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());
/PHP-7.4/ext/mysqli/tests/
H A Dbug64726.phpt15 $db = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
18 $result = $db->query('SELECT 1', MYSQLI_USE_RESULT);
19 $db->close();
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-7.4/ext/pdo_mysql/tests/
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 Dbug_33689.phpt14 $db = PDOTest::test_factory(__DIR__ . '/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-7.4/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');
H A Dbug33841.phpt10 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
12 $db->exec('CREATE TABLE test (text)');
14 $stmt = $db->prepare("INSERT INTO test VALUES ( :text )");
19 $stmt = $db->prepare("UPDATE test SET text = :text ");
/PHP-7.4/ext/dba/tests/
H A Dbug48240.phpt14 $db = dba_open($db_filename, 'c', 'db4');
16 var_dump(dba_nextkey($db));
18 dba_close($db);

Completed in 26 milliseconds

1...<<11121314151617181920>>...32