Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once('db.php');
- if (isset($_POST['id'])) {
- $conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $values = "('1','". $_POST['id'] ."','". $_POST['quantity'] ."','". $_POST['date'] ."')";
- $sql = "INSERT INTO booking (customerId,productId,quantity,bookingDate) VALUES $values";
- if ($conn->query($sql) === TRUE) {
- } else {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- $conn->close();
- }
- if (isset($_POST['remove'])) {
- $conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "DELETE FROM booking WHERE id=" . $_POST['remove'];
- if ($conn->query($sql) === TRUE) {
- } else {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- $conn->close();
- }
- ?>
- <!doctype html>
- <html class="no-js" lang="zxx">
- <head>
- <meta charset="utf-8">
- <meta http-equiv="x-ua-compatible" content="ie=edge">
- <title>Checkout</title>
- <meta name="description" content="">
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <!-- <link rel="manifest" href="site.webmanifest"> -->
- <link rel="shortcut icon" type="image/x-icon" href="img/favicon.png">
- <!-- Place favicon.ico in the root directory -->
- <!-- CSS here -->
- <link rel="stylesheet" href="css/bootstrap.min.css">
- <link rel="stylesheet" href="css/owl.carousel.min.css">
- <link rel="stylesheet" href="css/magnific-popup.css">
- <link rel="stylesheet" href="css/font-awesome.min.css">
- <link rel="stylesheet" href="css/themify-icons.css">
- <link rel="stylesheet" href="css/nice-select.css">
- <link rel="stylesheet" href="css/flaticon.css">
- <link rel="stylesheet" href="css/jquery-ui.css">
- <link rel="stylesheet" href="css/gijgo.css">
- <link rel="stylesheet" href="css/animate.css">
- <link rel="stylesheet" href="css/slick.css">
- <link rel="stylesheet" href="css/slicknav.css">
- <link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
- <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Raleway">
- <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
- <link rel="stylesheet" href="css/style.css">
- <!-- <link rel="stylesheet" href="css/responsive.css"> -->
- </head>
- <body>
- <!--[if lte IE 9]>
- <p class="browserupgrade">You are using an <strong>outdated</strong> browser. Please <a href="https://browsehappy.com/">upgrade your browser</a> to improve your experience and security.</p>
- <![endif]-->
- <!-- header-start -->
- <header>
- <div class="header-area ">
- <div id="sticky-header" class="main-header-area">
- <div class="container-fluid">
- <div class="header_bottom_border">
- <div class="row align-items-center">
- <div class="col-xl-6 col-lg-6">
- <div class="main-menu d-none d-lg-block">
- <nav>
- <ul id="navigation">
- <li><img src="img/logotransparent.png" width="150" height="50"></li>
- <li><a class="active" href="index.html">home</a></li>
- <li><a class="" href="travel_destination.html">Destinations</a></l/li>
- <li><a href="mainbookingpage.php">Bookings</a></li>
- <li><a href="about.html">About Us</a></li>
- </ul>
- </nav>
- </div>
- </div>
- <div class="col-xl-6 col-lg-6">
- <div class="main-menu d-flex align-items-center justify-content-end">
- <nav>
- <ul id="navigation">
- <li><a href="login.html">Login</a></li>
- <a href="signup.html" class="genric-btn primary circle">Sign-Up</a>
- </ul>
- </nav>
- </div>
- </div>
- <div class="col-12">
- <div class="mobile_menu d-block d-lg-none"></div>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- </header>
- <!-- header-end -->
- <div class="setting_first_area">
- <!-- Page content -->
- <div class="row">
- <div class="col-12">
- <div class="modal-center">
- <div class="title-section">
- Checkout
- </div>
- <img src="checkout/checkoutprocess2.png" style="width: 600px; height: 200px;">
- </div>
- </div>
- </div>
- <div class="container">
- <div class="border setting_second_area">
- <h3 class="bold-text">YOUR CART</h3>
- <hr>
- <?php
- $conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $result = $conn->query("SELECT * FROM booking");
- if ($result->num_rows > 0) {
- while($order = $result->fetch_assoc()) {
- $products = $conn->query("SELECT * FROM product WHERE id=" . $order['productId']);
- while($product = $products->fetch_assoc()) {
- $picture = $conn->query("SELECT * FROM product_images WHERE productId=" . $order['productId']);
- $pictures = array();
- while($pic = $picture->fetch_assoc()) {
- array_push($pictures,$pic);
- }
- echo '<form class="row" method="POST" action="' . $_SERVER['PHP_SELF'] . '">';
- echo '<div class="col-4">';
- echo '<div class="row">';
- echo '<div class="col-6">';
- echo '<div class="dimg">';
- echo '<div class="col-8">';
- echo '<img src="'. $pictures[0]['path'] .'" width="300" height="200"';
- echo '</div>';
- echo '</div>';
- echo '</div>';
- echo '</div>';
- echo '</div>';
- echo '</div>';
- echo '<div class="col-8">';
- echo '<div class="row">';
- echo '<h3>'. $product['name'] .'</h3>';
- echo '</div>';
- echo '<f class="row">';
- echo '<div class="col-5 ticket-info">';
- echo '<div class="form-group row">';
- echo '<label for="datetime-booking-date" style="color:black" class="col-6 col-form-label">Booking Date</label>';
- echo '<div class="col-10">';
- echo '<input class="form-control" type="date" id="date-booking-date" value="'. $order['bookingDate'] .'">';
- echo '</div>';
- echo '</div>';
- echo '<div class="form-group row">';
- echo '<label for="book-quantity" style="color:black" class="col-6 col-form-label">Quantity</label>';
- echo '<div class="col-10">';
- echo '<input class="form-control" type="number" min="0" id="book-quantity" value="'. $order['quantity'] .'">';
- echo '</div>';
- echo '</div>';
- echo '</div>';
- echo '<div class="col-2"></div>';
- echo '<div class="col-4">';
- echo '<div class="modal-center">';
- echo '<h2>₱ '. ($order['quantity'] * $product['price']) .'</h2>';
- echo '</div>';
- echo '<div class="row">';
- echo '<div class="col-4"></div>';
- echo '<input type="submit" class="genric-btn primary radius" value="remove"/>';
- echo '</div>';
- echo '</div>';
- echo '</div>';
- echo '<input type="hidden" name="remove" value="'. $order["id"] .'">';
- echo '</form>';
- echo '<hr>';
- }
- }
- }
- $conn->close();
- ?>
- <div class="row">
- <div class="col">
- <a href="mainbookingpage.php"><img src="img/backbutton.png" width="50" height="50"></a>
- </div>
- <div class="col float-child-right">
- <div class="mt-12">
- <a href="payment.html" class="boxed-btn">Proceed to Payment</a>
- </div>
- </div>
- </div>
- </div>
- <!-- JS here -->
- <script src="js/vendor/modernizr-3.5.0.min.js"></script>
- <script src="js/vendor/jquery-1.12.4.min.js"></script>
- <script src="js/popper.min.js"></script>
- <script src="js/bootstrap.min.js"></script>
- <script src="js/owl.carousel.min.js"></script>
- <script src="js/isotope.pkgd.min.js"></script>
- <script src="js/ajax-form.js"></script>
- <script src="js/waypoints.min.js"></script>
- <script src="js/jquery.counterup.min.js"></script>
- <script src="js/imagesloaded.pkgd.min.js"></script>
- <script src="js/scrollIt.js"></script>
- <script src="js/jquery.scrollUp.min.js"></script>
- <script src="js/wow.min.js"></script>
- <script src="js/jquery-ui.min.js"> </script>
- <script src="js/nice-select.min.js"></script>
- <script src="js/jquery.slicknav.min.js"></script>
- <script src="js/jquery.magnific-popup.min.js"></script>
- <script src="js/plugins.js"></script>
- <script src="js/range.js"></script>
- <!-- <script src="js/gijgo.min.js"></script> -->
- <script src="js/slick.min.js"></script>
- <!--contact js-->
- <script src="js/contact.js"></script>
- <script src="js/jquery.ajaxchimp.min.js"></script>
- <script src="js/jquery.form.js"></script>
- <script src="js/jquery.validate.min.js"></script>
- <script src="js/mail-script.js"></script>
- <script src="js/main.js"></script>
- <script>
- if ( window.history.replaceState ) {
- window.history.replaceState( null, null, window.location.href );
- }
- $('#datepicker').datepicker({
- iconsLibrary: 'fontawesome',
- icons: {
- rightIcon: '<span class="fa fa-caret-down"></span>'
- }
- });
- </script>
- </script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement