How can the PHP code be optimized to handle cases where the queried page does not exist in the database?

When a queried page does not exist in the database, the PHP code can be optimized by checking if the query returned any results before attempting to display the page content. This can be achieved by using the `rowCount()` method to determine if any rows were returned by the query. If no rows are found, a message indicating that the page does not exist can be displayed to the user. 

<?php
// Assume $pageId contains the queried page ID

// Query the database for the page content
$stmt = $pdo->prepare("SELECT * FROM pages WHERE id = :pageId");
$stmt->bindParam(':pageId', $pageId);
$stmt->execute();

// Check if any rows were returned
if ($stmt->rowCount() > 0) {
    // Display the page content
    $page = $stmt->fetch();
    echo $page['content'];
} else {
    // Display a message indicating the page does not exist
    echo "Page not found.";
}
?>

Keywords

PHP error handling database query conditional statements exception handling

Related Questions