Home
last modified time | relevance | path

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

12345678910>>...29

/PHP-5.5/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-5.5/ext/sqlite3/tests/
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());
H A Dsqlite3_24_last_insert_rowid.phpt12 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->lastInsertRowID());
17 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
18 var_dump($db->lastInsertRowID());
21 var_dump($db->close());
/PHP-5.5/ext/pdo_mysql/tests/
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');
H A Dpdo_mysql_attr_client_version.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
15 assert(('' == $db->errorCode()) || ('00000' == $db->errorCode()));
17 $version = $db->getAttribute(PDO::ATTR_CLIENT_VERSION);
27 if (false !== $db->setAttribute(PDO::ATTR_CLIENT_VERSION, '1.0'))
30 $new_version = $db->getAttribute(PDO::ATTR_CLIENT_VERSION);
H A Dpdo_mysql_stmt_rowcount.phpt12 $db = MySQLPDOTest::factory();
13 MySQLPDOTest::createTestTable($db);
17 if (0 !== ($tmp = $db->query('SELECT id FROM test WHERE 1 = 0')->rowCount()))
20 if (1 !== ($tmp = $db->query('SELECT id FROM test WHERE id = 1')->rowCount()))
25 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
H A Dpdo_mysql_attr_statement_class.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
14 MySQLPDOTest::createTestTable($db);
16 $default = $db->getAttribute(PDO::ATTR_STATEMENT_CLASS);
19 if (false !== ($tmp = @$db->setAttribute(PDO::ATTR_STATEMENT_CLASS)))
22 if (false !== ($tmp = @$db->setAttribute(PDO::ATTR_STATEMENT_CLASS, 'foo')))
81 var_dump($db->getAttribute(PDO::ATTR_STATEMENT_CLASS));
82 $stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC LIMIT 2');
92 $stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC LIMIT 2');
98 $stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC LIMIT 1');
[all …]
H A Dpdo_mysql_prepare_native_mixed_style.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
14 MySQLPDOTest::createTestTable($db);
16 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
17 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
20 $stmt = $db->query('DELETE FROM test');
21 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (1, ?), (2, ?)');
23 …$stmt = $db->prepare("SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label…
H A Dpecl_bug_5802.phpt13 $db = PDOTest::test_factory(dirname(__FILE__). '/common.phpt');
15 $db->exec('create table test ( bar char(3) NULL )');
16 $stmt = $db->prepare('insert into test (bar) values(:bar)') or var_dump($db->errorInfo());
30 $stmt = $db->prepare('select * from test') or var_dump($db->errorInfo());
40 $db = MySQLPDOTest::factory();
41 $db->exec('DROP TABLE IF EXISTS test');
H A Dpdo_mysql_subclass.phpt59 $db = new MyPDO(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS);
60 $db->exec('DROP TABLE IF EXISTS test');
61 $db->exec('CREATE TABLE test(id INT)');
62 $db->exec('INSERT INTO test(id) VALUES (1), (2)');
63 $stmt = $db->query('SELECT * FROM test ORDER BY id ASC');
66 $db->intercept_call();
71 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
74 $db->exec('DROP TABLE IF EXISTS test');
80 $db = MySQLPDOTest::factory();
81 $db->exec('DROP TABLE IF EXISTS test');
H A Dpdo_mysql_attr_errmode.phpt8 $db = MySQLPDOTest::factory();
15 $db = MySQLPDOTest::factory();
45 $code = $db->errorCode();
46 $info = $db->errorInfo();
61 $code = $db->errorCode();
62 $info = $db->errorInfo();
80 $code = $db->errorCode();
81 $info = $db->errorInfo();
116 global $db, $line;
118 $code = $db->errorCode();
[all …]
H A Dpdo_mysql_stmt_closecursor_empty.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
18 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
19 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
22 $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
23 MySQLPDOTest::createTestTable($db);
25 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? ORDER BY id ASC LIMIT 2');
58 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
61 $db->exec('DROP TABLE IF EXISTS test');
/PHP-5.5/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);
/PHP-5.5/ext/pdo/tests/
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 …]
H A Dpdo_019.phpt15 $db = PDOTest::factory();
17 $db->exec('CREATE TABLE test(idx int NOT NULL PRIMARY KEY, txt VARCHAR(20))');
18 $db->exec('INSERT INTO test VALUES(0, \'String0\')');
19 $db->exec('INSERT INTO test VALUES(1, \'String1\')');
20 $db->exec('INSERT INTO test VALUES(2, \'String2\')');
21 $db->exec('INSERT INTO test VALUES(3, \'String3\')');
24 var_dump($db->query('SELECT COUNT(*) FROM test')->fetchColumn());
26 $stmt = $db->prepare('SELECT idx, txt FROM test ORDER by idx');
H A Dpdo_010.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), grp VARCH…
22 $db->exec('INSERT INTO test VALUES(1, 0, \'A\', \'Group1\')');
23 $db->exec('INSERT INTO test VALUES(2, 1, \'B\', \'Group1\')');
24 $db->exec('INSERT INTO test VALUES(3, 2, \'C\', \'Group2\')');
25 $db->exec('INSERT INTO test VALUES(4, 3, \'D\', \'Group2\')');
[all …]
H A Dbug_39656.phpt16 $db = PDOTest::factory();
18 @$db->exec("DROP TABLE test");
19 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
21 $db->exec("CREATE TABLE test (id INTEGER NOT NULL PRIMARY KEY, usr VARCHAR( 256 ) NOT NULL)");
22 $db->exec("INSERT INTO test (id, usr) VALUES (1, 'user')");
24 $stmt = $db->prepare("SELECT * FROM test WHERE id = ?");
35 @$db->exec("DROP TABLE test");
/PHP-5.5/ext/pdo_pgsql/tests/
H A Dcopy_to.phpt13 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
15 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
19 $db->beginTransaction();
35 $db->commit();
38 var_dump($db->pgsqlCopyToArray('test'));
40 var_dump($db->pgsqlCopyToArray('test',";","NULL"));
42 var_dump($db->pgsqlCopyToArray('test',";","NULL",'a,c'));
45 var_dump($db->pgsqlCopyToArray('test_error'));
51 var_dump($db->pgsqlCopyToFile('test',$filename));
[all …]
H A Dlarge_objects.phpt13 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
15 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
19 $db->beginTransaction();
20 $oid = $db->pgsqlLOBCreate();
22 $stm = $db->pgsqlLOBOpen($oid, 'w+b');
25 $stmt = $db->prepare("INSERT INTO test (blobid, bloboid) values (?, ?)");
36 $stmt = $db->prepare("SELECT * from test");
47 $stmt = $db->prepare("SELECT * from test");
58 $stmt = $db->prepare("SELECT * from test");
[all …]
/PHP-5.5/ext/mysqli/tests/
H A Dbug38710.phpt12 $db = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
13 $qry=$db->stmt_init();
18 …at('a', ($IS_MYSQLND || mysqli_get_server_version($db) > 50110)? 100000:(mysqli_get_server_version…
H A Dmysqli_change_user_old.phpt9 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
11 $host, $user, $db, $port, $socket));
38 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
40 $host, $user, $db, $port, $socket);
57 $host, $user, $db, $port, $socket);
69 if (true !== ($tmp = mysqli_change_user($link, $user, $passwd, $db)))
79 if ($tmp['dbname'] != $db)
93 $host, $user, $db, $port, $socket);
103 $host, $user, $db, $port, $socket);
107 (empty db = no db send with COM_CHANGE_USER) */
[all …]
/PHP-5.5/ext/pdo_oci/tests/
H A Dbug46274_2.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, false);
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");
60 $db->exec("DROP TABLE test_one_blob");
/PHP-5.5/ext/pgsql/tests/
H A D23sync_query_params.phpt13 $db = pg_connect($conn_str);
15 $version = pg_version($db);
17 $result = pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100));
40 pg_num_rows(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)));
41 pg_num_fields(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)));
49 …$result = pg_query_params($db, "INSERT INTO ".$table_name." VALUES (\$1, \$2);", array(9999, "A'BC…
54 pg_close($db);
H A D06copy.phpt10 $db = pg_connect($conn_str);
12 $rows = pg_copy_to($db, $table_name);
14 pg_query($db, "DELETE FROM $table_name");
16 pg_copy_from($db, $table_name, $rows);
/PHP-5.5/ext/sybase_ct/tests/
H A Dtest_close.phpt14 $db= sybase_connect_ex();
15 var_dump($db);
16 sybase_close($db);
17 var_dump($db);
18 var_dump(sybase_query('select getdate()', $db));

Completed in 53 milliseconds

12345678910>>...29