How can PHP developers optimize SQL queries to improve performance, such as using COUNT() instead of fetching all rows?

PHP developers can optimize SQL queries by using aggregate functions like COUNT() instead of fetching all rows when only the count of rows is needed. This can significantly improve performance by reducing the amount of data transferred between the database and the PHP script. By using COUNT() directly in the SQL query, developers can avoid unnecessary data processing and improve the efficiency of their code.

// Example of optimizing SQL query using COUNT()

// Original query fetching all rows
$query = "SELECT * FROM users";
$result = mysqli_query($connection, $query);
$row_count = mysqli_num_rows($result);

// Optimized query using COUNT()
$query = "SELECT COUNT(*) as total_users FROM users";
$result = mysqli_query($connection, $query);
$data = mysqli_fetch_assoc($result);
$total_users = $data['total_users'];