D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
newpcjewellers.in
/
Filename :
order.php
back
Copy
<?php // Include database connection include 'config.php'; // Ensure this file contains secure and correct database connection settings // Initialize product_id variable $product_id = null; // Check if the product ID is set in the URL if (isset($_GET['product'])) { $product_id = intval($_GET['product']); // Sanitize and convert to integer } if ($_SERVER['REQUEST_METHOD'] == 'POST') { // Retrieve form data with validation $name = isset($_POST['name']) ? $_POST['name'] : ''; $phone = isset($_POST['phone']) ? $_POST['phone'] : ''; $location = isset($_POST['location']) ? $_POST['location'] : ''; $address = isset($_POST['address']) ? $_POST['address'] : ''; $city = isset($_POST['city']) ? $_POST['city'] : ''; $state = isset($_POST['state']) ? $_POST['state'] : ''; // Check if 'state' exists $pin = isset($_POST['pin']) ? $_POST['pin'] : ''; // Prepare the query $query = "INSERT INTO customer_orders (name, phone, location, address, city, state, pin, product_id, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, NOW())"; $stmt = $conn->prepare($query); // Check for query preparation errors if (!$stmt) { die("Query preparation failed: " . $conn->error); } // Bind parameters $stmt->bind_param("ssssssss", $name, $phone, $location, $address, $city, $state, $pin, $product_id); // Execute the query if ($stmt->execute()) { echo "Order submitted successfully!"; } else { echo "Error: " . $stmt->error; } } // Initialize product details variables $product_name = ''; $product_image = ''; $product_category_name = ''; $product_metal = ''; $product_purity = ''; $product_weight = ''; $product_certification = ''; // Fetch product details if product_id is set if ($product_id) { // Update query to join with the categories table $query = "SELECT p.name, p.image1, c.category_name, p.metal, p.purity, p.weight, p.certification FROM products p JOIN product_category c ON p.category = c.id WHERE p.id = ?"; $stmt = $conn->prepare($query); // Check for query preparation errors if (!$stmt) { die("Query preparation failed: " . $conn->error); } // Bind parameters $stmt->bind_param("i", $product_id); // Execute the query if ($stmt->execute()) { $result = $stmt->get_result(); if ($result->num_rows > 0) { $product = $result->fetch_assoc(); $product_name = $product['name']; $product_image = $product['image1']; $product_category_name = $product['category_name']; $product_metal = $product['metal']; $product_purity = $product['purity']; $product_weight = $product['weight']; $product_certification = $product['certification']; } else { echo "No product found!"; } } else { echo "Error: " . $stmt->error; } } ?> <!DOCTYPE html> <html lang="en"> <meta http-equiv="content-type" content="text/html;charset=UTF-8" /><!-- /Added by HTTrack --> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>New PC Jewellers</title> <!--Favicons--> <link rel="icon" type="image/png" sizes="32x32" href="images/favicon.png"> <meta name="msapplication-TileColor" content="#ffffff"> <meta name="theme-color" content="#ffffff"> <!--Bootstrap and Other Vendors--> <link rel="stylesheet" href="css/bootstrap.min.css"> <link rel="stylesheet" href="css/bootstrap-theme.min.css"> <link rel="stylesheet" href="css/bootstrap-datepicker.min.css"> <link rel="stylesheet" href="css/jquery.fancybox.min.css" /> <link rel="stylesheet" href="css/jquery-ui.css"> <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet"> <link rel="stylesheet" href="css/fontawesome-all.min.css"> <link rel="stylesheet" href="vendors/owl.carousel/css/owl.carousel.min.css"> <link rel="stylesheet" type="text/css" href="vendors/flexslider/flexslider.css" media="screen" /> <!--Fonts--> <link href="https://fonts.googleapis.com/css2?family=Domine:wght@400;500;600;700&display=swap" rel="stylesheet"> <link href="https://fonts.googleapis.com/css2?family=Quicksand:wght@300;400;500;600;700&display=swap" rel="stylesheet"> <link rel="preconnect" href="https://fonts.googleapis.com/"> <link rel="preconnect" href="https://fonts.gstatic.com/" crossorigin> <link href="https://fonts.googleapis.com/css2?family=Cormorant+Garamond:wght@300;400&display=swap" rel="stylesheet"> <!--Mechanic Styles--> <link rel="stylesheet" href="css/style.css"> <link rel="stylesheet" href="css/responsive.css"> </head> <body class="home-2"> <a href="#" id="back-to-top" title="Back to top">↑</a> <div class="innerLayout"> <?php require('header.php') ?> <section id="breadcrumbRow" class="row"> <h2>Order Jewellery</h2> <div class="row pageTitle m0"> <div class="container"> <h4 class="fleft">checkout</h4> <ul class="breadcrumb"> <li><a href="index-2.html">home</a></li> <li class="active">Order Jewellery</li> </ul> </div> </div> </section> <section class="row contentRowPad"> <div class="container"> <form action="" method="post" role="form" class="row checkoutForm" autocomplete="off"> <div class="row m0"> <div class="col-sm-6" id="billingAddress"> <h4 class="heading">Billing Address</h4> <span class="responseData"></span> <div class="row"> <div class="col-sm-6"> <div class="input-group"> <input type="text" name="name" id="ordr_name" placeholder="Full Name" class="form-control"> <span class="error_field" id="name_error"></span> </div> </div> <div class="col-sm-6"> <div class="input-group"> <input type="tel" name="phone" id="ordr_phone" max="12" placeholder="Phone" class="form-control"> <span class="error_field" id="phone_error"></span> </div> </div> <div class="col-sm-12"> <div class="input-group"> <input type="text" name="location" id="ordr_nearLocation" placeholder="Near By Location" class="form-control"> <span class="error_field" id="nearLocation_error"></span> </div> <div class="input-group"> <input type="text" name="address" id="ordr_address" placeholder="Address" class="form-control"> <span class="error_field" id="address_error"></span> </div> <div class="input-group"> <input type="text" name="city" id="ordr_city" placeholder="Town / City / Village" class="form-control"> <span class="error_field" id="city_error"></span> </div> </div> <div class="col-sm-6"> <div class="input-group"> <select id="ordr_state" name="state" class="form-control"> <option value="">Select State</option> <option value="1">ANDAMAN AND NICOBAR ISLANDS</option> <option value="2">ANDHRA PRADESH</option> <option value="3">ARUNACHAL PRADESH</option> <option value="4">ASSAM</option> <option value="5">BIHAR</option> <option value="6">CHATTISGARH</option> <option value="7">CHANDIGARH</option> <option value="8">DAMAN AND DIU</option> <option value="9">DELHI</option> <option value="10">DADRA AND NAGAR HAVELI</option> <option value="11">GOA</option> <option value="12">GUJARAT</option> <option value="13">HIMACHAL PRADESH</option> <option value="14">HARYANA</option> <option value="15">JAMMU AND KASHMIR</option> <option value="16">JHARKHAND</option> <option value="17">KERALA</option> <option value="18">KARNATAKA</option> <option value="19">LADDAKH</option> <option value="20">LAKSHADWEEP</option> <option value="21">MEGHALAYA</option> <option value="22">MAHARASHTRA</option> <option value="23">MANIPUR</option> <option value="24">MADHYA PRADESH</option> <option value="25">MIZORAM</option> <option value="26">NAGALAND</option> <option value="27">ORISSA</option> <option value="28">PUNJAB</option> <option value="29">PONDICHERRY</option> <option value="30">RAJASTHAN</option> <option value="31">SIKKIM</option> <option value="32">TAMIL NADU</option> <option value="33">TELANGANA</option> <option value="34">TRIPURA</option> <option value="35">UTTARAKHAND</option> <option value="36">UTTAR PRADESH</option> <option value="37">WEST BENGAL</option> </select> <span class="error_field" id="state_error"></span> </div> </div> <div class="col-sm-6"> <div class="input-group"> <input type="number" name="pin" id="ordr_pin" placeholder="Pincode" class="form-control"> <span class="error_field" id="pin_error"></span> </div> <input type="hidden" id="ordr_product" value="31"> <input type="hidden" id="ordr_category" value="1"> </div> </div> </div> <div class="col-sm-6"> <div class="orderJewelDetailsrow"> <h4 class="heading">Jewellery Details</h4> <div class="row"> <div class="col-lg-4 col-xs-12"> <div class="orderJewelImg"> <img src="newadminpc/uploads/<?php echo htmlspecialchars($product_image); ?>" alt="<?php echo htmlspecialchars($product_name); ?>"> </div> </div> <div class="col-lg-8 col-xs-12"> <div class="orderJewelInfo"> <h3><?php echo htmlspecialchars($product_name); ?></h3> <h5><i class="fas fa-tags"></i> <?php echo htmlspecialchars($product_category_name); ?></h5> <table> <tbody> <tr> <th>Metal</th> <td><?php echo htmlspecialchars($product_metal); ?></td> </tr> <tr> <th>Purity</th> <td><?php echo htmlspecialchars($product_purity); ?></td> </tr> <tr> <th>Weight</th> <td><?php echo htmlspecialchars($product_weight); ?></td> </tr> <tr> <th>Certification</th> <td><?php echo htmlspecialchars($product_certification); ?></td> </tr> </tbody> </table> </div> </div> </div> </div> </div> </div> <div class="row m0"> <div class="col-sm-12"> <button class="btn btn-primary filled btn-sm" type="submit">Submit <i class="fas fa-paper-plane"></i></button> </div> </div> </form> </div> </section> <!-- =================================================================================================================================== --> <section class="social_sec"> <div class="social_div"> <ul class="sociallist"> <li><a href="https://www.facebook.com/newpcjewellersslg01"> <img src="images/icons/facebook.png" alt="social-icon"> </a></li> <li><a href="https://www.instagram.com/newpcjewellerssiliguri/"> <img src="images/icons/instagram.png" alt="social-icon"> </a></li> </ul> </div> <div class="whatsapp_Div"> <a class="video-vemo-icon" href="https://api.whatsapp.com/send/?phone=919734355000"><img src="images/icons/whatsapp.png"></a> </div> </section> <?php require('footer.php') ?> </div> <!-- Button trigger modal --> <!-- <button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#exampleModal"> Launch demo modal </button> --> <div class="modal fade" id="LoginModal" tabindex="-1" role="dialog" aria-labelledby="LoginModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button> <div class="modal-body"> <div class="accountDiv row"> <div class="col-6"> <div class="accountInfo"> <h3>Hello, Friend!</h3> <p>Enter your personal details to start journey with us.</p> <a href="#" class="btn btn-primary">Sign up</a> </div> </div> <div class="col-6"> <div class="accountForm"> <form action="#" method="POST"> <div class="input-group"> <input type="tel" name="" maxlength="10" placeholder="Enter Mobile Number"> </div> </form> </div> </div> </div> </div> </div> </div> </div> <!--jQuery--> <script src="js/jquery-2.1.3.min.js"></script> <!--Bootstrap JS--> <script src="js/bootstrap.min.js"></script> <script src="js/bootstrap-datepicker.min.js"></script> <script src="js/jquery.fancybox.min.js"></script> <script src="js/jquery-ui.js"></script> <script src="js/popper.min.js"></script> <script src="js/zoom.js"></script> <!--Owl Carousel--> <script src="vendors/owl.carousel/js/owl.carousel.min.js"></script> <!--Isotope--> <script src="vendors/isotope/isotope-custom.js"></script> <script src="js/imagesloaded.pkgd.min.js"></script> <!--FlexSlider--> <script src="vendors/flexslider/jquery.flexslider-min.js"></script> <!--Regalia JS--> <script src="js/regalia.js"></script> <script async defer crossorigin="anonymous" src="../connect.facebook.net/en_US/sdk.js#xfbml=1&version=v11.0" nonce="wjI79STh"></script> </body> <!-- Mirrored from newpcjewellers.in/order?product=SjRBQkpnb3hIZXUwK1VVMXZNbHZVZz09 by HTTrack Website Copier/3.x [XR&CO'2014], Tue, 03 Sep 2024 09:29:54 GMT --> </html> <script> function submitOrder() { var name = $('#ordr_name').val(); // alert(name); var phone = $('#ordr_phone').val(); // var email = $('#ordr_email').val(); // var gender = $('#ordr_gender').val(); var nearLocation = $('#ordr_nearLocation').val(); var address = $('#ordr_address').val(); var city = $('#ordr_city').val(); var state = $('#ordr_state').val(); var pin = $('#ordr_pin').val(); var product = $('#ordr_product').val(); var category = $('#ordr_category').val(); $('.error_field').html(''); var is_error = ''; if (name == '') { $('#name_error').html('Please Enter Full Name.').css("color", "red"); is_error = 'yes'; } if (phone == '') { $('#phone_error').html('Please Enter Phone Number.').css("color", "red"); is_error = 'yes'; } if (nearLocation == '') { $('#nearLocation_error').html('Please Enter Near Location.').css("color", "red"); is_error = 'yes'; } if (address == '') { $('#address_error').html('Please Enter Your address.').css("color", "red"); is_error = 'yes'; } if (city == '') { $('#city_error').html('Please Enter Your City.').css("color", "red"); is_error = 'yes'; } if (state == '') { $('#state_error').html('Please select State Name').css("color", "red"); is_error = 'yes'; } if (pin == '') { $('#pin_error').html('Please Enter Pincode').css("color", "red"); is_error = 'yes'; } if (is_error == '') { var action = 'order_action'; var datastr = 'name=' + name + '&phone=' + phone + '&location=' + nearLocation + '&address=' + address + '&city=' + city + '&state=' + state + '&pin=' + pin + '&product=' + product + '&category=' + category + '&action=' + action; // alert(datastr); $.ajax({ url: 'enquiry_submit.php', type: 'POST', data: datastr, success: function(data) { alert(data); window.location.href = "index.html"; // $('.responseData').html(data); } }); } } </script>