Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $servername = "localhost";
- $username = "root";
- $password = "";
- $db = "titan3d";
- $name = $_SESSION['name'];
- $nic = $_SESSION['nic'];
- $email = $_SESSION['email'];
- $teleno = $_SESSION['teleno'];
- $sdate = $_SESSION['sdate'];
- $stime = $_SESSION['stime'];
- $now = $_SESSION['now'];
- $bookseat = array(11, 18, 12);
- $arrlength = count($bookseat);
- if(isset($_POST['name']))
- {
- $name = $_POST["name"];
- }
- if(isset($_POST['nic']))
- {
- $nic = $_POST["nic"];
- }
- if(isset($_POST['email']))
- {
- $email = $_POST["email"];
- }
- if(isset($_POST['teleno']))
- {
- $teleno = $_POST["teleno"];
- }
- if(isset($_POST['sdate']))
- {
- $sdate = $_POST["sdate"];
- }
- if(isset($_POST['stime']))
- {
- $stime = $_POST["stime"];
- }
- if(isset($_POST['now']))
- {
- $now = $_POST["now"];
- }
- $conn = new mysqli($servername, $username, $password, $db);
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "INSERT INTO bookings (name, nic, email, teleno, sdate, stime)
- VALUES ('$name', '$nic', '$email', '$teleno', '$sdate', '$stime')";
- $bookings_added = $conn->query($sql);
- for($i = 0; $i < count($bookseat); ++$i){
- $SQL_project_has_type = "INSERT INTO bookseat (seat, bid)
- VALUES({$bookseat[$i]}, ".$conn->insert_id.")";
- $bs = $conn->query($conn, $SQL_project_has_type);
- if($bs === FALSE) exit("mysql error: ".$mysqli->error);
- }
- if ($bookings_added !== FALSE) {
- header('Location: http://localhost/My%20Project/booksuccess.html');
- } else {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- $conn->close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement