What are common pitfalls when storing SQL query results in PHP arrays?

One common pitfall when storing SQL query results in PHP arrays is not properly handling errors or empty results. To solve this issue, you should check if the query was successful and if any rows were returned before trying to store the results in an array. 

// Execute SQL query
$query = "SELECT * FROM table";
$result = mysqli_query($connection, $query);

// Check if query was successful
if ($result) {
    // Check if any rows were returned
    if (mysqli_num_rows($result) > 0) {
        // Store results in an array
        $data = mysqli_fetch_all($result, MYSQLI_ASSOC);
    } else {
        echo "No results found.";
    }
} else {
    echo "Error executing query: " . mysqli_error($connection);
}

Keywords

SQL PHP arrays data retrieval data manipulation error handling

Related Questions