/php-src/ext/mysqli/tests/ |
H A D | bug79084.phpt | 25 $res = $link->query($sql); 33 $res = $link->query($sql);
|
H A D | bug_mysql_49406.phpt | 17 …$query = "SELECT CASE WHEN 0 THEN CAST('2009-12-03' AS DATE) ELSE CAST('2009-12-03' AS DATE) END… 19 if (!$res = $link->query($query)) 31 if (!$stmt = $link->prepare($query))
|
H A D | mysqli_stmt_bind_param_many_columns.phpt | 32 list($old_max_allowed_packet) = $link->query("SELECT @@max_allowed_packet")->fetch_row(); 33 if (!$link->query("SET GLOBAL max_allowed_packet=(2<<29)")) { 60 $link->query("CREATE TABLE test(" . implode(" , ", $str) . ") ENGINE=MyISAM"); 86 if (!$link->query("SET GLOBAL max_allowed_packet=$old_max_allowed_packet")) {
|
H A D | bug73462.phpt | 15 $result = $mysql_1->query("SHOW STATUS LIKE 'Connections'"); 31 $result = $mysql_3->query("SHOW STATUS LIKE 'Connections'");
|
H A D | mysqli_num_fields.phpt | 13 function func_test_mysqli_num_fields($link, $query, $expected, $offset, $test_free = false) { 15 if (!($res = mysqli_query($link, $query))) {
|
H A D | mysqli_fetch_array_oo.phpt | 14 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 5")) { 35 if (!$res = $mysqli->query("SELECT 1 AS a, 2 AS a, 3 AS c, 4 AS C, NULL AS d, true AS e")) { 36 printf("[010] Cannot run query, [%d] %s\n", $mysqli->errno, $$mysqli->error); 42 if (!$res = $mysqli->query("SELECT 1 AS a, 2 AS b, 3 AS c, 4 AS C")) { 43 printf("[012] Cannot run query, [%d] %s\n", 68 if (!$mysqli->query("DROP TABLE IF EXISTS test")) { 73 …if (!$mysqli->query($sql = sprintf("CREATE TABLE test(id INT NOT NULL, label %s, PRIMARY KEY(id)) … 79 if (!$mysqli->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, NULL)"))) { 85 … if (!$mysqli->query($sql = "INSERT INTO test(id, label) VALUES (1, '" . $sql_value . "')")) { 90 … if (!$mysqli->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, '%d')", $sql_value))) { [all …]
|
H A D | mysqli_stmt_param_count.phpt | 22 function func_test_mysqli_stmt_param_count($stmt, $query, $expected, $offset) { 24 if (!mysqli_stmt_prepare($stmt, $query)) {
|
/php-src/ext/pdo/tests/ |
H A D | pdo_033.phpt | 25 $db->query("CREATE TABLE test033 (t char($len))"); 26 $db->query("INSERT INTO test033 (t) VALUES($quoted)");
|
H A D | pdo_026.phpt | 46 function query($sql, ...$rest): PDOStatement|false 69 $stmt = $db->query('SELECT * FROM test026'); 88 PDODatabase::query()
|
H A D | pdo_029.phpt | 52 function query($sql, ...$rest): PDOStatement|false 77 $stmt = $db->query('SELECT * FROM test029'); 100 PDODatabase::query()
|
/php-src/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_connect_charset.phpt | 16 … $charset = $link->query("SHOW VARIABLES LIKE 'character_set_connection'")->fetchObject()->value; 25 …$conn_charset = $link->query("SHOW VARIABLES LIKE 'character_set_connection'")->fetchObject()->va…
|
H A D | pdo_mysql_attr_init_command.phpt | 32 $stmt = $db->query(sprintf('SELECT id FROM %s', $table)); 41 $db->query('DROP TABLE IF EXISTS pdo_mysql_attr_init_command');
|
H A D | bug_41997.phpt | 20 $stmt = $db->query("CALL {$procedure}()"); 26 $stmt = $db->query('SELECT 2 AS "two"');
|
H A D | pdo_mysql_attr_statement_class.phpt | 99 $stmt = $db->query("SELECT id, label FROM {$table} ORDER BY id ASC LIMIT 2"); 109 $stmt = $db->query("SELECT id, label FROM {$table} ORDER BY id ASC LIMIT 2"); 115 $stmt = $db->query("SELECT id, label FROM {$table} ORDER BY id ASC LIMIT 1"); 123 $stmt = $db->query("SELECT id, label FROM {$table} ORDER BY id ASC LIMIT 1"); 132 $db->query('DROP TABLE IF EXISTS pdo_mysql_attr_statement_class');
|
H A D | pdo_mysql_last_insert_id.phpt | 17 … printf("[001] No query has been run, lastInsertId() should return '0'/string got '%s'/%s\n", 31 $stmt = $db->query('SELECT id FROM test_pdo_mysql_last_insert_id LIMIT 1'); 61 $stmt = $db->query('SELECT LAST_INSERT_ID() AS _last_id'); 82 $stmt = $db->query('SELECT @@auto_increment_increment AS inc'); 89 $stmt = $db->query('SELECT LAST_INSERT_ID() AS _last_id');
|
H A D | bug41125.phpt | 31 foreach ($queries as $k => $query) { 32 $stmt = $db->prepare($query); 34 printf("[%d] Query: [[%s]]\n", $k + 1, $query); 72 foreach ($queries as $k => $query) { 73 $stmt = $db->prepare($query); 77 printf("[%d] Query: [[%s]]\n", $k + 1, $query);
|
H A D | bug_pecl_7976.phpt | 20 $stmt = $db->query("CALL {$procedure}()"); 24 $stmt = $db->query("CALL {$procedure}()");
|
/php-src/ext/phar/tests/ |
H A D | create_path_error.phpt | 16 file_put_contents($pname . '/a.php?', "query"); 17 file_put_contents($pname . '/b.php?bla', "query"); 66 string(5) "query" 67 string(5) "query"
|
/php-src/ext/pdo_pgsql/tests/ |
H A D | pdopgsql_002.phpt | 25 foreach ($db->query('SELECT name FROM pdopgsql_002') as $row) { 35 $pdo->query("DROP TABLE IF EXISTS pdopgsql_002");
|
/php-src/ext/pdo_firebird/tests/ |
H A D | transaction_access_mode.phpt | 54 $dbh->query("CREATE TABLE {$table} (val INT)"); 63 $dbh->query("INSERT INTO {$table} VALUES (12)"); 64 $r = $dbh->query("SELECT * FROM {$table}"); 77 $dbh->query("INSERT INTO {$table} VALUES (19)"); 81 $r = $dbh->query("SELECT * FROM {$table}");
|
H A D | rowCount.phpt | 21 $query = "SELECT * FROM test_rowcount WHERE A = ?"; 23 $stmt = $dbh->prepare($query);
|
H A D | bug_47415.phpt | 20 $query = "SELECT idx, txt FROM test47415 ORDER by idx"; 22 $stmt = $dbh->prepare($query);
|
/php-src/ext/sqlite3/tests/ |
H A D | sqlite3_trampoline_create_collation.phpt | 29 $defaultSort = $db->query('SELECT s FROM t ORDER BY s'); //memcmp() sort 30 $naturalSort = $db->query('SELECT s FROM t ORDER BY s COLLATE NAT'); //strnatcmp() sort
|
/php-src/ext/odbc/tests/ |
H A D | bug73448.phpt | 21 "/* another erroneous query */ SELECT * FROM zwiebelfleisch", 49 string(58) "/* another erroneous query */ SELECT * FROM zwiebelfleisch"
|
/php-src/ext/pdo_odbc/tests/ |
H A D | autocommit.phpt | 27 $db->query("INSERT INTO {$table} (id, name) VALUES (1, 'test')"); 32 $r = $db->query("SELECT * FROM {$table}");
|