/PHP-7.3/ext/mysqli/tests/ |
H A D | bug76386.phpt | 24 $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 D | bug35103.phpt | 18 $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 D | bug34785.phpt | 14 public function __construct($link, $query) { 15 parent::__construct($link, $query); 21 public function __construct($link, $query) { 22 parent::__construct($link, $query);
|
H A D | mysqli_expire_password.phpt | 20 $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 $link->query("SET PASSWORD=PASSWORD('expiretest')"); 109 if ($res = $link->query("SELECT id FROM test WHERE id = 1")) 120 $link->query("SELECT id FROM test WHERE id = 1"); 121 if ($res = $link->query("SELECT id FROM test WHERE id = 1")) [all …]
|
H A D | bug77956.phpt | 16 if (!$link->query("DROP TABLE IF EXISTS test")) { 19 …if (!$link->query("CREATE TABLE test (dump1 INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine)… 24 if (!$link->query("SELECT 1 FROM DUAL")) 26 if (!$link->query("LOAD DATA LOCAL INFILE 'bug77956.data' INTO TABLE test")) { 41 if (!$link->query($link, 'DROP TABLE IF EXISTS test')) { 48 Warning: mysqli::query(): LOAD DATA LOCAL INFILE forbidden in %s on line %d
|
H A D | bug77597.phpt | 14 $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 D | mysqli_last_insert_id.phpt | 19 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 D | 067.phpt | 22 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 D | bug66124.phpt | 31 $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 D | mysqli_stmt_datatype_change.phpt | 23 $c1->query("use $db"); 24 $c2->query("use $db"); 25 $c1->query("drop table if exists type_change"); 26 $c1->query("create table type_change(a int, b char(10)) ENGINE = " . $engine); 27 $c1->query("insert into type_change values (1, 'one'), (2, 'two')"); 41 var_dump($c2->query("alter table type_change drop a"));
|
/PHP-7.3/ext/mbstring/tests/ |
H A D | mb_parse_str.phpt | 14 function test($query) { 17 mb_parse_str($query, $array); 21 mb_parse_str($query); 25 foreach ($queries as $query) { 26 test($query);
|
H A D | mb_parse_str02.phpt | 14 function test($query) { 18 mb_parse_str($query, $array); 23 mb_parse_str($query); 28 foreach ($queries as $query) { 29 test($query);
|
/PHP-7.3/ext/pdo/ |
H A D | pdo.php | 8 $x->query("create table test(name string, value string)"); 28 foreach ($x->query("select NAME, VALUE from test") as $row) { 40 foreach ($x->query("select NAME, VALUE from test", PDO_FETCH_COLUMN, 1) as $row) {
|
/PHP-7.3/Zend/tests/ |
H A D | bug31177.phpt | 7 public function query() { 12 return new DbGowRecordSet($this->query()); 16 new DbGowRecordSet($this->query());
|
/PHP-7.3/ext/interbase/tests/ |
H A D | 006.phpt | 182 /* prepare query */ 183 $query = ibase_prepare( 187 ibase_execute($query, $i); 192 ibase_free_query($query); 196 /* prepare query */ 197 $query = ibase_prepare("select * from test6 213 $res = ibase_execute($query, "5", 7.499); 217 ibase_free_query($query); 220 $query = ibase_prepare("execute procedure add1(?)"); 223 $res[] = ibase_execute($query,$i); [all …]
|
/PHP-7.3/ext/pdo/tests/ |
H A D | pdo_038.phpt | 22 $query = 'SELECT 1'; 26 $query .= ' FROM DUAL'; 29 $query .= ' FROM RDB$DATABASE'; 33 $stmt = $conn->prepare($query);
|
H A D | pdo.inc | 3 function set_sql($name, $query) 7 $GLOBALS['SQL'][$name] = $query;
|
/PHP-7.3/ext/pdo_firebird/tests/ |
H A D | bug_76452.phpt | 17 $query = $dbh->prepare("select * from test"); 18 $query->execute(); 19 var_dump($query->fetch());
|
/PHP-7.3/ext/pgsql/tests/ |
H A D | bug47199.phpt | 22 $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.3/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_stmt_closecursor.phpt | 22 $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 …]
|
H A D | bug79596.phpt | 18 $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 D | bug66141.phpt | 2 Bug #66141 (mysqlnd quote function is wrong with NO_BACKSLASH_ESCAPES after failed query) 18 $db->query('set session sql_mode="NO_BACKSLASH_ESCAPES"'); 24 $db->query('something that throws an exception'); 34 Warning: PDO::query(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in…
|
/PHP-7.3/ext/oci8/tests/ |
H A D | lob_018.phpt | 43 $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.3/ext/pdo_pgsql/tests/ |
H A D | bug62479.phpt | 52 $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);
|
/PHP-7.3/ext/pdo_pgsql/ |
H A D | pgsql_driver.c | 548 char *query; in PHP_METHOD() local 583 efree(query); in PHP_METHOD() 584 query = NULL; in PHP_METHOD() 619 if (query) { in PHP_METHOD() 620 efree(query); in PHP_METHOD() 657 char *query; in PHP_METHOD() local 694 efree(query); in PHP_METHOD() 756 char *query; in PHP_METHOD() local 793 efree(query); in PHP_METHOD() 851 char *query; in PHP_METHOD() local [all …]
|