Home
last modified time | relevance | path

Searched refs:db (Results 101 – 125 of 739) sorted by relevance

12345678910>>...30

/PHP-7.0/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_blobs.phpt12 $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 Dpdo_mysql_stmt_bindparam.phpt12 $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 Dpdo_mysql_attr_init_command.phpt8 $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 Dpdo_mysql_prepare_emulated_placeholder_everywhere.phpt13 $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 Dbug44327.phpt8 $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 Dpdo_mysql_attr_oracle_nulls.phpt12 $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 Dpdo_mysql_attr_server_info.phpt8 $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 Dtable.inc2 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 Dpdo_mysql_stmt_blobfromsteam.phpt55 $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 Dpdo_mysql_stmt_fetch_non_select.phpt12 $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 Dpdo_mysql_attr_fetch_table_names.phpt12 $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 Ddba_dump.php32 $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 Dpdo_032.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, '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 Dpdo_009.phpt15 $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 Dbug46274.phpt13 $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 Dsqlite3_31_open.phpt12 $db = new SQLite3(__DIR__ . '/db1.db');
13 $db->open(__DIR__ . '/db1.db');
20 <?php @unlink(__DIR__ . '/db1.db'); ?>
H A Dsqlite3_33_reset.phpt11 $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 Dstringify_uniqueidentifier.phpt22 $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 Dtimeout.phpt16 $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 Dpdo_fetch_func_001.phpt10 $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 Dbug70862.phpt8 $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 D29nb_async_connect.phpt13 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 D12pg_insert_9.phpt14 $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 Dpear2coverage.phar.php927 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 Dexecute.phpt13 $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);

Completed in 54 milliseconds

12345678910>>...30