/PHP-7.4/ext/pdo/tests/ |
H A D | bug_43139.phpt | 15 $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 D | pdo_002.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')"); 22 $stmt = $db->prepare('SELECT * from test');
|
H A D | bug_52098.phpt | 15 $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 D | bug_39656.phpt | 16 $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 D | pdo_001.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')"); 22 $stmt = $db->prepare('SELECT * from test');
|
H A D | pdo_008.phpt | 15 $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 D | pdo_010.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), 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 D | bug_44173.phpt | 15 $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 D | bug71885.phpt | 14 $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 D | large_objects.phpt | 13 $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 D | pdo_sqlite_open_flags.phpt | 8 $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 D | bug80783.phpt | 12 $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 D | bug80783a.phpt | 12 $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 D | 23sync_query_params.phpt | 13 $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 D | sqlite3_38_extended_error.phpt | 10 $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 D | sqlite3_01_open-mb.phpt | 8 $db_file = __DIR__ . DIRECTORY_SEPARATOR . '私はガラスを食べられます.db'; 9 $db = new SQLite3($db_file); 12 var_dump($db); 13 var_dump($db->close());
|
H A D | sqlite3_18_changes.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 var_dump($db->exec("UPDATE test SET id = 'c'")); 22 var_dump($db->changes()); 25 var_dump($db->close());
|
H A D | sqlite3_36_create_collation.phpt | 10 $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 D | pdo_mysql_prepare_native_mixed_style.phpt | 8 $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 D | pdo_mysql_attr_statement_class.phpt | 8 $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 D | bug46274_2.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, 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 D | mysqli_change_user.phpt | 33 $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 D | bug77935.phpt | 13 $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 D | bug_47588.phpt | 12 $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 D | bug_69592.phpt | 17 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));
|