Oracle 5.0, Reference Manual

Page: 2424 / 3232

MySQL Improved Extension (
Mysqli
)
2404
•
mysqlnd
on Windows returns an error code 2006. This error message means
“server has gone away”.
•
libmysqlclient
on all platforms returns an error code 2006. This error
message means “server has gone away”.
Parameters
link
Procedural style only: A link identifier returned by
mysqli_connect
or
mysqli_init
query
The query string.
Data inside the query should be properly escaped .
resultmode
Either the constant
MYSQLI_USE_RESULT
or
MYSQLI_STORE_RESULT
depending on the desired behavior. By
default,
MYSQLI_STORE_RESULT
is used.
If you use
MYSQLI_USE_RESULT
all subsequent calls will
return error
Commands out of sync
unless you call
mysqli_free_result
With
MYSQLI_ASYNC
(available with mysqlnd), it is possible to
perform query asynchronously.
mysqli_poll
is then used to get
results from such queries.
Return Values
Returns
FALSE
on failure. For successful
SELECT, SHOW, DESCRIBE
or
EXPLAIN
queries
mysqli_query
will return a
mysqli_result
object. For other successful queries
mysqli_query
will return
TRUE
.
Changelog
Version Description
5.3.0 Added the ability of async queries.
Examples
Example 20.137.
mysqli::query
example
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if ($mysqli->connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}
/* Create table doesn't return a resultset */
if ($mysqli->query("CREATE TEMPORARY TABLE myCity LIKE City") === TRUE) {
printf("Table myCity successfully created.\n");
}
/* Select queries return a resultset */
if ($result = $mysqli->query("SELECT Name FROM City LIMIT 10")) {
printf("Select returned %d rows.\n", $result->num_rows);