public function getOrderById($id)
    {
        $stmt = $this->dbh->prepare("SELECT * FROM `orders` WHERE id=?");
        $stmt->execute([$id]);
        $result = $stmt->fetch(PDO::FETCH_INTO, $this);
    }