Home
last modified time | relevance | path

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

12345678910>>...18

/PHP-7.1/ext/pdo/
H A Dpdo.php8 $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.1/Zend/tests/
H A Dbug31177.phpt7 public function query() {
12 return new DbGowRecordSet($this->query());
16 new DbGowRecordSet($this->query());
/PHP-7.1/ext/mysqli/tests/
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 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 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 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 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 Dbug33491.phpt15 public function query_single($query) {
16 $result = parent::query($query);
H A Dbug74595.phpt10 $method = $class->getMethod('query');
18 string(5) "query"
/PHP-7.1/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.1/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…
/PHP-7.1/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.1/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');
/PHP-7.1/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);
/PHP-7.1/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.1/ext/pdo_pgsql/
H A Dpgsql_driver.c553 char *query; in PHP_METHOD() local
588 efree(query); in PHP_METHOD()
589 query = NULL; in PHP_METHOD()
624 if (query) { in PHP_METHOD()
625 efree(query); in PHP_METHOD()
662 char *query; in PHP_METHOD() local
699 efree(query); in PHP_METHOD()
761 char *query; in PHP_METHOD() local
798 efree(query); in PHP_METHOD()
856 char *query; in PHP_METHOD() local
[all …]
/PHP-7.1/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.1/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.1/ext/dom/tests/
H A Dbug69373.phpt2 Bug #69373 References to deleted XPath query results
9 $all = $xpath->query('//*');
/PHP-7.1/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()

Completed in 26 milliseconds

12345678910>>...18