query($sql) === TRUE) {
echo json_encode(array("code" => 0, "msg" => "successfully"));
exit();
} else {
echo json_encode(array("code" => 1, "msg" => "Error: " . $sql . "
" . $conn->error));
exit();
}
}
if (isset($_GET['uid'])) {
$uid = $_GET['uid'];
$start_date = $_GET['startDate'];
$end_date = $_GET['endDate'];
$sql = "INSERT INTO guide_booking (guide_id,booking_id,start_date,end_date) VALUES ('$uid',$bid,'{$start_date}','{$end_date}')";
if ($conn->query($sql) === TRUE) {
echo json_encode(array("code" => 0, "msg" => "successfully"));
exit();
} else {
echo json_encode(array("code" => 1, "msg" => "Error: " . $sql . "
" . $conn->error));
exit();
}
}
if (isset($_GET['attraction_id'])) {
$attraction_id = $_GET['attraction_id'];
$visit_date = $_GET['visit_date'];
$sql = "INSERT INTO attraction_booking (attraction_id,booking_id,visit_date) VALUES ('$attraction_id',$bid,'{$visit_date}')";
if ($conn->query($sql) === TRUE) {
echo json_encode(array("code" => 0, "msg" => "successfully"));
exit();
} else {
echo json_encode(array("code" => 1, "msg" => "Error: " . $sql . "
" . $conn->error));
exit();
}
}
if (isset($_GET['restaurant_id'])) {
$restaurant_id = $_GET['restaurant_id'];
$visit_date = $_GET['visit_date'];
$sql = "INSERT INTO restaurant_booking (restaurant_id,booking_id,visit_date) VALUES ('$restaurant_id',$bid,'{$visit_date}')";
if ($conn->query($sql) === TRUE) {
echo json_encode(array("code" => 0, "msg" => "successfully"));
exit();
} else {
echo json_encode(array("code" => 1, "msg" => "Error: " . $sql . "
" . $conn->error));
exit();
}
}
if (isset($_GET['flightClassId'])) {
$flight_class_id = $_GET['flightClassId'];
$visit_date = $_GET['visit_date'];
$sql = "INSERT INTO transport_flight_booking (flight_class_id,booking_id,visit_date) VALUES ('$flight_class_id',$bid,'{$visit_date}')";
if ($conn->query($sql) === TRUE) {
echo json_encode(array("code" => 0, "msg" => "successfully"));
exit();
} else {
echo json_encode(array("code" => 1, "msg" => "Error: " . $sql . "
" . $conn->error));
exit();
}
}
if (isset($_GET['trainClassId'])) {
$train_class_id = $_GET['trainClassId'];
$visit_date = $_GET['visit_date'];
$sql = "INSERT INTO transport_railway_booking (railway_class_id,booking_id,visit_date) VALUES ('$train_class_id',$bid,'{$visit_date}')";
if ($conn->query($sql) === TRUE) {
echo json_encode(array("code" => 0, "msg" => "successfully"));
exit();
} else {
echo json_encode(array("code" => 1, "msg" => "Error: " . $sql . "
" . $conn->error));
exit();
}
}
if (isset($_GET['type']) && $_GET['type'] == 'add') {
if (!isset($_SESSION['loggedin']) || !$_SESSION['loggedin']) {
echo "";
exit;
}
$uid = $_SESSION['uid'];
$day = $_GET['day'];
$sql = "INSERT INTO `bookings` (`uid`,`day`) VALUES ($uid,'{$day}')";
$conn->query($sql);
header("Location: ./plans.php");
}
if (isset($_GET['type']) && $_GET['type'] == 'change') {
$_SESSION['bid'] = $_GET['id'];
header("Location: ./plans.php");
}
if (isset($_GET['type']) && $_GET['type'] == 'reset') {
if (!isset($_SESSION['loggedin']) || !$_SESSION['loggedin']) {
echo "";
exit;
}
$bid = $_GET['id'];
$sql = "delete from `transport_railway_booking` where booking_id = $bid";
$conn->query($sql);
$sql = "delete from `transport_flight_booking` where booking_id = $bid";
$conn->query($sql);
$sql = "delete from `guide_booking` where booking_id = $bid";
$conn->query($sql);
$sql = "delete from `restaurant_booking` where booking_id = $bid";
$conn->query($sql);
$sql = "delete from `attraction_booking` where booking_id = $bid";
$conn->query($sql);
$sql = "delete from `hotel_booking` where booking_id = $bid";
$conn->query($sql);
$sql = "delete from `bookings` where booking_id = $bid";
$conn->query($sql);
header("Location: ./plans.php");
}