37 lines
713 B
PHP
Executable File
37 lines
713 B
PHP
Executable File
<?php
|
|
$connect = mysqli_connect("localhost", "root", "", "bpm");
|
|
$output = '';
|
|
if(isset($_POST["query"]))
|
|
{
|
|
$search = mysqli_real_escape_string($connect, $_POST["query"]);
|
|
$query = "
|
|
SELECT ka_id, vorname, nachname
|
|
FROM bpm_kandidat
|
|
WHERE vorname LIKE '%".$search."%'
|
|
OR nachname LIKE '%".$search."%'
|
|
";
|
|
}
|
|
else
|
|
{
|
|
$query = "
|
|
SELECT ka_id, vorname, nachname
|
|
FROM bpm_kandidat
|
|
ORDER BY nachname, vorname";
|
|
}
|
|
$result = mysqli_query($connect, $query);
|
|
if(mysqli_num_rows($result) > 0)
|
|
{
|
|
while($row = mysqli_fetch_array($result))
|
|
{
|
|
$output .= "
|
|
<option value='$row[ka_id]'>$row[nachname], $row[vorname]</option>
|
|
";
|
|
}
|
|
echo $output;
|
|
}
|
|
else
|
|
{
|
|
echo 'Data Not Found';
|
|
}
|
|
?>
|