26 lines
1.0 KiB
PHP
Executable File
26 lines
1.0 KiB
PHP
Executable File
<?php
|
|
$jahrgang=$_COOKIE["jahrgang"];
|
|
$hs=$_COOKIE["ck_hs"];
|
|
|
|
include("kurs/datenbankanbindung.php"); // fügt die Datenbankanbindung ein: Sys:\php\includes\kurs\datenbankanbindung.php
|
|
$db = dbconnect();
|
|
|
|
##header("Content-Type: text/html;charset=utf-8");
|
|
|
|
if(isset($_GET['getWord']) && isset($_GET['letters'])){
|
|
if(preg_match('/Firefox/',$_SERVER['HTTP_USER_AGENT'])){
|
|
$letters = $_GET['letters'];
|
|
}else{
|
|
$letters = utf8_encode($_GET['letters']);
|
|
}
|
|
|
|
#$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
|
|
$res = $db->query("select uid, vorname, nachname, mtknr from stud WHERE (nachname like '%".$letters."%' OR mtknr like '%".$letters."%' or vorname like '%".$letters."%' or uid like '%".$letters."%')AND jahrgang='$jahrgang' AND hs='$hs' ORDER BY nachname") or die(mysql_error());
|
|
#echo "1###select ID,textstelle Name from ajax_countries where textstelleName like '".$letters."%'|";
|
|
while($inf = $res->fetch_array()){
|
|
$name= "$inf[vorname] $inf[nachname] ($inf[mtknr],$inf[uid])";
|
|
echo $name."|";
|
|
}
|
|
}
|
|
?>
|