isMobile() && !$detect->isTablet() ){ $client_device = "mobile"; } else { $client_device = "desktop"; } ?> query($sql); $data = $qwr->fetch_assoc(); $arr_search = array("aaa", "uuu", "ooo"); $arr_replace = array("ä", "ü", "ö"); $data["rezept"] = str_replace($arr_search, $arr_replace, $data["rezept"]); $sql = "SELECT * FROM kategorien WHERE id = '$data[id_kat]'"; $qwr_kat = $db->query($sql); $data_kat = $qwr_kat->fetch_assoc(); } ?> "> "> "> <? print $pagetitel; ?> - Rollis Rezepte
">.
.
Rollis Koch und Backblog
Sortieren nach Rezept Sortieren nach Datum
.
\n"; if($action == "search" && $stop_search != "stop") { $arr_search = preg_split("/[\s,]+/", $search); $search_str = ""; foreach($arr_search as $val) { $search_str .= " + ".$val; } //$search_str_utf = utf8_encode($search_str); if($io == 1) { print "search_str_utf: ".$search_str."
\n"; } $sql = "SELECT DISTINCT(id_rez) FROM rezepte_cont WHERE MATCH (cont) AGAINST ('$search_str' IN BOOLEAN MODE) ORDER BY id_rez"; $qwr_cont = $db->query($sql); while($data = $qwr_cont->fetch_assoc()) { if(is_numeric($data["id_rez"])) { $arr_rez_id[$data["id_rez"]] = $data["id_rez"]; //print "id_rez1: ".$data["id_rez"]."
\n"; } } $sql = "SELECT * FROM rezepte WHERE MATCH (rezept) AGAINST ('$search_str' IN BOOLEAN MODE)"; $qwr_titel = $db->query($sql); while($data = $qwr_titel->fetch_assoc()) { if(is_numeric($data["id"])) { $arr_rez_id[$data["id"]] = $data["id"]; //print "id_rez: ".$data["id"]."
\n"; } } if(is_array($arr_rez_id)) { //print var_dump($arr_rez_id); $list = implode(", ", $arr_rez_id); //$rows_rezepte = $qwr_list->num_rows; //print "list: ".$list."
\n"; $sql = "SELECT *, DATE_FORMAT(datum,'%d.%m.%Y') AS datum_f FROM rezepte WHERE id IN (".$list.") ORDER BY rezept"; //print "sql: ".$sql."
\n"; $qwr_search = $db->query($sql); $rows_rezepte = $qwr_search->num_rows; } else { $rows_rezepte = 0; } } elseif($id_kat) { if($order == "date") { $order_str = "ORDER BY datum DESC"; } else { $order_str = "ORDER BY rezept"; } if($id_subkat) { $sql = "SELECT * FROM rezepte WHERE id_kat = '$id_kat' AND id_subkat = '$id_subkat' ".$order_str; } else { $sql = "SELECT *, DATE_FORMAT(datum,'%d.%m.%Y') AS datum_f FROM rezepte WHERE id_kat = '$id_kat' ".$order_str; } $qwr_list = $db->query($sql); //print "err: :".$db->errno.'-'.$db->error."
\n"; $rows_rezepte = $qwr_list->num_rows; //print "sql: ".$sql."
\n"; } elseif($id_kw) { $sql = "SELECT kw.id AS id, kw.keyword AS keyword FROM keywords AS kw, keywords_rel AS rel WHERE kw.id = rel.id_kw AND rel.id_kw = '$id_kw'"; $qwr_list = $db->query($sql); $rows_rezepte = $qwr_list->num_rows; } elseif($id_regio) { $sql = "SELECT reg.id AS id, reg.keyword AS keyword FROM regionen AS reg, regionen_rel AS rel WHERE reg.id = rel.id_regio AND rel.id_regio = '$id_regio'"; $qwr_list = $db->query($sql); $rows_rezepte = $qwr_list->num_rows; } elseif(!$id_kat && !$id_rez && !$id_kw && !$id_regio && !$search) { $sql = "SELECT id FROM rezepte WHERE id_kat != '9' AND id_kat != '23'"; $qwr = $db->query($sql); $rows_rezepte = "Total ".$qwr->num_rows; } include("inc/nav.php"); ?>
query($sql); } include("inc/rezept_list_kat.php"); } if($id_kat == 23 && !$id_rez) { if($id_subkat) { $sql = "SELECT * FROM rezepte WHERE id_kat = '$id_kat' AND id_subkat = '$id_subkat' ".$order_str; } else { $sql = "SELECT *, DATE_FORMAT(datum,'%d.%m.%Y') AS datum_f FROM rezepte WHERE id_kat = '$id_kat' ".$order_str; } //$sql = "SELECT *, DATE_FORMAT(datum,'%d.%m.%Y') AS datum_f FROM rezepte WHERE id_kat = '$id_kat' ".$order_str; $qwr_list = $db->query($sql); //print "sql: ".$sql."
\n"; include("inc/rezept_list_produkte.php"); } if($id_rez) { include("inc/rezept.php"); } if($id_kw && !$id_rez) { if($io != 1) { $now = $date = date("Y-m-d"); $ip = $_SERVER["REMOTE_ADDR"]; $sql = "INSERT INTO pages_list (id_kw, datum, ip) VALUES ('$id_kw', '$now', '$ip')"; $qwr = $db->query($sql); } include("inc/rezept_list_kw.php"); } if($id_regio && !$id_rez) { include("inc/rezept_list_regio.php"); } if($action == "search" && !$id_rez) { include("inc/search.php"); } if($show == "a-z") { include("inc/rezepte_a-z.php"); } if($show == "links") { include("inc/links.php"); } if(!$id_kat && !$id_rez && !$id_kw && !$id_regio && $action != "search" && !$show) { $show_new_rez = 1; include("inc/neue_rezepte.php"); } ?>
"; ?>
Schafgeschichte - Lammgerichte
Nur in Rezepte A-Z
Suchen
.
Regionale Küchen:
.
Stichworte:
.