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

 Admin Panel
Alfabet search

$letter]"; else echo "[$letter]"; if (ereg("[ejot]",$letter)) echo "
"; } ?>

" method="POST">
Search
Sorteer op name="orderby" value="naam">Naam name="orderby" value="keuken">Keuken name="orderby" value="recepten.gerechtid">Type
query = ereg_replace("%where%", " recepten.receptid = $receptid ", $query_tpl); $db->query = ereg_replace("%order%", " keuken ", $db->query); $db->DBQuery(); $keukentype=""; while ($recept = $db->DBResult()) { $keukentype .= ", keukenid)."\">".stripslashes($recept->keuken).""; $gerecht = "gerechtid)."\">".stripslashes($recept->gerecht).""; $naam = stripslashes($recept->naam); if ($secure) $ref = stripslashes($recept->ref); $opmerking = stripslashes($recept->opmerking); $ingredient = nl2br(stripslashes($recept->ingredient)); $bereiding = nl2br(stripslashes($recept->bereiding)); } $db->query = "SELECT count(viewid) as numberviewers from viewed where receptid = $receptid"; $db->DBQuery(); $number = $db->DBResult(); $viewed = $number->numberviewers; ?>
Recept Vindplaats$ref"; ?>
Type gerecht
Opmerking(en)
Aantal keer bezocht in de afgelopen dagen
 
Ingredienten
Bereiding
">Back
query = ereg_replace("%where%", $where, $query_tpl); $db->query = ereg_replace("%order%", $qorder, $db->query); $db->query = ereg_replace("%limit%", "$display", $db->query); //echo $db->query; $db->DBQuery(); // $numrecept = $db->DBNumRows(); $numrecept = 0; /* display shorter lists and links to next $numtag = $numrecept / $maxlistlength ; for ($j = 0; $j <= $numtag; $j++) echo "[" . ($j*$maxlistlength+1) . "-" . ($j+1)*$maxlistlength . "]"; */ echo "
"; $oldid = -1; $firsttime = true; echo "
"; 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 "
\n\n"; } if ($totaalrecept == 1) $en = ""; else $en="en"; 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
    "; $now = mktime() - 24*60*60; $query = "select count(viewid) as viewedtotal, viewed.receptid as id,naam from viewed,recepten where viewed.receptid = recepten.receptid and viewunixtime > $now group by id order by viewedtotal DESC, naam ASC limit $number"; //$toplist = $query; $db->DBQuery($query); while ($recept = $db->DBResult()) $toplist .= "
  1. id . "\">". stripslashes($recept->naam) . "
    2. "; $toplist .= "
"; return $toplist; } function determinate() { $f = rand(1,10); if ($f <= 3) $d = 0; else $d = 1; return $d; } ?>