/PHP-7.4/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_stmt_rowcount.phpt | 12 $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 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 | pecl_bug_5802.phpt | 13 $db = PDOTest::test_factory(__DIR__. '/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 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_subclass.phpt | 53 $db = new MyPDO(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS); 54 $db->exec('DROP TABLE IF EXISTS test'); 55 $db->exec('CREATE TABLE test(id INT)'); 56 $db->exec('INSERT INTO test(id) VALUES (1), (2)'); 57 $stmt = $db->query('SELECT * FROM test ORDER BY id ASC'); 60 $db->intercept_call(); 65 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 68 $db->exec('DROP TABLE IF EXISTS test'); 74 $db = MySQLPDOTest::factory(); 75 $db->exec('DROP TABLE IF EXISTS test');
|
H A D | pdo_mysql_attr_client_version.phpt | 8 $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);
|
/PHP-7.4/ext/pgsql/tests/ |
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
|
H A D | 06copy.phpt | 10 $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);
|
H A D | 21pg_get_notify.phpt | 11 $db = pg_connect($conn_str); 12 pg_query($db, 'LISTEN test_msg'); 13 pg_query($db, 'NOTIFY test_msg'); 15 $msg = pg_get_notify($db);
|
/PHP-7.4/ext/sqlite3/tests/ |
H A D | sqlite3_24_last_insert_rowid.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->lastInsertRowID()); 17 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')")); 18 var_dump($db->lastInsertRowID()); 21 var_dump($db->close());
|
H A D | sqlite3_39_toggleExtended.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; 21 $db->enableExtendedResultCodes(true); 22 $result = $db->query("INSERT INTO DOG VALUES (1, 'Annoying Dog', 1)"); 23 echo "Third (Extended) Error Code: " . $db->lastErrorCode() . PHP_EOL; 26 var_dump($db->close());
|
H A D | bug53463.phpt | 8 $db = new SQLite3(':memory:'); 10 $db->exec('CREATE TABLE test (whatever INTEGER)'); 11 $db->exec('INSERT INTO test (whatever) VALUES (1)'); 13 $result = $db->query('SELECT * FROM test'); 22 $db->close();
|
/PHP-7.4/ext/pdo_pgsql/tests/ |
H A D | bug70313.phpt | 13 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 16 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); 18 $stmt = $db->prepare(");"); 25 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true); 27 $stmt = $db->prepare(");");
|
H A D | copy_to.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(); 34 $db->commit(); 37 var_dump($db->pgsqlCopyToArray('test')); 39 var_dump($db->pgsqlCopyToArray('test',";","NULL")); 41 var_dump($db->pgsqlCopyToArray('test',";","NULL",'a,c')); 45 var_dump($db->pgsqlCopyToArray('test_error')); 53 var_dump($db->pgsqlCopyToFile('test',$filename)); [all …]
|
/PHP-7.4/ext/pdo_sqlite/tests/ |
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)');
|
H A D | pdo_sqlite_extendederror_attr.phpt | 9 $db = new PDO('sqlite::memory:'); 11 $db->exec("CREATE TABLE dog ( id INTEGER PRIMARY KEY, name TEXT, annoying INTEGER )"); 14 $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)"); 15 $errorInfo = $db->errorInfo(); 19 $result = $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)"); 20 $errorInfo = $db->errorInfo(); 27 $db->exec("CREATE TABLE dog ( id INTEGER PRIMARY KEY, name TEXT, annoying INTEGER )"); 30 $result = $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)"); 31 $errorInfo = $db->errorInfo(); 35 $result = $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)"); [all …]
|
/PHP-7.4/ext/pdo/tests/ |
H A D | pdo_033.phpt | 16 $db = PDOTest::factory(); 20 $quoted = $db->quote($unquoted); 24 @$db->exec("DROP TABLE test"); 26 $db->query("CREATE TABLE test (t char($len))"); 27 $db->query("INSERT INTO test (t) VALUES($quoted)"); 29 $stmt = $db->prepare('SELECT * from test'); 34 $db->exec("DROP TABLE test");
|
H A D | pdo_019.phpt | 15 $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 D | bug_71885.phpt | 17 $db = PDOTest::factory(); 18 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 20 $db->exec("CREATE TABLE test (a int)"); 25 $db->exec($sql); 31 $stmt = $db->prepare($sql); 37 if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') { 38 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 42 $stmt = $db->prepare($sql);
|
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.4/ext/mysqli/tests/ |
H A D | bug38710.phpt | 12 $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 D | mysqli_change_user_old.phpt | 9 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 11 $host, $user, $db, $port, $socket)); 23 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 25 $host, $user, $db, $port, $socket); 42 $host, $user, $db, $port, $socket); 54 if (true !== ($tmp = mysqli_change_user($link, $user, $passwd, $db))) 64 if ($tmp['dbname'] != $db) 78 $host, $user, $db, $port, $socket); 88 $host, $user, $db, $port, $socket); 92 (empty db = no db send with COM_CHANGE_USER) */ [all …]
|
/PHP-7.4/ext/dba/ |
H A D | config.m4 | 378 if test -f "$i/db5/db.h"; then 380 THIS_INCLUDE=$i/db5/db.h 384 THIS_INCLUDE=$i/db4/db.h 428 THIS_INCLUDE=$i/include/db.h 432 …PHP_DBA_DB_CHECK(4, db-5.3 db-5.1 db-5.0 db-4.8 db-4.7 db-4.6 db-4.5 db-4.4 db-4.3 db-4.2 db-4.1 d… 465 …PHP_DBA_DB_CHECK(3, db-3.3 db-3.2 db-3.1 db-3.0 db-3 db3 db, [(void)db_create((DB**)0, (DB_ENV*)0,… 478 THIS_INCLUDE=$i/db2/db.h 498 PHP_DBA_DB_CHECK(2, db-2 db2 db, [(void)db_appinit("", NULL, (DB_ENV*)0, 0)]) 520 for i in db$THIS_VERSION/db_185.h include/db$THIS_VERSION/db_185.h include/db/db_185.h; do 531 THIS_INCLUDE=$i/db1/db.h [all …]
|
/PHP-7.4/ext/pdo_oci/tests/ |
H A D | pdo_oci_templob_1.phpt | 26 $stmt= $db->prepare($clobquery1); 29 $stmt= $db->prepare($clobquery2); 32 $stmt= $db->prepare($clobquery3); 35 $stmt= $db->prepare($clobquery4); 38 $stmt= $db->prepare($clobquery5); 41 $stmt= $db->prepare($clobquery6); 44 $stmt= $db->prepare($clobquery7); 47 $stmt= $db->prepare($clobquery8); 50 $stmt= $db->prepare($clobquery9); 59 $stmt1 = $db->prepare($query1); [all …]
|
/PHP-7.4/ext/dba/tests/ |
H A D | bug71514.phpt | 12 $db = dba_open($filename, 'c', 'inifile'); 14 dba_insert('foo', 'value1', $db); 15 dba_replace('foo', 'value2', $db); 16 var_dump(dba_fetch('foo', $db)); 18 dba_close($db);
|