Home
last modified time | relevance | path

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

12345678910>>...31

/PHP-7.1/ext/sqlite3/tests/
H A Dsqlite3result_fetcharray_with_two_params_fails.phpt10 $db = new SQLite3(':memory:');
11 $db->exec('CREATE TABLE foo (bar STRING)');
12 $db->exec("INSERT INTO foo (bar) VALUES ('This is a test')");
13 $db->exec("INSERT INTO foo (bar) VALUES ('This is another test')");
15 $result = $db->query('SELECT bar FROM foo');
H A Dsqlite3result_reset_with_params_fails.phpt10 $db = new SQLite3(':memory:');
11 $db->exec('CREATE TABLE foo (bar STRING)');
12 $db->exec("INSERT INTO foo (bar) VALUES ('This is a test')");
13 $db->exec("INSERT INTO foo (bar) VALUES ('This is another test')");
15 $result = $db->query('SELECT bar FROM foo');
H A Dbug69972.phpt9 $db = new SQLite3(':memory:');
11 $result = $db->query("SELECT * FROM non_existent_table");
13 var_dump($db->close());
17 echo "Error Code: " . $db->lastErrorCode() . "\n";
18 echo "Error Msg: " . $db->lastErrorMsg() . "\n";
H A Dsqlite3_04_update.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->exec("UPDATE test SET id = 'c' WHERE id = 'a'"));
30 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
38 var_dump($db->close());
H A Dsqlite3_05_delete.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->exec("DELETE FROM test WHERE id = 'a'"));
30 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
38 var_dump($db->close());
H A Dbug76665.phpt9 $db = new SQLite3(':memory:');
10 $db->exec("CREATE TABLE foo (bar REAL)");
11 $stmt = $db->prepare("INSERT INTO foo VALUES (:bar)");
14 var_dump($db->querySingle("SELECT bar FROM foo LIMIT 1"));
H A Dbug72668.phpt12 $db = new SQLite3(':memory:');
13 $db->createFunction('my_udf_md5', 'my_udf_md5');
16 $result = $db->query('SELECT my_udf_md5("test")');
23 $result = $db->querySingle('SELECT my_udf_md5("test")');
29 $statement = $db->prepare('SELECT my_udf_md5("test")');
H A Dsqlite3_33_createAggregate_notcallable.phpt14 $db = new SQLite3(':memory:');
16 $db->createAggregate ('TESTAGGREGATE', 'aggregate_test_step', 'aggregate_final');
17 $db->createAggregate ('TESTAGGREGATE2', 'aggregate_step', 'aggregate_test_final');
18 var_dump($db->createAggregate ('TESTAGGREGATE3', 'aggregate_step', 'aggregate_final'));
20 $db->close();
H A Dsqlite3_08_udf.phpt17 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
20 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
21 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
24 var_dump($db->createFunction('my_udf_md5', 'my_udf_md5'));
27 $results = $db->query("SELECT my_udf_md5(id) FROM test ORDER BY id ASC");
35 var_dump($db->close());
/PHP-7.1/ext/pdo_pgsql/tests/
H A Dbug73959.phpt14 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
15 $db->setAttribute(PDO::ATTR_PERSISTENT, false);
16 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
17 $db->setAttribute(PDO::PGSQL_ATTR_DISABLE_PREPARES, true);
20 $db->lastInsertId('nonexistent_seq');
H A Ddisable_prepares.phpt13 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
15 $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_COLUMN);
17 $stmt = $db->prepare("SELECT statement FROM pg_prepared_statements", array(
20 $stmt2 = $db->prepare("SELECT (?)::int2");
29 $stmt3 = $db->prepare("SELECT (?)::int4", array(
/PHP-7.1/Zend/tests/
H A Dbug30162.phpt35 $db = new FIIFO();
38 var_dump($db);
40 $db = new hariCow;
42 var_dump($db);
46 Notice: Undefined variable: db in %sbug30162.php on line 35
/PHP-7.1/ext/pgsql/tests/
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";
22 echo pg_update($db, $table_name, $fields, $ids, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n";
/PHP-7.1/ext/dba/tests/
H A Dbug49125.phpt16 $db = dba_popen($db_filename, 'c', 'db4');
18 dba_insert('foo', 'foo', $db);
20 var_dump(dba_exists('foo', $db));
22 dba_close($db);
/PHP-7.1/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_bindcolumn.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
14 MySQLPDOTest::createTestTable($db);
17 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
18 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
21 $stmt = $db->prepare('SELECT id, label FROM test ORDER BY id ASC LIMIT 2');
57 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
58 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
99 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
107 $db = MySQLPDOTest::factory();
[all …]
H A Dbug_41997.phpt11 $db = MySQLPDOTest::factory();
12 $row = $db->query('SELECT VERSION() as _version')->fetch(PDO::FETCH_ASSOC);
25 $db = MySQLPDOTest::factory();
27 $db->exec('DROP PROCEDURE IF EXISTS p');
28 $db->exec('CREATE PROCEDURE p() BEGIN SELECT 1 AS "one"; END');
30 $stmt = $db->query("CALL p()");
36 $stmt = $db->query('SELECT 2 AS "two"');
H A Dpdo_mysql_stmt_unbuffered_2050.phpt8 $db = MySQLPDOTest::factory();
15 $db = MySQLPDOTest::factory();
20 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
21 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
25 MySQLPDOTest::createTestTable($db);
26 $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
27 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1');
29 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1');
33 MySQLPDOTest::createTestTable($db);
34 $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
[all …]
H A Dbug_41125.phpt9 $db = MySQLPDOTest::factory();
10 $row = $db->query('SELECT VERSION() as _version')->fetch(PDO::FETCH_ASSOC);
24 $db = MySQLPDOTest::factory();
25 $db->exec("DROP TABLE IF EXISTS test");
28 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
34 $stmt = $db->query($sql);
44 $db = MySQLPDOTest::factory();
45 $db->exec("DROP TABLE IF EXISTS test");
/PHP-7.1/ext/spl/examples/
H A Ddbareader.inc20 protected $db = NULL;
31 if (!$this->db = dba_open($file, 'r', $handler)) {
40 dba_close($this->db);
47 $this->key = dba_firstkey($this->db);
57 $this->key = dba_nextkey($this->db);
66 $this->val = dba_fetch($this->key, $this->db);
81 if ($this->db && $this->key !== false) {
/PHP-7.1/ext/pdo/tests/
H A Dpdo_030.phpt59 $db = PDOTest::factory('PDODatabase');
60 var_dump(get_class($db));
62 $db->exec('CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(16))');
64 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
74 var_dump($db->getAttribute(PDO::ATTR_STATEMENT_CLASS));
75 $db->setAttribute(PDO::ATTR_STATEMENT_CLASS, array('PDOStatementx', array($db)));
76 var_dump($db->getAttribute(PDO::ATTR_STATEMENT_CLASS));
77 $stmt = $db->query('SELECT * FROM test');
H A Dbug_34687.phpt15 $db = PDOTest::factory();
17 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
18 $x = $db->query("UPDATE non_existent_pdo_test_table set foo = 'bar'");
21 $code = $db->errorCode();
26 print_r($db->errorInfo());
H A Dpdo_006.phpt15 $db = PDOTest::factory();
17 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))');
18 $db->exec("INSERT INTO test VALUES(1, 'A')");
19 $db->exec("INSERT INTO test VALUES(2, 'A')");
20 $db->exec("INSERT INTO test VALUES(3, 'C')");
22 $stmt = $db->prepare('SELECT val, id from test');
H A Dpdo_test.inc35 $db = new $classname($dsn, $user, $pass, $attr);
37 if (!$db) {
50 $db->exec("DROP TABLE $table");
54 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
55 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER);
56 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
57 return $db;
62 $db = PDOTest::factory();
H A Dpdo_023.phpt59 $db = PDOTest::factory('PDODatabaseX');
60 $db->test();
61 var_dump($db);
63 $db->query('CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val VARCHAR(10))');
64 $db->query('INSERT INTO test VALUES(0, \'A\')');
65 $db->query('INSERT INTO test VALUES(1, \'B\')');
68 $stmt = $db->query('SELECT val, id FROM test');
73 $db = NULL;
/PHP-7.1/ext/pdo_oci/tests/
H A Dcheckliveness.phpt13 $db = PDOTest::test_factory('ext/pdo_oci/tests/common.phpt');
21 $db = new PDO($dsn, $user, $pass, array(PDO::ATTR_PERSISTENT => true));
30 $db = new PDO($dsn, $user, $pass, array(PDO::ATTR_PERSISTENT => true));
37 $db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
40 $stmt = $db->prepare('SELECT * FROM dual');
48 $db = null;

Completed in 29 milliseconds

12345678910>>...31