Advertisement
Guest User

Untitled

a guest
Sep 15th, 2019
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.99 KB | None | 0 0
  1. if(isset($_POST["auto_submit"]))
  2.     {
  3.         if(isset($_POST["start_addr"]) && isset($_POST["end_addr"]) && isset($_POST["max_claims"]) && isset($_POST["average_claims"]))
  4.         {
  5.             $start_date = "";
  6.             $end_date = "";
  7.             $start_addr = mysqli_real_escape_string($connection,$_POST["start_addr"]);
  8.             $end_addr = mysqli_real_escape_string($connection,$_POST["end_addr"]);
  9.             $max_claims = mysqli_real_escape_string($connection,$_POST["max_claims"]);
  10.             $average_claims = mysqli_real_escape_string($connection,$_POST["average_claims"]);
  11.             $date = date('Y-m-d');
  12.  
  13.             if(isset($_POST["start_date"]) && isset($_POST["end_date"]))
  14.             {
  15.                 $start_date = $_POST["start_date"];
  16.                 $end_date = $_POST["end_date"];
  17.                 $sql = "UPDATE appointments SET confirmed='yes' WHERE confirmed='no' AND author='$email' AND (appt_date BETWEEN '$start_date' AND '$end_date')";
  18.                 mysqli_query($connection,$sql);
  19.             }
  20.             else
  21.             {
  22.                 $sql = "UPDATE appointments SET confirmed='yes' WHERE confirmed='no' AND author='$email'";
  23.                 mysqli_query($connection,$sql);
  24.             }
  25.  
  26.             $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);
  27.             $_SESSION["map_data"] = $map_data;
  28.             $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;
  29.             $_SESSION["map_query"] = $url_query;
  30.             $_SESSION['current_address'] = $start_addr;
  31.  
  32.             $sql = "INSERT INTO maps(query,email,created_date) VALUES('$url_query','$email','$date')";
  33.             mysqli_query($connection,$sql);
  34.  
  35.             header("Location: " . $url_query);
  36.         }
  37.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement