/PHP-7.1/ext/sqlite3/tests/ |
H A D | sqlite3result_fetcharray_with_two_params_fails.phpt | 10 $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 D | sqlite3result_reset_with_params_fails.phpt | 10 $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 D | bug69972.phpt | 9 $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 D | sqlite3_04_update.phpt | 12 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 D | sqlite3_05_delete.phpt | 12 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 D | bug76665.phpt | 9 $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 D | bug72668.phpt | 12 $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 D | sqlite3_33_createAggregate_notcallable.phpt | 14 $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 D | sqlite3_08_udf.phpt | 17 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 D | bug73959.phpt | 14 $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 D | disable_prepares.phpt | 13 $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 D | bug30162.phpt | 35 $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 D | 14pg_update_9.phpt | 14 $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 D | bug49125.phpt | 16 $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 D | pdo_mysql_stmt_bindcolumn.phpt | 8 $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 D | bug_41997.phpt | 11 $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 D | pdo_mysql_stmt_unbuffered_2050.phpt | 8 $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 D | bug_41125.phpt | 9 $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 D | dbareader.inc | 20 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 D | pdo_030.phpt | 59 $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 D | bug_34687.phpt | 15 $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 D | pdo_006.phpt | 15 $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 D | pdo_test.inc | 35 $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 D | pdo_023.phpt | 59 $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 D | checkliveness.phpt | 13 $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;
|