public function getProduct($f) { $id = $f->getId(); $res = mysql_query("SELECT *,food.id AS fid, seller.id AS sid FROM food INNER JOIN seller ON seller.id=food.seller_id WHERE food.id='" . $id . "'"); $userRow = mysql_fetch_array($res); $food = new Foods(); $seller = new Seller(); $review = new Review(); $food->setId($userRow['fid']); $food->setFood($userRow['food']); $food->setImgs($userRow['imgs']); $food->setPrice($userRow['price']); $food->setIngredients($userRow['ingredients']); $food->setDescription($userRow['description']); $food->setType($userRow['type']); $food->setMeal($userRow['meal']); $food->setVeg($userRow['veg']); $food->setSpicy($userRow['spices']); $food->setStock($userRow['stock']); $food->setDelivery($userRow['delivery']); $food->setDtime($userRow['dtime']); $seller->setId($userRow['sid']); $seller->setCompany($userRow['company']); $seller->setAddress($userRow['address']); $seller->setCity($userRow['city']); $seller->setPostalcode($userRow['postalcode']); $seller->setDescription($userRow['description']); $seller->setLogo($userRow['logo']); $seller->setUser_id($userRow['user_id']); $resR = mysql_query("SELECT * FROM review WHERE food_id='" . $f->getId() . "'"); $userRowR = mysql_fetch_array($resR); $review->setId($userRowR['id']); $review->setName($userRowR['name']); $review->setEmail($userRowR['email']); $review->setComment($userRowR['comment']); $review->setRtime($userRowR['rtime']); $review->setRday($userRowR['rday']); $review->setFood_id($userRowR['food_id']); $objs = array(); $objs[] = $food; $objs[] = $seller; $objs[] = $review; return $objs; }
include '../model/food.php'; include '../model/seller.php'; include '../model/review.php'; include '../model/carts.php'; $processitems = new Processitems(); if (isset($_POST['btn-review'])) { $review = new Review(); $review->setName($_POST['rname']); $review->setComment($_POST['comment']); $review->setEmail($_POST['rmail']); $review->setId($_POST['rid']); $mydate = getdate(date("U")); $rday = $mydate[month] . " " . $mydate[mday] . ", " . $mydate[year]; $rtime = date(" H:i", time()); $review->setRday($rday); $review->setRtime($rtime); $msg = $processitems->addReview($review); } if (isset($_GET['id'])) { $food = new Foods(); $food->setId($_GET['id']); $objs = $processitems->getProduct($food); $f = $objs[0]; $s = $objs[1]; $r = $objs[2]; } else { if (isset($_POST['id'])) { $c = new Cart(); $c->setFood_id(mysql_real_escape_string($_POST['id'])); $c->setQuantity(mysql_real_escape_string($_POST['quantity'])); $processitems->addToCart($c);