122 lines
4.9 KiB
PHP
122 lines
4.9 KiB
PHP
<?php
|
|
SESSION_START();
|
|
require('connect.php');
|
|
|
|
$name = $_POST['input'];
|
|
$return = null;
|
|
|
|
//Te Kort
|
|
if(strlen($name)<1){
|
|
die("Type om te zoeken");
|
|
}
|
|
|
|
//Leerling Nummer
|
|
elseif(is_numeric($name)){
|
|
if($_SESSION['login']==2){
|
|
$query = "SELECT DISTINCT `adminnr`, `voornaam`, `tussenvoegsel`, `achternaam` FROM `adminnr_naam` WHERE `adminnr` LIKE '%$name%' ORDER BY `adminnr` LIMIT 0,10";
|
|
$result_temp = mysql_query($query, $connection);
|
|
|
|
while ($result = mysql_fetch_assoc($result_temp)) {
|
|
$return .= "<a href='javascript:return false;' onclick=setPageValue('leerling/" . $result['adminnr'] . "');toggle();> <font color='#31314D'>Leerling</font> - " . $result['voornaam'] . " " . $result['tussenvoegsel'] . " " . $result['achternaam'] . " (" . $result['adminnr'] . ")</a><br>";
|
|
}
|
|
|
|
if (strlen($name)<=6){
|
|
$query = "SELECT DISTINCT `groep` FROM `adminnr_groep` WHERE `groep` LIKE '%$name%' ORDER BY `groep` LIMIT 0,10";
|
|
$result_temp = mysql_query($query, $connection);
|
|
|
|
while ($result = mysql_fetch_assoc($result_temp)) {
|
|
$return .= "<a href='javascript:return false;' onclick=setPageValue('groep/" . $result['groep'] . "');toggle();> <font color='#3A4D31'>Groep</font> - " . $result['groep'] . "</a><br>";
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
if (strlen($name)<=3){
|
|
$query = "SELECT DISTINCT `lokaal` FROM `lessen` WHERE `lokaal` LIKE '%$name' ORDER BY `lokaal` LIMIT 0,10";
|
|
$result_temp = mysql_query($query, $connection);
|
|
|
|
while ($result = mysql_fetch_assoc($result_temp)) {
|
|
$return .= "<a href='javascript:return false;' onclick=setPageValue('lokaal/" . $result['lokaal'] . "');toggle();> <font color='#4C314D'>Lokaal</font> - " . $result['lokaal'] . "</a><br>";
|
|
}
|
|
}
|
|
}
|
|
|
|
//Voornaam, Achternaam of Docentnaam
|
|
else{
|
|
|
|
//Docentnaam
|
|
if(strlen($name)<=2 && $_SESSION['login']==2){
|
|
$query = "SELECT DISTINCT `docent` FROM `lessen` WHERE `docent` LIKE '$name%' ORDER BY `docent` LIMIT 0,10";
|
|
$result_temp = mysql_query($query, $connection);
|
|
|
|
while ($result = mysql_fetch_assoc($result_temp)) {
|
|
$return .= "<a href='javascript:return false;' onclick=setPageValue('docent/" . $result['docent'] . "');toggle();><font color='#4D3131'>Docent</font> - " . $result['docent'] . "</a><br>";
|
|
}
|
|
}
|
|
|
|
//Lokaal
|
|
if (strlen($name)<=3){
|
|
$query = "SELECT DISTINCT `lokaal` FROM `lessen` WHERE `lokaal` LIKE '$name%' ORDER BY `lokaal` LIMIT 0,10";
|
|
$result_temp = mysql_query($query, $connection);
|
|
|
|
while ($result = mysql_fetch_assoc($result_temp)) {
|
|
$return .= "<a href='javascript:return false;' onclick=setPageValue('lokaal/" . $result['lokaal'] . "');toggle();> <font color='#4C314D'>Lokaal</font> - " . $result['lokaal'] . "</a><br>";
|
|
}
|
|
}
|
|
|
|
//Voornaam of achternaam
|
|
if(!strpos($name, ' ') && $_SESSION['login']==2){
|
|
$query = "SELECT DISTINCT `adminnr`, `voornaam`, `tussenvoegsel`, `achternaam` FROM `adminnr_naam` WHERE `voornaam` LIKE '$name%' OR `achternaam` LIKE '$name%' ORDER BY `adminnr` LIMIT 0,10";
|
|
$result_temp = mysql_query($query, $connection);
|
|
|
|
while ($result = mysql_fetch_assoc($result_temp)) {
|
|
$return .= "<a href='javascript:return false;' onclick=setPageValue('leerling/" . $result['adminnr'] . "');toggle();> <font color='#31314D'>Leerling</font> - " . $result['voornaam'] . " " . $result['tussenvoegsel'] . " " . $result['achternaam'] . " (" . $result['adminnr'] . ")</a><br>";
|
|
}
|
|
}
|
|
|
|
//Voornaam en achternaam
|
|
elseif(strpos($name, ' ') && $_SESSION['login']==2){
|
|
$array = explode(' ', $name);
|
|
$voornaam = $array[0];
|
|
if(count($array)==2){
|
|
$achternaam = $array[1];
|
|
$tussenvoegsel = $array[1];
|
|
}
|
|
elseif(count($array)==3){
|
|
$achternaam = $array[2];
|
|
$tussenvoegsel = $array[1];
|
|
}
|
|
elseif(count($array)==4){
|
|
$achternaam = $array[3];
|
|
$tussenvoegsel = $array[1] . ' ' . $array[2];
|
|
}
|
|
else{
|
|
$achternaam = end($array);
|
|
$tussenvoegsel = '';
|
|
}
|
|
|
|
$query = "SELECT DISTINCT `adminnr`, `voornaam`, `tussenvoegsel`, `achternaam` FROM `adminnr_naam` WHERE `voornaam` LIKE '$voornaam%' AND (`achternaam` LIKE '$achternaam%' OR `tussenvoegsel` LIKE '$tussenvoegsel%') ORDER BY `adminnr` LIMIT 0,10";
|
|
$result_temp = mysql_query($query, $connection);
|
|
|
|
while ($result = mysql_fetch_assoc($result_temp)) {
|
|
$return .= "<a href='javascript:return false;' onclick=setPageValue('leerling/" . $result['adminnr'] . "');toggle();> <font color='#31314D'>Leerling</font> - " . $result['voornaam'] . " " . $result['tussenvoegsel'] . " " . $result['achternaam'] . " (" . $result['adminnr'] . ")</a><br>";
|
|
}
|
|
}
|
|
|
|
if (strlen($name)<=6 && $_SESSION['login']==2){
|
|
$query = "SELECT DISTINCT `groep` FROM `adminnr_groep` WHERE `groep` LIKE '%$name%' ORDER BY `groep` LIMIT 0,10";
|
|
$result_temp = mysql_query($query, $connection);
|
|
|
|
while ($result = mysql_fetch_assoc($result_temp)) {
|
|
$return .= "<a href='javascript:return false;' onclick=setPageValue('groep/" . $result['groep'] . "');toggle();> <font color='#3A4D31'>Groep</font> - " . $result['groep'] . "</a><br>";
|
|
}
|
|
}
|
|
}
|
|
|
|
if(is_null($return)){
|
|
echo "Er zijn helaas geen resultaten gevonden.";
|
|
}
|
|
else {
|
|
echo $return;
|
|
}
|
|
?>
|