관리-도구
편집 파일: checkout.php
<?php session_start(); include 'connection.php'; if (isset($_POST['submit'])) { extract($_POST); $id= $_GET['id']; $total= $_GET['total']; $uid= $_SESSION['user_id'] ; // Define the SQL query with placeholders $sql = "INSERT INTO user_address (user_id,first_name, last_name, address, landmark, towncity, district, postcode, state, email, phone, act_date, payment_id, payment_status, pay_amount, size,product_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, curdate(), ?, ?, ?,?,?)"; $stmt = $conn->prepare($sql); // Set variables for NULL and pending values $nullValue = 'pending'; $pendingValue = 'pending'; $size = 'Small'; $stmt->bind_param("issssssssssssssi", $uid, $fname, $lname, $add, $lm, $town, $dis, $pcode, $state, $email, $mobile, $nullValue, $pendingValue, $total, $size, $id); // Execute the prepared statement if ($stmt->execute()) { // Insertion successful // echo 'Address added successfully'; // return redirect('payment.php'); // Redirect to a suitable page // header("Location: index.php"); // exit(); // You don't need to exit here } else { // Insertion failed echo 'Error: ' . $stmt->error; } // Close the prepared statement $stmt->close(); } // Rest of your HTML and PHP code for product details ?> <!DOCTYPE html> <html lang="en"> <head> <title>Shoping Cart</title> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <!--===============================================================================================--> <link rel="icon" type="image/png" href="images/icons/favicon.png" /> <!--===============================================================================================--> <link rel="stylesheet" type="text/css" href="vendor/bootstrap/css/bootstrap.min.css"> <!--===============================================================================================--> <link rel="stylesheet" type="text/css" href="fonts/font-awesome-4.7.0/css/font-awesome.min.css"> <!--===============================================================================================--> <link rel="stylesheet" type="text/css" href="fonts/iconic/css/material-design-iconic-font.min.css"> <!--===============================================================================================--> <link rel="stylesheet" type="text/css" href="fonts/linearicons-v1.0.0/icon-font.min.css"> <!--===============================================================================================--> <link rel="stylesheet" type="text/css" href="vendor/animate/animate.css"> <!--===============================================================================================--> <link rel="stylesheet" type="text/css" href="vendor/css-hamburgers/hamburgers.min.css"> <!--===============================================================================================--> <link rel="stylesheet" type="text/css" href="vendor/animsition/css/animsition.min.css"> <!--===============================================================================================--> <link rel="stylesheet" type="text/css" href="vendor/select2/select2.min.css"> <!--===============================================================================================--> <link rel="stylesheet" type="text/css" href="vendor/perfect-scrollbar/perfect-scrollbar.css"> <!--===============================================================================================--> <link rel="stylesheet" type="text/css" href="css/util.css"> <link rel="stylesheet" type="text/css" href="css/main.css"> <!--===============================================================================================--> </head> <body class="animsition"> <!-- Header --> <?php include 'userheader.php' ?> <!-- Cart --> <?php include 'cart-side.php' ?> <!-- breadcrumb --> <div class="container mt-5"> <div class="bread-crumb flex-w p-l-25 p-r-15 p-t-30 p-lr-0-lg"> <a href="index.php" class="stext-109 cl8 hov-cl1 trans-04"> Home <i class="fa fa-angle-right m-l-9 m-r-10" aria-hidden="true"></i> </a> <span class="stext-109 cl4"> Checkout </span> </div> </div> <!-- Shoping Cart --> <div class="bg0 p-t-75 p-b-85"> <div class="container"> <div class="row"> <div class="col-lg-10 col-xl-7 col-md-6 m-lr-auto m-b-50 "> <div class=" bor10 p-lr-70 p-t-55 p-b-70 p-lr-15-lg w-full-md"> <form method="post"> <h4 class="mtext-105 cl2 txt-center p-b-30"> <strong>Shipping Address</strong> </h4> <div class="container"> <div class="row"> <div class="col-md-6"> <div class="form-group"> <input class="stext-111 cl2 plh3 size-116 p-l-62 p-r-30 form-control" type="text" name="fname" placeholder="First Name"> </div> </div> <div class="col-md-6"> <div class="form-group"> <input class="stext-111 cl2 plh3 size-116 p-l-62 p-r-30 form-control" type="text" name="lname" placeholder="Last Name"> </div> </div> </div> <div class="row"> <div class="col-md-12"> <div class="form-group"> <input class="stext-111 cl2 plh3 size-116 p-l-62 p-r-30 form-control" type="text" name="add" placeholder="Address"> </div> </div> </div> <div class="row"> <div class="col-md-6"> <div class="form-group"> <input class="stext-111 cl2 plh3 size-116 p-l-62 p-r-30 form-control" type="text" name="lm" placeholder="Landmark"> </div> </div> <div class="col-md-6"> <div class="form-group"> <input class="stext-111 cl2 plh3 size-116 p-l-62 p-r-30 form-control" type="text" name="town" placeholder="Town/City"> </div> </div> </div> <div class="row"> <div class="col-md-6"> <div class="form-group"> <input class="stext-111 cl2 plh3 size-116 p-l-62 p-r-30 form-control" type="text" name="dis" placeholder="District"> </div> </div> <div class="col-md-6"> <div class="form-group"> <input class="stext-111 cl2 plh3 size-116 p-l-62 p-r-30 form-control" type="text" name="pcode" placeholder="Post code"> </div> </div> </div> <div class="row"> <div class="col-md-12"> <div class="rs1-select2 rs2-select2 bor8 bg0 m-b-12 m-t-9"> <select class="js-select2" name="state"> <option>Select State</option> <option value="Andhra Pradesh">Andhra Pradesh</option> <option value="Arunachal Pradesh">Arunachal Pradesh</option> <option value="Assam">Assam</option> <option value="Bihar">Bihar</option> <option value="Chandigarh">Chandigarh</option> <option value="Chhattisgarh">Chhattisgarh</option> <option value="Goa">Goa</option> <option value="Gujarat">Gujarat</option> <option value="Haryana">Haryana</option> <option value="Himachal Pradesh">Himachal Pradesh</option> <option value="Jammu and Kashmir">Jammu and Kashmir</option> <option value="Jharkhand">Jharkhand</option> <option value="Karnataka">Karnataka</option> <option value="Kerala">Kerala</option> <option value="Madhya Pradesh">Madhya Pradesh</option> <option value="Maharashtra">Maharashtra</option> <option value="Manipur">Manipur</option> <option value="Meghalaya">Meghalaya</option> <option value="Mizoram">Mizoram</option> <option value="Nagaland">Nagaland</option> <option value="Odisha">Odisha</option> <option value="Punjab">Punjab</option> <option value="Rajasthan">Rajasthan</option> <option value="Sikkim">Sikkim</option> <option value="Tamil Nadu">Tamil Nadu</option> <option value="Telangana">Telangana</option> <option value="Tripura">Tripura</option> <option value="Uttar Pradesh">Uttar Pradesh</option> <option value="Uttarakhand">Uttarakhand</option> <option value="West Bengal">West Bengal</option> </select> </select> <div class="dropDownSelect2"></div> </div> </div> </div> <div class="row"> <div class="col-md-12"> <div class="form-group"> <input class="stext-111 cl2 plh3 size-116 p-l-62 p-r-30 form-control" type="email" name="email" placeholder="Your Email Address"> </div> </div> </div> <div class="row"> <div class="col-md-12"> <div class="form-group"> <input class="stext-111 cl2 plh3 size-116 p-l-62 p-r-30 form-control" type="text" name="mobile" placeholder="Your Mobile Number"> </div> </div> </div> </div> <div class="pt-5"> <button type="submit" name="submit" class="flex-c-m stext-101 cl0 size-121 bg3 bor1 hov-btn3 p-lr-15 trans-04 pointer"> Add Address </button> </div> </form> </div> </div> <div class="col-sm-10 col-lg- col-xl-5 col-md-6 m-lr-auto m-b-50"> <div class="bor10 p-lr-40 p-t-30 p-b-40 m-l-63 m-r-40 m-lr-0-xl p-lr-15-sm"> <h4 class="mtext-109 cl2 p-b-30"> Cart Totals </h4> <div class="wrap-table-shopping-cart"> </div> <?php $total=$_GET['total']; ?> <div class="flex-w flex-t p-t-27 p-b-33"> <div class="size-208"> <span class="mtext-101 cl2"> Total: </span> </div> <div class="size-209 p-t-1"> <span class="mtext-110 cl2"> <strong><?php echo $total;?></strong> </span> </div> </div> <!-- <input type="number" name="amountEnterByUsers" value="$total" id="amountEnterByUsers"> --> <a href="payment.php?total=<?php echo $total ?>"><button class="flex-c-m stext-101 cl0 size-116 bg3 bor14 hov-btn3 p-lr-15 trans-04 pointer"> Proceed to Checkout </button></a> </div> </div> </div> </div> </div> <!-- Footer --> <?php include 'userfooter.php' ?> </body> </html>