コード例 #1
0
 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;
 }
コード例 #2
0
ファイル: product.php プロジェクト: harjotsingh3878/JustBite
include '../model/processitems.php';
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']));