From b394216478cfe19b48baa2709529a04022e41415 Mon Sep 17 00:00:00 2001 From: Richard Whitehouse Date: Fri, 4 Feb 2011 23:17:06 +0000 Subject: [PATCH] Purchase::Get_By_Order --- index.php | 19 +++++++++++++++++-- 1 file changed, 17 insertions(+), 2 deletions(-) diff --git a/index.php b/index.php index 3f93a6b..d108eb2 100644 --- a/index.php +++ b/index.php @@ -255,10 +255,25 @@ class Purchase { $stmt->bind_param('iiis', $order->id(), $ticket->id(), $type->price(), $name); $stmt->execute(); $purchase = new Purchase($stmt->insert_id, $order->id(), $ticket->id(), $type->price(), $name); - + } - } + public function Get_By_Order($order){ + if($order instanceof Type){ + $order = $order->id(); + } + $query = 'SELECT `id`,`ticket`,`order`,`price`,`name` FROM `order` WHERE `order` = ?'; + $stmt = Ticketing::Get()->database()->prepare($query); + $stmt->bind_param('i', $order); + $stmt->execute(); + $stmt->bind_result($id, $ticket, $order, $price, $name); + $purchases = array(); + while($stmt->fetch()){ + $purchases[$id] = new Purchase($id, $ticket, $order, $price, $name); + } + $stmt->close(); + return $purchases; + } } -- 2.34.1