<?php
require_once 'config/db.php';
try {
    $stmt = $pdo->query("SELECT * FROM tbl_shifts");
    $shifts = $stmt->fetchAll(PDO::FETCH_ASSOC);
    echo "SHIFTS:\n";
    print_r($shifts);

    $stmt2 = $pdo->query("SELECT id, name, shift_id FROM tbl_employees WHERE name LIKE '%steve%'");
    $steve = $stmt2->fetch(PDO::FETCH_ASSOC);
    echo "STEVE:\n";
    print_r($steve);

} catch (Exception $e) {
    echo $e->getMessage();
}
