<?php
// Database connection credentials
$dsn ='mysql:dbname=myblog;host=localhost';
$user = 'root';
$pass = '';
// Instantiate the PDO (PHP 5 specific) class
try {
$dbh = new PDO($dsn, $user, $pass);
} catch (PDOException $e){
echo'Connection failed: '.$e->getMessage();
}
// PDO statement to fetch the post data
$query = "SELECT p.*, a.name FROM posts AS p " .
"LEFT JOIN authors AS a ON p.author_id = a.id " .
"WHERE p.id = :post_id";
$post_stmt = $dbh->prepare($query);
// PDO statement to fetch the post's categories
$query = "SELECT c.name FROM posts_categories AS pc ".
"LEFT JOIN categories AS c ON pc.category_id = c.id " .
"WHERE pc.post_id = :post_id";
$cat_stmt = $dbh->prepare($query);
// Function to display the results in a nice format
function display_results($results, $message = null)
{
global $post_stmt, $cat_stmt;
if ($message...