/PHP-7.4/ext/pdo_pgsql/tests/ |
H A D | disable_prepares.phpt | 13 $db = PDOTest::test_factory(__DIR__ . '/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(
|
H A D | bug70861.phpt | 13 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 15 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 18 @$db->query("SET bytea_output = 'escape'"); 22 $db->query('DROP TABLE IF EXISTS test_blob_crash CASCADE'); 23 $db->query('CREATE TABLE test_blob_crash (id SERIAL NOT NULL, blob1 BYTEA)'); 35 $stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (:foo)", array(PDO::ATTR_CURSOR => P…
|
/PHP-7.4/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;
|
/PHP-7.4/ext/pdo_mysql/tests/ |
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_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_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");
|
H A D | bug_41698.phpt | 14 $db = PDOTest::test_factory(__DIR__ . '/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 D | last_insert_id.phpt | 13 $db = PDOTest::test_factory(__DIR__ . '/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());
|
/PHP-7.4/ext/sqlite3/tests/ |
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 | 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());
|
H A D | sqlite3_bind_bug68849.phpt | 8 $db = new SQLite3(':memory:'); 10 $db->exec("CREATE TABLE test (a INTEGER, b TEXT, c REAL);" . 16 $s = $db->prepare('SELECT * FROM test WHERE (a+2) = ?;'); 21 $s = $db->prepare('SELECT * FROM test WHERE a = ?;'); 26 $s = $db->prepare('SELECT * FROM test WHERE a = ?;'); 31 $s = $db->prepare('SELECT * FROM test WHERE c = ?;');
|
/PHP-7.4/ext/pdo/tests/ |
H A D | pdo_027.phpt | 15 $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 D | pdo_035.phpt | 9 $db = new PDO('sqlite::memory:'); 10 $db->exec('CREATE TABLE test (id int)'); 11 $db->exec('INSERT INTO test VALUES (23)'); 13 $stmt = $db->prepare('SELECT id FROM test');
|
H A D | pdo_007.phpt | 15 $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 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 | 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;
|
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 | bug_35671.phpt | 15 $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));
|
H A D | bug_73234.phpt | 16 $db = PDOTest::factory(); 17 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true); 18 $db->exec('CREATE TABLE test(id INT NULL)'); 20 $stmt = $db->prepare('INSERT INTO test VALUES(:value)'); 28 $stmt = $db->query('SELECT * FROM test');
|
H A D | pdo_020.phpt | 15 $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);
|
/PHP-7.4/ext/pgsql/tests/ |
H A D | 15pg_delete.phpt | 11 $db = pg_connect($conn_str); 15 echo pg_delete($db, $table_name, $ids, PGSQL_DML_STRING)."\n"; 16 echo pg_delete($db, $table_name, $ids, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n"; 17 if (!pg_delete($db, $table_name, $ids)) {
|
/PHP-7.4/ext/mysqli/tests/ |
H A D | 049.phpt | 14 $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]);
|