In PHP, mysqli_query() runs one SQL statement on the connection and returns a mysqli_result for SELECT-style queries, true for successful non-result statements, or false on failure.
The default result mode stores (buffers) the full result so mysqli_num_rows() works immediately. Use MYSQLI_USE_RESULT for unbuffered streaming, or prepare/bind when the SQL includes user values.
Syntax
Call mysqli_query() with the values you need. Start with this line.
PHP
$result = mysqli_query($mysqli, "SELECT id, name FROM users");
Call
What it does
mysqli_query($mysqli, "SELECT 1")
Returns a mysqli_result for a SELECT.
mysqli_query($mysqli, "UPDATE t SET a = 1")
Returns true on success when there is no result set.
mysqli_query($mysqli, $sql, MYSQLI_USE_RESULT)
Returns an unbuffered result (advanced).
Only one statement per call — for semicolon batches use mysqli_multi_query(). For values from users, prefer mysqli_prepare() instead of gluing strings. query() is similar to real_query() plus store_result()/use_result() in one step.
Library declarations
PHP
mysqli_query(mysqli $mysql, string $query, int $result_mode = MYSQLI_STORE_RESULT): mysqli_result|bool
Parameters
Parameter
Description
mysql
Required. The open mysqli connection.
query
Required. A single SQL statement string.
result_mode
Optional. MYSQLI_STORE_RESULT (default), MYSQLI_USE_RESULT, or MYSQLI_ASYNC (mysqlnd).
Return Value
Return Value
Description
mysqli_result|bool
mysqli_result for successful SELECT/SHOW-style queries; true for successful INSERT/UPDATE/DELETE-style queries; false on failure.
PHP Examples
Example 1 — SELECT and Count Rows
Run a SELECT with the default stored mode and print the row count.
Use mysqli_insert_id() or mysqli_affected_rows() for details.
false would mean the statement failed.
Do not call mysqli_fetch_assoc() on true.
Example 3 — Prefer Prepare for User Values
Contrast unsafe string building with the prepare mindset.
PHP
<?php
$mysqli = mysqli_connect("localhost", "demo_user", "demo_pass", "app_db");
$name = "Ada"; // imagine this came from a form
// Better than: "SELECT ... WHERE name = '$name'"
$stmt = mysqli_prepare($mysqli, "SELECT id FROM users WHERE name = ?");
mysqli_stmt_bind_param($stmt, "s", $name);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
echo "Matches: ", mysqli_num_rows($result), PHP_EOL;
mysqli_stmt_close($stmt);
mysqli_close($mysqli);
Output
Matches: 1
How It Works
User-provided values belong in bound parameters.
prepare + bind replaces unsafe quoting in query strings.
query() remains great for fixed SQL without variables.
The sample finds one matching row.
Frequently Asked Questions
A mysqli_result for SELECT-style success, true for other successful statements, or false on failure.
query() runs one statement. multi_query() can run several semicolon-separated statements and needs a drain loop.
Whenever SQL includes values from users or outside input. Prepared statements avoid injection mistakes.
Unbuffered mode. Rows stream from the server; num_rows is unreliable until fetched, and the connection stays busy until finished.
query() is convenience: it runs the SQL and stores or uses the result for you. real_query() only sends SQL; you call store_result()/use_result() yourself.