What are the potential pitfalls of not properly checking for query results before displaying table headers in PHP?

If query results are not properly checked before displaying table headers in PHP, it can lead to errors or warnings if the query returns no results. To avoid this issue, always check if there are results before displaying the table headers. 

// Check if there are results before displaying table headers
if($result = mysqli_query($conn, $query)) {
    if(mysqli_num_rows($result) > 0) {
        // Display table headers
        echo "<table><tr><th>Header 1</th><th>Header 2</th></tr>";

        // Display table rows
        while($row = mysqli_fetch_assoc($result)) {
            echo "<tr><td>".$row['column1']."</td><td>".$row['column2']."</td></tr>";
        }

        echo "</table>";
    } else {
        echo "No results found.";
    }
} else {
    echo "Error: " . mysqli_error($conn);
}

Keywords

SQL injection mysqli_num_rows error handling data validation XSS vulnerabilities

Related Questions