123456/ajax/opdracht/klassenza.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));
}
?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="iso-8859-2">
<title>Leerlingen verplaatsen zonder ajax</title>
<link href="../css/ajax.css" rel="stylesheet" type="text/css">
</head>
<body>
<h1>Leerlingen verplaatsen</h1>
<?php
echo "";
$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>";
echo "<blockquote>";
$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>";
echo "<span class='leerlingnaam'>$row2[achternaam], $row2[voornaam] $row2[tussenv]</span>";
$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'];
echo " → <a class='klasnieuw' href='?llnr=$llnr&klasnieuw=$klasnieuw'>$klasnieuw</a>";
}
echo "</div>";
}
echo "</blockquote>";
}
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse