Home
last modified time | relevance | path

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

12345678910>>...18

/PHP-7.0/ext/interbase/tests/
H A D006.phpt182 /* 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.0/ext/mysqli/tests/
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_stmt_datatype_change.phpt23 $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"));
H A Dbug68077.phpt30 if (!$link->query("DROP TABLE IF EXISTS test")) {
34 …if (!$link->query("CREATE TABLE test (dump1 INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine)…
41 if (!$link->query("SELECT 1 FROM DUAL"))
44 …if (!$link->query("LOAD DATA LOCAL INFILE '" . str_replace("\\", "/", __DIR__) . "/bug53503.data'…
52 if (!$link->query("LOAD DATA LOCAL INFILE '" . __DIR__ . "/bug53503.data' INTO TABLE test")) {
69 if (!$link->query($link, 'DROP TABLE IF EXISTS test')) {
H A Dbug33491.phpt15 public function query_single($query) {
16 $result = parent::query($query);
H A Dbug36745.phpt15 $mysql->query("DROP TABLE IF EXISTS litest");
16 $mysql->query("CREATE TABLE litest (a VARCHAR(20))");
18 $mysql->query("LOAD DATA LOCAL INFILE 'filenotfound' INTO TABLE litest");
/PHP-7.0/ext/pdo/tests/
H A Dpdo.inc3 function set_sql($name, $query)
7 $GLOBALS['SQL'][$name] = $query;
H A Dbug_69356.phpt2 PDO Common: Bug #69356 (PDOStatement::debugDumpParams() truncates query)
18 $stmt = $db->query("
20 …query in use, the number of parameters used (Params), the list of parameters, with their name, typ…
32 …query in use, the number of parameters used (Params), the list of parameters, with their name, typ…
H A Dpdo_034.phpt23 var_dump($db->query("SELECT a,b FROM test")->fetch(PDO::FETCH_KEY_PAIR));
24 var_dump($db->query("SELECT a,b FROM test")->fetchAll(PDO::FETCH_KEY_PAIR));
25 var_dump($db->query("SELECT * FROM test")->fetch(PDO::FETCH_KEY_PAIR));
26 var_dump($db->query("SELECT a,a FROM test")->fetchAll(PDO::FETCH_KEY_PAIR));
/PHP-7.0/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.0/ext/pdo_mysql/tests/
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 …]
H A Dbug66141.phpt2 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…
H A Dpdo_mysql_fetch_both.phpt15 function fetch($offset, &$db, $query, $expect = null) {
18 $stmt = $db->query('SELECT 1');
21 $stmt = $db->query('SELECT 1');
24 $stmt = $db->query('SELECT 1');
H A Dpdo_mysql_errorcode.phpt30 or PDO->query() and invoke an error on the statement handle,
38 $stmt = $db->query('SELECT id, label FROM test');
50 @$stmt = $db->query('SELECT id, label FROM unknown');
54 $stmt = $db->query('SELECT id, label FROM test');
59 @$db->query('SELECT id, label FROM unknown');
H A Dlast_insert_id.phpt15 print_r($db->query("CREATE TABLE test (id int auto_increment primary key, num int)"));
17 print_r($db->query("INSERT INTO test (id, num) VALUES (23, 42)"));
19 print_r($db->query("INSERT INTO test (num) VALUES (451)"));
/PHP-7.0/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);
H A Dbug37220.phpt26 $query = "UPDATE bug37220_tab
29 $stmt = oci_parse ($c, $query);
39 $query = "select * from bug37220_tab";
40 $stmt = oci_parse ($c, $query);
/PHP-7.0/ext/pdo_pgsql/tests/
H A Dbug62479.phpt51 $pdo->query($sql);
53 $result = $testConn->query($testQuery)->fetch();
58 $pdo->query($dropUser);
62 $pdo->query($sql);
65 $result = $testConn->query($testQuery)->fetch();
70 $pdo->query($dropUser);
/PHP-7.0/ext/pdo_pgsql/
H A Dpgsql_driver.c569 char *query; in PHP_METHOD() local
604 efree(query); in PHP_METHOD()
605 query = NULL; in PHP_METHOD()
640 if (query) { in PHP_METHOD()
641 efree(query); in PHP_METHOD()
678 char *query; in PHP_METHOD() local
715 efree(query); in PHP_METHOD()
777 char *query; in PHP_METHOD() local
814 efree(query); in PHP_METHOD()
872 char *query; in PHP_METHOD() local
[all …]
/PHP-7.0/ext/pdo_oci/tests/
H A Dbug57702.phpt18 $query = "begin execute immediate 'drop table bug57702'; exception when others then if sqlcode <> -…
19 $stmt = $db->prepare($query);
22 $query = "create table bug57702 (id number, data1 blob, data2 blob)";
23 $stmt = $db->prepare($query);
65 foreach($db->query("select data1 as d1, data2 as d2 from bug57702 order by id") as $row) {
91 foreach($db->query("select data1 as d4_1, data2 as d4_2 from bug57702 order by id") as $row) {
114 foreach($db->query("select data1 as d4_1, data2 as d4_2 from bug57702 order by id") as $row) {
133 foreach($db->query("select data1 as d4_1, data2 as d4_2 from bug57702 order by id") as $row) {
142 $query = "drop table bug57702";
143 $stmt = $db->prepare($query);
/PHP-7.0/ext/sqlite3/tests/
H A Dsqlite3_enable_exceptions.phpt14 $db->query("SELECT * FROM non_existent_table");
19 $db->query("SELECT * FROM non_existent_table");
30 Warning: SQLite3::query(): no such table: non_existent_table in %s on line %d
/PHP-7.0/ext/dom/tests/
H A Dbug69373.phpt2 Bug #69373 References to deleted XPath query results
9 $all = $xpath->query('//*');
/PHP-7.0/ext/mysqli/
H A Dmysqli_report.c57 void php_mysqli_report_index(const char *query, unsigned int status) { in php_mysqli_report_index() argument
67 php_mysqli_throw_sql_exception("00000", 0, "%s used in query/prepared statement %s", index, query); in php_mysqli_report_index()
/PHP-7.0/ext/pdo_sqlite/tests/
H A Dbug46139.phpt20 $stmt = $db->query("SELECT 'foo' test, 1");
25 $stmt = $db->query("SELECT 'foo' test, 1");
30 $stmt = $db->query("SELECT 'foo' test, 1");

Completed in 41 milliseconds

12345678910>>...18