<?php
    require('connect.php');
    $id = $_GET['id'];

    $sql = "SELECT * FROM blog";
    $stmt=$conn->prepare($sql);
    $stmt->execute(['blogid' => $id]);

    if($stmt->rowCOunt() < 1){
        echo '<h1>Could find blog post </h1>';
        require('footer.php');
        exit;
    }

<?php
$servername="localhost";
$username="a";
$password="";

$conn = new PDO("mysql:host=$servername;dbname=local",$username,$password);