/PHP-7.0/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_stmt_blobs.phpt | 12 $db = MySQLPDOTest::factory(); 25 function test_blob($db, $offset, $sql_type, $test_len) { 27 $db->exec('DROP TABLE IF EXISTS test'); 40 $stmt = $db->query('SELECT id, label FROM test'); 63 $stmt = $db->query('SELECT id, label FROM test'); 83 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 84 test_blob($db, ++$offset, $sql_type, $test_len); 85 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 86 test_blob($db, ++$offset, $sql_type, $test_len); 94 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_stmt_bindparam.phpt | 12 $db = MySQLPDOTest::factory(); 15 MySQLPDOTest::createTestTable($db); 17 function pdo_mysql_stmt_bindparam($db, $offset) { 90 pdo_mysql_stmt_bindparam($db, 3); 93 MySQLPDOTest::createTestTable($db); 95 pdo_mysql_stmt_bindparam($db, 4); 103 MySQLPDOTest::createTestTable($db); 105 pdo_mysql_stmt_bindparam($db, 5); 108 MySQLPDOTest::createTestTable($db); 110 pdo_mysql_stmt_bindparam($db, 6); [all …]
|
H A D | pdo_mysql_attr_init_command.phpt | 8 $db = MySQLPDOTest::factory(); 21 $db = new PDO($dsn, $user, $pass); 22 $db->exec(sprintf('DROP TABLE IF EXISTS %s', $table)); 26 $db = new PDO($dsn, $user, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => $create)); 28 $info = $db->errorInfo(); 31 $db->exec(sprintf('INSERT INTO %s(id) VALUES (1)', $table)); 32 $stmt = $db->query(sprintf('SELECT id FROM %s', $table)); 35 $db->exec(sprintf('DROP TABLE IF EXISTS %s', $table));
|
H A D | pdo_mysql_prepare_emulated_placeholder_everywhere.phpt | 13 $db = MySQLPDOTest::factory(); 17 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 18 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 21 $db->exec('DROP TABLE IF EXISTS test'); 27 $stmt = $db->prepare('SELECT ? FROM test WHERE ? > ?'); 38 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 39 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 42 $stmt = $db->prepare('SELECT ? FROM test WHERE ? > ?'); 52 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 60 $db = MySQLPDOTest::factory(); [all …]
|
H A D | bug44327.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 15 $stmt = $db->prepare("SELECT 1 AS \"one\""); 25 @$db->exec("DROP TABLE test"); 26 $db->exec("CREATE TABLE test (id INT)"); 27 $db->exec("INSERT INTO test(id) VALUES (1)"); 28 $stmt = $db->prepare("SELECT id FROM test"); 33 @$db->exec("DROP TABLE test"); 37 $stmt = $db->prepare('foo');
|
H A D | pdo_mysql_attr_oracle_nulls.phpt | 12 $db = MySQLPDOTest::factory(); 13 MySQLPDOTest::createTestTable($db); 16 if (false !== @$db->setAttribute(PDO::ATTR_ORACLE_NULLS, $tmp)) 20 if (false !== @$db->setAttribute(PDO::ATTR_ORACLE_NULLS, $tmp)); 26 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 1); 30 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 0); 34 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 1); 35 $stmt = $db->query('SELECT VERSION() as _version'); 42 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 48 $stmt = $db->prepare('CALL p()'); [all …]
|
H A D | pdo_mysql_attr_server_info.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 15 assert(('' == $db->errorCode()) || ('00000' == $db->errorCode())); 17 $info = $db->getAttribute(PDO::ATTR_SERVER_INFO); 22 if (false !== $db->setAttribute(PDO::ATTR_SERVER_INFO, 'new uptime: 0s')) 25 $new_info = $db->getAttribute(PDO::ATTR_SERVER_INFO); 30 if (!$stmt = $db->query("SHOW STATUS LIKE '%uptime%'")) 31 printf("[004] Cannot run SHOW STATUS, [%s]\n", $db->errorCode()); 34 printf("[005] Unable to fetch uptime, [%s]\n", $db->errorCode());
|
H A D | table.inc | 2 if (!$db) { 4 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 6 // $db->exec('DROP TABLE IF EXISTS test'); 7 $db->exec('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine); 8 $db->exec('INSERT INTO test(id, label) VALUES (1, "a"), (2, "b"), (3, "c"), (4, "d"), (5, "e"), (6,…
|
H A D | pdo_mysql_stmt_blobfromsteam.phpt | 55 $db->exec('DROP TABLE IF EXISTS test'); 57 $db->exec($sql); 77 var_export($db->errorInfo(), true)); 97 $db->exec('DELETE FROM test'); 116 $db = MySQLPDOTest::factory(); 124 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 125 blob_from_stream(10, $db, $file, $blob); 129 blob_from_stream(30, $db, $file, $blob); 133 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 141 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_stmt_fetch_non_select.phpt | 12 $db = MySQLPDOTest::factory(); 13 MySQLPDOTest::createTestTable($db); 18 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 39 if (!is_object($stmt = $db->query('SHOW ENGINES'))) 75 $db->exec('DEALLOCATE PREPARE mystmt'); 81 var_export($db->errorInfo(), true)); 109 $db->exec('DEALLOCATE PREPARE mystmt'); 115 var_export($db->errorInfo(), true)); 142 $db->exec('DEALLOCATE PREPARE mystmt'); 148 var_export($db->errorInfo(), true)); [all …]
|
H A D | pdo_mysql_attr_fetch_table_names.phpt | 12 $db = MySQLPDOTest::factory(); 13 MySQLPDOTest::createTestTable($db); 15 $db->setAttribute(PDO::ATTR_FETCH_TABLE_NAMES, 1); 16 $stmt = $db->query('SELECT label FROM test LIMIT 1'); 20 $db->setAttribute(PDO::ATTR_FETCH_TABLE_NAMES, 0); 21 $stmt = $db->query('SELECT label FROM test LIMIT 1');
|
/PHP-7.0/ext/spl/examples/ |
H A D | dba_dump.php | 32 $db = new DbaReader($argv[1], $argv[2]); variable 35 $db = new KeyFilter($db, $argv[3]); variable 38 foreach($db as $key => $val) {
|
/PHP-7.0/ext/pdo/tests/ |
H A D | pdo_032.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, 'B')"); 20 $db->exec("INSERT INTO test VALUES(3, 'C')"); 23 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER); 24 $stmt = $db->prepare('SELECT * from test'); 30 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_UPPER); 31 $stmt = $db->prepare('SELECT * from test');
|
H A D | pdo_009.phpt | 15 $db = PDOTest::factory(); 17 $db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) NOT NULL UNIQUE)'); 18 $db->exec('INSERT INTO classtypes VALUES(0, \'stdClass\')'); 19 $db->exec('INSERT INTO classtypes VALUES(1, \'Test1\')'); 20 $db->exec('INSERT INTO classtypes VALUES(2, \'Test2\')'); 21 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(10))'); 22 $db->exec('INSERT INTO test VALUES(1, 0, \'A\')'); 23 $db->exec('INSERT INTO test VALUES(2, 1, \'B\')'); 24 $db->exec('INSERT INTO test VALUES(3, 2, \'C\')'); 25 $db->exec('INSERT INTO test VALUES(4, 3, \'D\')'); [all …]
|
/PHP-7.0/ext/pdo_oci/tests/ |
H A D | bug46274.phpt | 13 $db = PDOTest::test_factory('ext/pdo_oci/tests/common.phpt'); 14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 16 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 19 $db->exec("DROP TABLE test_one_blob"); 23 $db->beginTransaction(); 25 $db->query('CREATE TABLE test_one_blob (id INT NOT NULL, blob1 BLOB)'); 27 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl… 49 $res = $db->query("SELECT blob1 from test_one_blob"); 56 $db->exec("DROP TABLE test_one_blob");
|
/PHP-7.0/ext/sqlite3/tests/ |
H A D | sqlite3_31_open.phpt | 12 $db = new SQLite3(__DIR__ . '/db1.db'); 13 $db->open(__DIR__ . '/db1.db'); 20 <?php @unlink(__DIR__ . '/db1.db'); ?>
|
H A D | sqlite3_33_reset.phpt | 11 $db = new SQLite3(':memory:'); 13 $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)'); 14 $db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')"); 16 $stmt = $db->prepare('SELECT bar FROM foo WHERE id=:id'); 21 //var_dump($db); 22 //var_dump($db->close());
|
/PHP-7.0/ext/pdo_dblib/tests/ |
H A D | stringify_uniqueidentifier.phpt | 22 $db->setAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER, true); 23 var_dump(true === $db->getAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER)); 24 $db->setAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER, false); 25 var_dump(false === $db->getAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER)); 31 $stmt = $db->query($sql); 40 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 41 $stmt = $db->query($sql); 43 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 54 $db->setAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER, true); 55 $stmt = $db->query($sql);
|
H A D | timeout.phpt | 16 $stmt = $db->prepare($sql); 22 $db = new PDO($dsn, $user, $pass); 23 $db->setAttribute(PDO::ATTR_TIMEOUT, 1); 24 $stmt = $db->prepare($sql); 35 $db = new PDO($dsn, $user, $pass); 36 $db->setAttribute(PDO::DBLIB_ATTR_QUERY_TIMEOUT, 1); 37 $stmt = $db->prepare($sql); 48 $db = new PDO($dsn, $user, $pass, [PDO::ATTR_TIMEOUT => 1]); 49 $stmt = $db->prepare($sql); 60 $db = new PDO($dsn, $user, $pass, [PDO::DBLIB_ATTR_QUERY_TIMEOUT => 1]); [all …]
|
/PHP-7.0/ext/pdo_sqlite/tests/ |
H A D | pdo_fetch_func_001.phpt | 10 $db = new PDO('sqlite::memory:'); 15 $st = $db->query('SELECT * FROM testing'); 18 $st = $db->query('SELECT name FROM testing'); 21 $st = $db->query('SELECT * FROM testing'); 24 $st = $db->query('SELECT * FROM testing'); 27 $st = $db->query('SELECT * FROM testing'); 30 $st = $db->query('SELECT * FROM testing'); 33 $st = $db->query('SELECT * FROM testing'); 42 public function __construct($db) { 60 new bar($db); [all …]
|
H A D | bug70862.phpt | 8 $db = new pdo('sqlite::memory:'); 9 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 11 $db->exec('CREATE TABLE test(field BLOB)'); 13 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 26 $stmt = $db->prepare('INSERT INTO test(field) VALUES (:para)');
|
/PHP-7.0/ext/pgsql/tests/ |
H A D | 29nb_async_connect.phpt | 13 if (!$db = pg_connect($conn_str, PGSQL_CONNECT_ASYNC)) { 15 } elseif (pg_connection_status($db) === PGSQL_CONNECTION_BAD) { 17 } elseif ($db_socket = pg_socket($db)) { 24 switch ($status = pg_connect_poll($db)) { 37 assert(pg_connection_status($db) === PGSQL_CONNECTION_MADE); 40 pg_close($db);
|
H A D | 12pg_insert_9.phpt | 14 $db = pg_connect($conn_str); 15 pg_query($db, "SET standard_conforming_strings = 0"); 19 pg_insert($db, $table_name, $fields) or print "Error in test 1\n"; 20 echo pg_insert($db, $table_name, $fields, PGSQL_DML_STRING)."\n"; 21 echo pg_insert($db, $table_name, $fields, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n"; 22 var_dump( pg_insert($db, $table_name, $fields, PGSQL_DML_EXEC) ); // Return resource
|
/PHP-7.0/ext/phar/tests/files/ |
H A D | pear2coverage.phar.php | 927 protected $db; 937 $this->db = new \Sqlite3($path); 953 $this->db->exec(' 962 $this->db->exec('BEGIN'); 989 @$this->db->exec('ROLLBACK'); 1058 $this->db->exec('COMMIT'); 1300 …$this->db->exec('DELETE FROM xdebugs WHERE xdebugpath="' . $this->db->escapeString($xdebugpath) . … 1443 $this->db->exec($query); 1452 $this->db->exec($query); 1497 $this->db->exec('BEGIN'); [all …]
|
/PHP-7.0/ext/pdo_firebird/tests/ |
H A D | execute.phpt | 13 $db = new PDO("firebird:dbname=$test_base",$user,$password) or die; 15 var_dump($db->getAttribute(PDO::ATTR_CONNECTION_STATUS)); 17 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); 19 $db->exec("CREATE TABLE ddl (id SMALLINT NOT NULL PRIMARY KEY, text VARCHAR(32), 21 $db->exec("INSERT INTO ddl (id,text) VALUES (1,'bla')"); 23 $s = $db->prepare("SELECT * FROM ddl WHERE id=? FOR UPDATE"); 39 var_dump($db->exec("UPDATE ddl SET id=2 WHERE CURRENT OF c")); 44 unset($db);
|