Home
last modified time | relevance | path

Searched refs:query (Results 251 – 275 of 576) sorted by relevance

1...<<11121314151617181920>>...24

/php-src/ext/mysqli/tests/
H A Dbug79084.phpt25 $res = $link->query($sql);
33 $res = $link->query($sql);
H A Dbug_mysql_49406.phpt17 …$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 Dmysqli_stmt_bind_param_many_columns.phpt32 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 Dbug73462.phpt15 $result = $mysql_1->query("SHOW STATUS LIKE 'Connections'");
31 $result = $mysql_3->query("SHOW STATUS LIKE 'Connections'");
H A Dmysqli_num_fields.phpt13 function func_test_mysqli_num_fields($link, $query, $expected, $offset, $test_free = false) {
15 if (!($res = mysqli_query($link, $query))) {
H A Dmysqli_fetch_array_oo.phpt14 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 Dmysqli_stmt_param_count.phpt22 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 Dpdo_033.phpt25 $db->query("CREATE TABLE test033 (t char($len))");
26 $db->query("INSERT INTO test033 (t) VALUES($quoted)");
H A Dpdo_026.phpt46 function query($sql, ...$rest): PDOStatement|false
69 $stmt = $db->query('SELECT * FROM test026');
88 PDODatabase::query()
H A Dpdo_029.phpt52 function query($sql, ...$rest): PDOStatement|false
77 $stmt = $db->query('SELECT * FROM test029');
100 PDODatabase::query()
/php-src/ext/pdo_mysql/tests/
H A Dpdo_mysql_connect_charset.phpt16 … $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 Dpdo_mysql_attr_init_command.phpt32 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
41 $db->query('DROP TABLE IF EXISTS pdo_mysql_attr_init_command');
H A Dbug_41997.phpt20 $stmt = $db->query("CALL {$procedure}()");
26 $stmt = $db->query('SELECT 2 AS "two"');
H A Dpdo_mysql_attr_statement_class.phpt99 $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 Dpdo_mysql_last_insert_id.phpt17 … 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 Dbug41125.phpt31 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 Dbug_pecl_7976.phpt20 $stmt = $db->query("CALL {$procedure}()");
24 $stmt = $db->query("CALL {$procedure}()");
/php-src/ext/phar/tests/
H A Dcreate_path_error.phpt16 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 Dpdopgsql_002.phpt25 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 Dtransaction_access_mode.phpt54 $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 DrowCount.phpt21 $query = "SELECT * FROM test_rowcount WHERE A = ?";
23 $stmt = $dbh->prepare($query);
H A Dbug_47415.phpt20 $query = "SELECT idx, txt FROM test47415 ORDER by idx";
22 $stmt = $dbh->prepare($query);
/php-src/ext/sqlite3/tests/
H A Dsqlite3_trampoline_create_collation.phpt29 $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 Dbug73448.phpt21 "/* another erroneous query */ SELECT * FROM zwiebelfleisch",
49 string(58) "/* another erroneous query */ SELECT * FROM zwiebelfleisch"
/php-src/ext/pdo_odbc/tests/
H A Dautocommit.phpt27 $db->query("INSERT INTO {$table} (id, name) VALUES (1, 'test')");
32 $r = $db->query("SELECT * FROM {$table}");

Completed in 28 milliseconds

1...<<11121314151617181920>>...24