Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(isset($_POST["auto_submit"]))
- {
- if(isset($_POST["start_addr"]) && isset($_POST["end_addr"]) && isset($_POST["max_claims"]) && isset($_POST["average_claims"]))
- {
- $start_date = "";
- $end_date = "";
- $start_addr = mysqli_real_escape_string($connection,$_POST["start_addr"]);
- $end_addr = mysqli_real_escape_string($connection,$_POST["end_addr"]);
- $max_claims = mysqli_real_escape_string($connection,$_POST["max_claims"]);
- $average_claims = mysqli_real_escape_string($connection,$_POST["average_claims"]);
- $date = date('Y-m-d');
- if(isset($_POST["start_date"]) && isset($_POST["end_date"]))
- {
- $start_date = $_POST["start_date"];
- $end_date = $_POST["end_date"];
- $sql = "UPDATE appointments SET confirmed='yes' WHERE confirmed='no' AND author='$email' AND (appt_date BETWEEN '$start_date' AND '$end_date')";
- mysqli_query($connection,$sql);
- }
- else
- {
- $sql = "UPDATE appointments SET confirmed='yes' WHERE confirmed='no' AND author='$email'";
- mysqli_query($connection,$sql);
- }
- $map_data = array('start_date' => $start_date,'end_date' => $end_date,'start_address' => $start_addr,'end_address' => $end_addr,'max_c' => $max_claims,'a_c' => $average_claims);
- $_SESSION["map_data"] = $map_data;
- $url_query = "map.php?sdate=" . $start_date . "&edate=" . $end_date . "&address=" . $start_addr . "&end_address=" . $end_addr . "&max_claims=" . $max_claims . "&average_claims=" . $average_claims;
- $_SESSION["map_query"] = $url_query;
- $_SESSION['current_address'] = $start_addr;
- $sql = "INSERT INTO maps(query,email,created_date) VALUES('$url_query','$email','$date')";
- mysqli_query($connection,$sql);
- header("Location: " . $url_query);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement