DBQuery("select distinct(substring(naam,1,1)) as firstletter from recepten order by firstletter"); $alfaprint = array(); while ($res = $db->DBResult() ) $alfaprint[] = strtolower($res->firstletter); $db->DBQuery("select keukenid,keuken from keuken order by keuken"); $keukenarray = array(); while ($res = $db->DBResult() ) $keukenarray[$res->keukenid] =stripslashes($res->keuken); $db->DBQuery("select gerechtid,gerecht from gerecht order by gerecht"); $gerecht = array(); while ($res = $db->DBResult() ) $gerecht[$res->gerechtid] = stripslashes($res->gerecht); $db->DBQuery("select count(receptid) as totaalrecept from recepten"); $res = $db->DBResult(); $totaalrecept = $res->totaalrecept; $display = intval($_GET['display']); if ($_POST['orderby']) $order = $_POST['orderby']; else $order = "naam"; if (!ereg("^(naam|keuken|recepten.gerechtid)$", $order)) $order = "naam"; switch ($order) { case "naam" : $next = ",keuken"; break; case "recepten.gerechtid" : $next = ",naam"; break; default : $next = ",naam"; brea; } if ($search == "nieuw") $qorder = "recepten.receptid desc limit 15"; $qorder = $order . $next; $switchvar = ""; foreach ($_GET as $get_var => $get_val) $switchvar .= "$get_var=$get_val&"; ?>
Het Kookpunt |
=$othername?> | Admin Panel |
Recept | =$naam ?> | Vindplaats | $ref"; ?> |
Type gerecht | =$gerecht.$keukentype ?> | ||
Opmerking(en) | =$opmerking ?> | ||
Aantal keer bezocht in de afgelopen =TIMEAGE ?> dagen | =$viewed ?> | ||
Ingredienten =$ingredient ?> | Bereiding =$bereiding ?> | ||
">Back |
"; while ($recept = $db->DBResult() ) { $receptid = intval($recept->receptid); $back= makereturnval(); $naam = stripslashes($recept->naam); if ($secure) $ref = stripslashes($recept->ref); $gerecht = stripslashes($recept->gerecht); $keuken = stripslashes($recept->keuken); $br = " | |||
"; $gerechtshow = "gerechtid\">$gerecht"; $naamshow = "$naam"; $keukenshow = "keukenid\">$keuken"; $refshow = ($ref) ? " | [$ref]" : ""; $numrecept++; if ($firsttime) { echo $br. $naamshow. " ($gerechtshow)" . $refshow . " | ". $keukenshow; } else if ($receptid == $oldid) { $numrecept--; echo ", " . $keukenshow; } else { echo $br. $naamshow. " ($gerechtshow)".$refshow." | " .$keukenshow; } $firsttime = false; $oldid = $receptid; } echo " |
Gevonden: $numrecept van $totaalrecept recept$en
"; $page->Footer(); //if (WEBSTAT) webstat(); //if (GOOGLE) googlead(); function makeReturnVal() { //first-receptnaam-ingredient-keukenid-type $first = $_GET['first']; if (!$first) $first = 0; $receptnaam = ($_POST['naam'])? urlencode($_POST['naam']):urlencode($_GET['naam']); if (!$receptnaam) $receptnaam = 0; $ingredient= ($_POST['ingredient'])? urlencode($_POST['ingredient']):urlencode($_GET['ingredient']); if (!$ingredient) $ingredient = 0; /* $keukenid = $_POST['keuken'] ? intval($_POST['keuken']):intval($_GET['keuken']); if ($receptnaam or $ingredient) $keukenid = 0; $type = $_POST['gerechttype'] ? intval($_POST['gerechttype']):intval($_GET['gerechttype']); if ($keukenid or $receptnaam or $ingredient) $type=0; return "$first-$receptnaam-$ingredient-$keukenid-$type"; */ return "$first,$receptnaam,$ingredient"; } function interpretReturnVal() { $back = $_GET['back']; $return = explode(",", $back); foreach ($return as $key => $value) { switch ($key) { case "0" : if ($value) $goback = "search=first&first=".urlencode($value); break; case "1" : if ($value) $goback = "search=naam&naam=".urlencode($value); break; case "2" : if ($value) $goback = "search=ingredient&ingredient=".urlencode($value); break; /* case "3" : if ($value) $goback = "search=keukenid&keuken=".urlencode($value); break; case "4" : if ($value) $goback = "search=gerechttype&gerechttype=".urlencode($value); break; */ //default : $goback = urlencode("");break; } } return $goback; } function googlead() { ?> Top $number today