<?php
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "podcast";

try {
    $conn = new PDO("mysql:host=$servername; dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Connected successfully <br>";

    $sql = "SELECT podcast, text
            FROM bookmarks
            WHERE data = :data";
    $statement = $conn->prepare($sql);
    $data = 1;
    $statement->bindValue(':data', $data);
    $statement->execute();
    echo $statement->rowCount() . " records SELECTED successfully <br>";

    $rows = $statement->fetchAll();
    foreach($rows as $row){
        echo $row['podcast'] . '<br>';
        echo $row['text'] . '<br>';
    }
}
catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}
$conn = null;

include("includes/connetion.php")
$sql = "SELECT podcast, text
        FROM bookmarks
        WHERE data = :data";
$statement = $conn->prepare($sql);
$data = 1;
$statement->bindValue(':data', $data);
$statement->execute();
echo $statement->rowCount() . " records SELECTED successfully <br>";

$rows = $statement->fetchAll();
foreach($rows as $row){
    echo $row['podcast'] . '<br>';
    echo $row['text'] . '<br>';
}

$conn = null;

<?php
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "podcast";

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // $conn = new PDO("sqlite:/Applications/MAMP/db/sqlite/podcast", $username, $password); //Lite

    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Connected successfully <br>";
    }

catch(PDOException $e)
    {
    echo "Connection failed: " . $e->getMessage();
    }
?>