示例#1
0
 public function getFoods($fid)
 {
     $food = new Foods();
     $res = mysql_query("SELECT * FROM food WHERE id=" . $fid);
     if (mysql_num_rows($res) > 0) {
         while ($userRow = mysql_fetch_array($res)) {
             $food->setId($userRow['id']);
             $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['spicy']);
             $food->setStock($userRow['stock']);
             $food->setDelivery($userRow['delivery']);
             $food->setDtime($userRow['dtime']);
         }
     }
     return $food;
 }
示例#2
0
    }
    echo $filepath;
    /*$query=mysql_query("INSERT into image (`image`) VALUES('".addslashes($filepath)."'); ");
      if($query)
      {
          header("location:".$_SERVER['PHP_SELF']);
      }*/
    $food = new Foods();
    $food->setId($_POST['id']);
    $food->setFood(mysql_real_escape_string($_POST['food']));
    $food->setPrice(mysql_real_escape_string($_POST['price']));
    $food->setIngredients(mysql_real_escape_string($_POST['ingredients']));
    $food->setDescription(mysql_real_escape_string($_POST['description']));
    $food->setType(mysql_real_escape_string($_POST['types']));
    $food->setMeal(mysql_real_escape_string($_POST['meal']));
    $food->setStock(mysql_real_escape_string($_POST['stock']));
    $food->setVeg(mysql_real_escape_string($_POST['veg']));
    $food->setSpicy(mysql_real_escape_string($_POST['spicy']));
    $food->setDelivery(mysql_real_escape_string($_POST['delivery']));
    $food->setDtime(mysql_real_escape_string($_POST['dtime']));
    $food->setImgs($filepath);
    $processfood = new Processfood();
    $msg_register = $processfood->updateFood($food);
    if ($msg_register == 0) {
        //	header("Location: myfood.php");
    }
}
?>

	
	<section id="form" style="margin-top: 0px"><!--form-->
示例#3
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;
 }