read.php

<?php

include 'dbconnection.php';

$id = filter_var($_GET['id'], FILTER_SANITIZE_STRING);

$status = [
    "status" => "success",
    "notes" => [],
];

try{
    $sql = "SELECT * FROM notes WHERE id=:id";
    $stmt = $pdo->prepare($sql);

    $stmt->bindParam(':id', $id, PDO::PARAM_STR);
    
    $id = $id;

    $stmt->execute();

    $notes = $stmt->fetchAll();

    if (count($notes) > 0) {
        foreach ($notes as $note) {
            array_push($status['notes'], [
                'id' => $note['id'],
                'title' => $note['title'],
                'author' => $note['author'],
                'messages' => $note['messages'],
            ]);
        }
    } else {
        $status['status'] = "error";
        $status['message'] = "no note found with this id";
    }

    
    echo json_encode($status);
} catch(PDOException $e){
    die("ERROR: Could not prepare/execute query: $sql. " . $e->getmessages());
}