Klikken op een letter haalt een uitgebreide lijst op van woorden die met die letter beginnen.
connect_error) { die("Connectie mislukt: " . $conn->connect_error); } //Query omaantallen en pagina's vast te stellen $sql = "SELECT * FROM `woorden` WHERE woord LIKE \"$letter%\" AND doet_mee = 1 AND LENGTH(`woord`) > 2 GROUP BY woord ORDER BY woord"; //echo $sql; $result=mysqli_query($conn,$sql); //echo "";
if($number==1 && $pages > $number){
$fnr=$number+1;
echo " ";
}
if($number>1 && $number < $pages){
$fnr=$number+1;
$bnr=$number-1;
echo " ";
echo "";
}
if($pages>1 && $number == $pages){
$fnr=$number+1;
$bnr=$number-1;
echo "";
}
echo " |
| ";
while($resultaat=mysqli_fetch_array($result,MYSQLI_BOTH)){
if ($x<280){
if(strlen(trim($resultaat["woord"]))>2){
$x++;
echo "";
if($resultaat["type"]==2){
echo "".trim($resultaat["woord"]);
echo " "; } else{ echo trim($resultaat["woord"]); echo " "; } } if(($x%40)===0){ echo " | "; } } } echo " |
| ";
if($number==1 && $pages > $number){
$fnr=$number+1;
echo " ";
echo "";
echo " ";
}
if($number>1 && $number < $pages){
$fnr=$number+1;
$bnr=$number-1;
echo "";
echo "";
echo "";
}
if($pages>1 && $number == $pages){
$fnr=$number+1;
$bnr=$number-1;
echo "";
}
echo " |