Home
last modified time | relevance | path

Searched refs:db (Results 151 – 175 of 777) sorted by relevance

12345678910>>...32

/PHP-7.4/ext/pdo/tests/
H A Dbug_43139.phpt15 $db = PDOTest::factory();
17 $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
18 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
21 if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'oci') {
23 } else if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'firebird') {
27 var_dump($db->query("select 0 as abc, 1 as xyz, 2 as def $from")->fetchAll(PDO::FETCH_GROUP));
H A Dpdo_002.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')");
22 $stmt = $db->prepare('SELECT * from test');
H A Dbug_52098.phpt15 $db = PDOTest::factory();
17 @$db->exec("DROP TABLE test");
18 $db->exec("CREATE TABLE test (x int)");
19 $db->exec("INSERT INTO test VALUES (1)");
31 $derived = $db->prepare('SELECT * FROM test', array(PDO::ATTR_STATEMENT_CLASS=>array('MyStatement')…
40 $db->setAttribute(PDO::ATTR_STATEMENT_CLASS, array('MyStatement'));
41 $r = $db->query('SELECT * FROM test');
52 $db->exec("DROP TABLE test");
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");
H A Dpdo_001.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')");
22 $stmt = $db->prepare('SELECT * from test');
H A Dpdo_008.phpt15 $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 val, id from test');
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_44173.phpt15 $db = PDOTest::factory();
17 $db->exec("CREATE TABLE test (x int)");
18 $db->exec("INSERT INTO test VALUES (1)");
22 $stmt = $db->query();
27 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_LAZY, 0, 0);
32 $stmt = $db->query("SELECT * FROM test", 'abc');
37 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS, 0, 0, 0);
42 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_INTO);
47 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_COLUMN);
52 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS);
/PHP-7.4/ext/pdo_pgsql/tests/
H A Dbug71885.phpt14 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
15 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
16 $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_NUM);
19 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, $emulate);
22 $stmt = $db->prepare('select ?- lseg \'((-1,0),(1,0))\'');
28 $stmt = $db->prepare('select ??- lseg \'((-1,0),(1,0))\'');
H A Dlarge_objects.phpt13 $db = PDOTest::test_factory(__DIR__ . '/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-7.4/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_open_flags.phpt8 $filename = __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_open_flags.db";
11 $db = new PDO('sqlite:' . $filename, null, null, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
13 var_dump($db->exec('CREATE TABLE test1 (id INT);'));
15 $db = new PDO('sqlite:' . $filename, null, null, [PDO::SQLITE_ATTR_OPEN_FLAGS => PDO::SQLITE_OPEN_R…
17 var_dump($db->exec('CREATE TABLE test2 (id INT);'));
21 $filename = __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_open_flags.db";
/PHP-7.4/ext/pdo_odbc/tests/
H A Dbug80783.phpt12 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
13 $db->exec("CREATE TABLE bug80783 (name IMAGE)");
16 $db->exec("INSERT INTO bug80783 VALUES('$string')");
18 $stmt = $db->prepare("SELECT name FROM bug80783");
28 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
29 $db->exec("DROP TABLE bug80783");
H A Dbug80783a.phpt12 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
13 $db->exec("CREATE TABLE bug80783a (name NVARCHAR(MAX))");
16 $db->exec("INSERT INTO bug80783a VALUES('$string')");
18 $stmt = $db->prepare("SELECT name FROM bug80783a");
29 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
30 $db->exec("DROP TABLE bug80783a");
/PHP-7.4/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);
/PHP-7.4/ext/sqlite3/tests/
H A Dsqlite3_38_extended_error.phpt10 $db->query("CREATE TABLE dog ( id INTEGER PRIMARY KEY, name TEXT, annoying INTEGER )");
13 $result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
14 echo "First Error Code: " . $db->lastErrorCode() . PHP_EOL;
17 $result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
18 echo "Second Error Code: " . $db->lastErrorCode() . PHP_EOL;
19 echo "Second Extended Error Code: " . $db->lastExtendedErrorCode() . PHP_EOL;
22 var_dump($db->close());
H A Dsqlite3_01_open-mb.phpt8 $db_file = __DIR__ . DIRECTORY_SEPARATOR . '私はガラスを食べられます.db';
9 $db = new SQLite3($db_file);
12 var_dump($db);
13 var_dump($db->close());
H A Dsqlite3_18_changes.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->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
19 var_dump($db->exec("UPDATE test SET id = 'c'"));
22 var_dump($db->changes());
25 var_dump($db->close());
H A Dsqlite3_36_create_collation.phpt10 $db->createCollation('NAT', 'strnatcmp');
12 $db->exec('CREATE TABLE t (s varchar(4))');
14 $stmt = $db->prepare('INSERT INTO t VALUES (?)');
20 $defaultSort = $db->query('SELECT s FROM t ORDER BY s'); //memcmp() sort
21 $naturalSort = $db->query('SELECT s FROM t ORDER BY s COLLATE NAT'); //strnatcmp() sort
33 $db->close();
/PHP-7.4/ext/pdo_mysql/tests/
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 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 …]
/PHP-7.4/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-7.4/ext/mysqli/tests/
H A Dmysqli_change_user.phpt33 $host, $user, $db, $port, $socket);
40 $host, $user, $db, $port, $socket);
48 $host, $user, $db, $port, $socket);
60 if (true !== ($tmp = mysqli_change_user($link, $user, $passwd, $db)))
70 if ($tmp['dbname'] != $db)
80 $host, $user, $db, $port, $socket);
90 $host, $user, $db, $port, $socket);
94 (empty db = no db send with COM_CHANGE_USER) */
113 $host, $user, $db, $port, $socket);
125 if (true !== ($tmp = mysqli_change_user($link, $user, $passwd, $db)))
[all …]
H A Dbug77935.phpt13 $db = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
14 $db->query('DROP PROCEDURE IF EXISTS testSp');
15 $db->query(<<<'SQL'
26 $stmt = $db->prepare("CALL testSp()");
/PHP-7.4/ext/pdo_dblib/tests/
H A Dbug_47588.phpt12 $db->query('CREATE TABLE "Test Table" ("My Field" int, "Another Field" varchar(32) not null default…
13 $db->query('INSERT INTO "Test Table" ("My Field") values(1)');
14 $db->query('INSERT INTO "Test Table" ("My Field") values(2)');
15 $db->query('INSERT INTO "Test Table" ("My Field") values(3)');
16 $rs = $db->query('SELECT * FROM "Test Table"');
18 $db->query('DROP TABLE "Test Table"');
H A Dbug_69592.phpt17 var_dump($db->getAttribute(PDO::DBLIB_ATTR_SKIP_EMPTY_ROWSETS));
19 $stmt = $db->query($sql);
26 $db->setAttribute(PDO::DBLIB_ATTR_SKIP_EMPTY_ROWSETS, true);
27 var_dump($db->getAttribute(PDO::DBLIB_ATTR_SKIP_EMPTY_ROWSETS));
29 $stmt = $db->query($sql);
34 var_dump($db->getAttribute(PDO::DBLIB_ATTR_SKIP_EMPTY_ROWSETS));

Completed in 39 milliseconds

12345678910>>...32