Example #1
0
    public static function load(DB $db, $id)
    {
        $stmt = $db->prepare('
			SELECT
				`id`,
				`entered_at`,
				`denomination`,
				`purchase_id`
			FROM `bills`
			WHERE `id`=:id
		');
        $stmt->execute(array(':id' => $id));
        $row = $stmt->fetchAll(PDO::FETCH_ASSOC)[0];
        $bill = new self();
        return $bill->setEnteredAt(new DateTime($row['entered_at']))->setDenomination(new Amount($row['denomination']))->setPurchaseId($row['purchase_id'])->setId($id);
    }