Advertisement
Guest User

Untitled

a guest
May 2nd, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.66 KB | None | 0 0
  1. $servername = "localhost";
  2. $username = "root";
  3. $password = "";
  4. $db = "titan3d";
  5.  
  6. $name = $_SESSION['name'];
  7. $nic = $_SESSION['nic'];
  8. $email = $_SESSION['email'];
  9. $teleno = $_SESSION['teleno'];
  10. $sdate = $_SESSION['sdate'];
  11. $stime = $_SESSION['stime'];
  12. $now = $_SESSION['now'];
  13.  
  14. $bookseat = array(11, 18, 12);
  15. $arrlength = count($bookseat);
  16.  
  17. if(isset($_POST['name']))
  18.     {
  19.         $name = $_POST["name"];
  20.     }
  21. if(isset($_POST['nic']))
  22.     {
  23.         $nic = $_POST["nic"];
  24.     }
  25. if(isset($_POST['email']))
  26.     {
  27.         $email = $_POST["email"];
  28.     }
  29. if(isset($_POST['teleno']))
  30.     {
  31.         $teleno = $_POST["teleno"];
  32.     }
  33. if(isset($_POST['sdate']))
  34.     {
  35.         $sdate = $_POST["sdate"];
  36.     }
  37. if(isset($_POST['stime']))
  38.     {
  39.         $stime = $_POST["stime"];
  40.     }
  41. if(isset($_POST['now']))
  42.     {
  43.         $now = $_POST["now"];
  44.     }
  45.  
  46. $conn = new mysqli($servername, $username, $password, $db);
  47.  
  48. if ($conn->connect_error) {
  49.     die("Connection failed: " . $conn->connect_error);  
  50. }
  51.  
  52. $sql = "INSERT INTO bookings (name, nic, email, teleno, sdate, stime)
  53. VALUES ('$name', '$nic', '$email', '$teleno', '$sdate', '$stime')";
  54. $bookings_added = $conn->query($sql);
  55. for($i = 0; $i < count($bookseat); ++$i){
  56.     $SQL_project_has_type = "INSERT INTO bookseat (seat, bid)
  57.         VALUES({$bookseat[$i]}, ".$conn->insert_id.")";
  58.     $bs = $conn->query($conn, $SQL_project_has_type);
  59.  
  60.     if($bs === FALSE) exit("mysql error: ".$mysqli->error);
  61. }
  62.  
  63. if ($bookings_added !== FALSE) {
  64.     header('Location: http://localhost/My%20Project/booksuccess.html');
  65. } else {
  66.     echo "Error: " . $sql . "<br>" . $conn->error;
  67. }
  68.  
  69. $conn->close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement