123456/ajax/opdracht/klas.php
<?php
$llnr= $_GET['llnr'];
$klasnieuw= $_GET['klasnieuw'];
include('../includes/db.php');
if($llnr && $klasnieuw){
$query = "update leerlingen set klas ='$klasnieuw' where llnr=$llnr";
$result = mysqli_query($db_link, $query) or die(mysqli_error($db_link));
}
$query = "select distinct klas from leerlingen order by klas";
$result = mysqli_query($db_link, $query) or die(mysqli_error($db_link));
$i=0;
while($row = mysqli_fetch_array($result)){
$klas = $row['klas'];
echo "<h2>$klas</h2>\n";
echo "<blockquote>\n";
$query2 = "select * from leerlingen where klas ='$klas' order by achternaam ";
$result2 = mysqli_query($db_link, $query2) or die(mysqli_error($db_link));
while($row2 = mysqli_fetch_array($result2)){
echo "<div>\n";
echo "<span class='leerlingnaam'>$row2[achternaam], $row2[voornaam] $row2[tussenv]</span>\n";
$llnr =$row2['llnr'];
$query3 = "select distinct klas from leerlingen where not klas = '$klas' order by klas";
$result3 = mysqli_query($db_link, $query3) or die(mysqli_error($db_link));
while($row3 = mysqli_fetch_array($result3)){
$klasnieuw = $row3['klas'];
//span i.p.v. a
echo " → <span class='klasnieuw' onclick=\"ajax('klas.php?llnr=$llnr&klasnieuw=$klasnieuw', 'klassen')\">$klasnieuw</span>\n";
}
echo "</div>\n";
}
echo "</blockquote>\n";
}
?>
Resultaat
Made by Thijs Aarnoudse