39 lines
1.0 KiB
PHP
39 lines
1.0 KiB
PHP
<?php
|
|
include("aespa/datenbankanbindung.php"); // fügt die Datenbankanbindung ein: Sys:\php\includes\kurs\datenbankanbindung.php
|
|
|
|
$function = $_POST['function'];
|
|
if ($function == 'fetch_select') {
|
|
$db = dbconnect();
|
|
if (isset($_COOKIE['uid1'])) {
|
|
$uid1 = $_COOKIE['uid1'];
|
|
}
|
|
if(isset($_COOKIE['ck_uid1'])){
|
|
$uid1 = $_COOKIE['ck_uid1'];
|
|
}else{
|
|
$uid1 = '';
|
|
}
|
|
|
|
if (isset($_POST['kontinent'])) {
|
|
$kid = $_POST['kontinent'];
|
|
}
|
|
|
|
$result1 = $db->query("SELECT land FROM aesp_bewerbung WHERE uid='$uid1'");
|
|
$row1 = $result1->fetch_array();
|
|
|
|
$db = dbconnect();
|
|
$query = "SELECT lid, land FROM aesp_land WHERE kid LIKE '$kid' ORDER BY land ASC";
|
|
|
|
$result = $db->query($query);
|
|
|
|
while ($row = $result->fetch_array()) {
|
|
echo "<option value='$row[lid]'";
|
|
if (isset($row1['land']) AND isset($row['lid']) AND $row1['land'] == $row['lid']) {
|
|
echo " selected ";
|
|
}
|
|
echo ">" . $row['land'] . "</option>";
|
|
}
|
|
exit;
|
|
}
|
|
|
|
?>
|