Home
last modified time | relevance | path

Searched refs:query (Results 51 – 75 of 469) sorted by relevance

12345678910>>...19

/PHP-7.4/ext/mysqli/tests/
H A Dbug52082.phpt17 var_dump($link->query("show variables like 'character_set_client'")->fetch_row());
18 var_dump($link->query("show variables like 'character_set_connection'")->fetch_row());
20 var_dump($link->query("show variables like 'character_set_client'")->fetch_row());
21 var_dump($link->query("show variables like 'character_set_connection'")->fetch_row());
H A Dmysqli_expire_password.phpt20 $result = $link->query("select @@disconnect_on_expired_password");
50 if (!$link->query("DROP TABLE IF EXISTS test") ||
51 !$link->query("CREATE TABLE test (id INT)") || !$link->query("INSERT INTO test(id) VALUES (1)"))
73 $link->query("SELECT id FROM test WHERE id = 1");
84 $link->query("SELECT id FROM test WHERE id = 1");
95 $link->query("SELECT id FROM test WHERE id = 1");
107 if (!$link->query("SET PASSWORD='expiretest'")) {
108 $link->query("SET PASSWORD=PASSWORD('expiretest')");
111 if ($res = $link->query("SELECT id FROM test WHERE id = 1"))
122 $link->query("SELECT id FROM test WHERE id = 1");
[all …]
H A Dbug34785.phpt14 public function __construct($link, $query) {
15 parent::__construct($link, $query);
21 public function __construct($link, $query) {
22 parent::__construct($link, $query);
H A Dbug35103.phpt18 $mysql->query("DROP TABLE IF EXISTS test_bint");
19 $mysql->query("CREATE TABLE test_bint (a bigint(20) default NULL) ENGINE=MYISAM");
20 …$mysql->query("INSERT INTO test_bint VALUES (9223372036854775807),(-9223372036854775808),(-2147483…
22 $mysql->query("DROP TABLE IF EXISTS test_buint");
23 $mysql->query("CREATE TABLE test_buint (a bigint(20) unsigned default NULL)");
24 …$mysql->query("INSERT INTO test_buint VALUES (18446744073709551615),(9223372036854775807),(9223372…
H A Dbug76386.phpt24 $link->query('DROP TABLE IF EXISTS ts_test;');
25 $link->query(
34 $link->query(
54 $link->query('DROP TABLE IF EXISTS t_test;');
55 $link->query(
61 $link->query(
65 $link->query('INSERT INTO t_test VALUES ();');
101 $link->query('DROP TABLE ts_test;');
102 $link->query('DROP TABLE t_test;');
H A Dbug77597.phpt14 $mysqli->query('DROP TABLE IF EXISTS a');
15 $mysqli->query('CREATE TABLE a (b int)');
16 $mysqli->query('INSERT INTO a VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9)');
H A Dmysqli_last_insert_id.phpt19 if (!($res = $link->query("SELECT LAST_INSERT_ID() AS _id"))) {
33 if (!$link->query("DROP TABLE IF EXISTS test") ||
35 !$link->query("INSERT INTO test (id, label) VALUES (null, 'a')")) {
49 if (!($res = $link->query("SELECT 1 FROM DUAL")))
65 if ($link->query("INSERT INTO test (id, label) VALUES (null, null)")) {
80 if (!$link->query("UPDATE test SET id=LAST_INSERT_ID(id+1)"))
95 if (!$link->query("SET @myvar=1"))
108 if (!$link->query("INSERT INTO test(id, label) VALUES (LAST_INSERT_ID(id + 1), 'b')"))
116 if (!$link->query("INSERT INTO test(label) VALUES ('c')"))
124 if (!($res = $link->query("SELECT id, label FROM test ORDER BY id ASC")))
[all …]
H A D067.phpt22 function open_cursor($mysql, $query) {
23 if (!is_object($stmt = $mysql->prepare($query))) {
25 $query, $mysql->errno, $mysql->error);
44 $mysql->query("DROP TABLE IF EXISTS cursor$i");
45 $mysql->query("CREATE TABLE cursor$i (a int not null) ENGINE=" . $engine);
46 $mysql->query("INSERT INTO cursor$i VALUES (1),(2),(3),(4),(5),(6)");
H A Dbug66124.phpt31 $link->query($table_drop);
32 $link->query($table_create);
51 $result = $link->query($table_select);
64 $link->query($table_drop);
65 $link->query($table_create);
80 $result = $link->query($table_select);
H A Dmysqli_next_result_error.phpt2 Error in multi query
30 $mysqli->query("DROP PROCEDURE IF EXISTS p");
31 $mysqli->query('CREATE PROCEDURE p() READS SQL DATA BEGIN SELECT 1; SELECT foobar FROM table_that_d…
47 $mysqli->query("DROP PROCEDURE IF EXISTS p");
H A Dbug77956.phpt26 if (!$link->query("DROP TABLE IF EXISTS test")) {
29 …if (!$link->query("CREATE TABLE test (dump1 INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine)…
34 if (!$link->query("SELECT 1 FROM DUAL"))
36 if (!$link->query("LOAD DATA LOCAL INFILE 'bug77956.data' INTO TABLE test")) {
51 if (!$link->query($link, 'DROP TABLE IF EXISTS test')) {
58 Warning: mysqli::query(): LOAD DATA LOCAL INFILE forbidden in %s on line %d
/PHP-7.4/ext/mbstring/tests/
H A Dmb_parse_str.phpt14 function test($query) {
17 mb_parse_str($query, $array);
21 mb_parse_str($query);
25 foreach ($queries as $query) {
26 test($query);
H A Dmb_parse_str02.phpt14 function test($query) {
18 mb_parse_str($query, $array);
23 mb_parse_str($query);
28 foreach ($queries as $query) {
29 test($query);
/PHP-7.4/Zend/tests/
H A Dbug31177.phpt7 public function query() {
12 return new DbGowRecordSet($this->query());
16 new DbGowRecordSet($this->query());
/PHP-7.4/ext/pdo_mysql/tests/
H A Dbug76815.phpt16 $pdo->query('DROP FUNCTION IF EXISTS tst');
17 $pdo->query('DROP PROCEDURE IF EXISTS tst2');
18 $pdo->query('CREATE FUNCTION tst() RETURNS VARCHAR(5) DETERMINISTIC BEGIN RETURN \'x12345\'; END');
19 $pdo->query('CREATE PROCEDURE tst2() BEGIN SELECT tst(); END');
H A Dbug79596.phpt18 $pdo->query('CREATE TABLE bug79596 (broken FLOAT(2,1))');
19 $pdo->query('INSERT INTO bug79596 VALUES(4.9)');
20 var_dump($pdo->query('SELECT broken FROM bug79596')->fetchColumn(0));
H A Dpdo_mysql_stmt_closecursor.phpt22 $stmt1 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
23 // query() shall fail!
24 $stmt2 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
29 $stmt1 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
33 $stmt1 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
56 $stmt1 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
58 $stmt2 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
61 $stmt1 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
157 …query(): SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered querie…
162 …query(): SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered querie…
[all …]
/PHP-7.4/ext/pdo/tests/
H A Dpdo.inc3 function set_sql($name, $query)
7 $GLOBALS['SQL'][$name] = $query;
H A Dpdo_038.phpt22 $query = 'SELECT 1';
26 $query .= ' FROM DUAL';
29 $query .= ' FROM RDB$DATABASE';
33 $stmt = $conn->prepare($query);
/PHP-7.4/ext/pdo_firebird/tests/
H A Dbug_76452.phpt17 $query = $dbh->prepare("select * from test");
18 $query->execute();
19 var_dump($query->fetch());
/PHP-7.4/ext/pgsql/tests/
H A Dbug47199.phpt22 $query = pg_delete($dbh, $tbl_name, array('null_field' => NULL,'not_null_field' => 2), PGSQL_DML_ST…
24 echo $query, "\n";
26 $query = pg_update($dbh, $tbl_name, array('null_field' => NULL, 'not_null_field' => 0), array('not_…
28 echo $query, "\n";
/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)");
17 $result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
30 Warning: SQLite3::query(): Unable to execute statement: UNIQUE constraint failed: dog.id in %s on l…
H A Dexception_from_toString.phpt33 $query = $db->query("SELECT * FROM t");
34 while ($row = $query->fetchArray(SQLITE3_ASSOC)) {
/PHP-7.4/ext/oci8/tests/
H A Dlob_018.phpt43 $query = 'select * from lob_018_tab order by mykey asc';
44 $statement = oci_parse ($c, $query);
54 $query = 'select * from lob_018_tab order by mykey desc';
55 $statement = oci_parse ($c, $query);
74 $query = 'select * from lob_018_tab where mykey = 3';
75 $statement = oci_parse ($c, $query);
/PHP-7.4/ext/pdo_pgsql/tests/
H A Dbug62479.phpt52 $pdo->query($sql);
54 $result = $testConn->query($testQuery)->fetch();
59 $pdo->query($dropUser);
63 $pdo->query($sql);
66 $result = $testConn->query($testQuery)->fetch();
71 $pdo->query($dropUser);

Completed in 29 milliseconds

12345678910>>...19