Best How To :

Instead of building a class to create the booking objects, it would be advisable to either create a standalone function, or a function within a parent class to achieve this. The issue I run in to with using fetchAll() with the FETCH_CLASS parameter, is that the objects do not automatically have access to the database object, causing you to need to iterate over the objects afterwards anyways, so I simply build the __construct() method to capture the $db and generated array.

Assuming you go the route of a standalone function:

function create_bookings($db, $current, $end) {
    $query = "SELECT id, name, time             
              FROM bookings";

    $stmt = $db->prepare($query); 

    $stmt->execute(); 

    $result = array()

    $bookings = $stmt->fetchAll();
    if($bookings) {
        foreach($bookings as $booking) {
            $result[$booking['id']] = new booking($db, $booking);
        }
    }
    return $result;
}


class booking {

    private $db;
    public $id;
    public $name;
    public $time;

    public function __construct($db, $array) {
        if(/*validate your array here*/) {
            $this->db = $db;
            $this->id = $array['id'];
            $this->name = $array['name'];
            $this->time = $array['time'];
        }
    }
}