| $i |
$row[name] |
|
data;
$i++;
}
}
if(isset($_POST['remove_accomm'])){
$frm_data = filteration($_POST);
$values = [$frm_data['remove_accomm']];
$check_q = select('SELECT * FROM `room_accommodation` WHERE `accommodation_id`=?', [$frm_data['remove_accomm']], 'i');
if(mysqli_num_rows($check_q) == 0){
$q = "DELETE FROM `accommodation` WHERE `id`=?";
$res = delete($q, $values, 'i');
echo $res;
} else{
echo 'room_add';
}
}
if(isset($_POST['add_addiAccomm'])){
$frm_data = filteration($_POST);
$q = "INSERT INTO `additional_accomm`(`name`, `detail`) VALUES (?, ?)";
$values = [$frm_data['name'], $frm_data['detail']];
$res = insert($q, $values, 'ss');
echo $res;
}
if(isset($_POST['get_addiAccomm'])){
$res = selectAll('additional_accomm');
$i = 1;
while($row = mysqli_fetch_assoc($res)){
echo <<
$i |
$row[name] |
$row[detail] |
|
data;
$i++;
}
}
if(isset($_POST['remove_addiAccomm'])){
$frm_data = filteration($_POST);
$values = [$frm_data['remove_addiAccomm']];
$check_q = select('SELECT * FROM `room_additionalAccom` WHERE `additionalAccom_id`=?', [$frm_data['remove_addiAccomm']], 'i');
if(mysqli_num_rows($check_q) == 0){
$q = "DELETE FROM `additional_accomm` WHERE `id`=?";
$res = delete($q, $values, 'i');
echo $res;
} else{
echo 'room_add';
}
}
?>