How to Efficiently Retrieve a Single Result from a MySQLi Database?

Retrieving a Single Result from Database with MySQLi

In database operations, it is often necessary to retrieve a single result from a larger dataset. In cases where you are only interested in a particular record, such as the first record or a specific row based on certain criteria, using a loop is unnecessary.

To fetch a single row from a database using MySQLi, the procedure is as follows:

Associative Array

If you need to retrieve the entire row as an associative array, where the column names are used as keys, the following code can be used:

$row = $result->fetch_assoc();

Single Value

If you only require a single value from the result, for example, the count of rows in a table, you can use:

// PHP >= 8.1
$value = $result->fetch_column();

// PHP < 8.1
$value = $result->fetch_row()[0] ?? false;

Examples

Retrieving a Single User by ID:

$query = "SELECT fullname, email FROM users WHERE>

Retrieving the Count of Users:

$query = "SELECT count(*) FROM users";
$count = $conn->query($query)->fetch_column();

// PHP < 8.1
$count = $conn->query($query)->fetch_row()[0];

By utilizing these techniques, you can efficiently retrieve single results from your database queries without the need for loops.

The above is the detailed content of How to Efficiently Retrieve a Single Result from a MySQLi Database?. For more information, please follow other related articles on the PHP Chinese website!