/PHP-7.4/ext/pdo/tests/ |
H A D | pdo_013.phpt | 15 $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 D | bug_65946.phpt | 15 $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 D | bug_36798.phpt | 22 $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 D | bug_39398.phpt | 16 $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 D | bug_40285.phpt | 16 $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 D | bug_50458.phpt | 16 $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 D | bug70628.phpt | 8 $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 D | sqlite3_03_insert.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->close());
|
H A D | sqlite3_23_escape_string.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 . ", '" . 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 D | bug72571.phpt | 8 $db = new SQLite3(':memory:'); 10 $stmt = $db->prepare("select 1 = ?"); 17 $db->close();
|
H A D | sqlite3_38_backup.phpt | 11 $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 D | sqlite3_20_error.phpt | 11 $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 D | 07optional.phpt | 11 $db = pg_connect($conn_str); 12 $enc = pg_client_encoding($db); 14 pg_set_client_encoding($db, $enc);
|
H A D | 14pg_update.phpt | 14 $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 D | bug71998.phpt | 12 $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 D | bug72570.phpt | 13 $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 D | bug46274_2.phpt | 13 $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 D | bug_33707.phpt | 12 $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 D | bug64726.phpt | 15 $db = new my_mysqli($host, $user, $passwd, $db, $port, $socket); 18 $result = $db->query('SELECT 1', MYSQLI_USE_RESULT); 19 $db->close();
|
H A D | bug33263.phpt | 15 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 D | bug_61207.phpt | 13 $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 D | bug_33689.phpt | 14 $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 D | bug_42589.phpt | 9 $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 D | bug33841.phpt | 10 $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 D | bug48240.phpt | 14 $db = dba_open($db_filename, 'c', 'db4'); 16 var_dump(dba_nextkey($db)); 18 dba_close($db);
|