예제 #1
0
		public static function getBySearch($str)
		{
			global $db;
			$sql = "SELECT * FROM ingredients WHERE name LIKE ?";
			$values = array("%" . $str . "%");
			$res = $db->qwv($sql, $values);
			
			return Ingredient::wrap($res);
		}
예제 #2
0
		public static function getRecommendedByItem($id)
		{
			global $db;
			//get all ingredients recommended for the item
			$recommendedSQL = "SELECT * FROM items_have_recommended_ingredients WHERE itemid=?";
			$values = array($id);
			$recList = $db->qwv($recommendedSQL, $values);
			
			//get info for each ingredient
			$recommendedSQL = "SELECT * FROM ingredients WHERE ingredientid=?";
			$recommends = array();
			$db->prep($recommendedSQL);
			foreach($recList as $recID)
			{
				$values = array($recID['ingredientid']);
				$ing = $db->qwv(null, $values);
				array_push($recommends, $ing[0]);
			}
			
			return Ingredient::wrap($recommends);
		}