1#@!#!123s

https 1#@!#!123s
: / home5 / ragvieco / www /
Filename : product-1.php
back
<?php
include_once 'function.php';

// ✅ Get logged-in session
$registered_users_id = session_id();
$session_id = $registered_users_id;

// ✅ Fix Product ID
$ID = isset($_GET['id']) ? $_GET['id'] : 0;
if (!is_numeric($ID)) {
    $decoded = base64_decode($ID, true);
    $ID = is_numeric($decoded) ? $decoded : 0;
}
$ID = (int)$ID;

// ✅ Get Product Details
$get_product = mysqli_query($connect, "SELECT * FROM product WHERE product_id = '$ID'") or die(mysqli_error($connect));
if (mysqli_num_rows($get_product) == 0) {
    die("Product not found");
}

$product_data = mysqli_fetch_assoc($get_product);

$product_id = $product_data['product_id'];
$organic_menu_id = $product_data['organic_menu_id'];
$product_name = $product_data['product_name'];
$product_description = $product_data['product_description'];
$product_price = $product_data['product_price'];
$mrp_price = $product_data['mrp_price'];
$product_image = $product_data['product_image'];
$product_ingredients = $product_data['product_ingredients'];
$product_features = $product_data['product_features'];
$quantity = $product_data['quantity'] ?? 100; // Default fallback
$Discount = ($mrp_price - $product_price) / $product_price * 100;

$Admin_shipping_price = 50; // Default shipping if DB fails

// ✅ Handle Add to Cart
if ($_SERVER['REQUEST_METHOD'] == "POST" && isset($_POST['add']) && $_POST['add'] == 'Create') {

   $product_id = intval($_POST['product_id']);
   $product_price = floatval($_POST['product_price']);
   $organic_menu_id = intval($_POST['organic_menu_id']);
   $order_date = date("Y-m-d");
   $quantity_ordered = intval($_POST['quantity']);
   $size = isset($_POST['size']) ? mysqli_real_escape_string($connect, $_POST['size']) : '';
   $shipping_pincode = isset($_POST['pincode']) ? $_POST['pincode'] : '';
   $order_price = $quantity_ordered * $product_price;

   if (empty($size)) {
        echo "<script>alert('Please select the size'); window.location.href='shopping-cart.php';</script>";
        exit();
   }

   $shipping_price = pincodepriceDB($shipping_pincode);
   if (empty($shipping_price)) {
        $shipping_price = $Admin_shipping_price;
   }

   $get_cart = mysqli_query($connect, "SELECT * FROM order_cart_add WHERE session_id = '$session_id' AND status='no'") or die(mysqli_error($connect));
   $cart_count = mysqli_num_rows($get_cart);

   if ($cart_count == 0) {
        mysqli_query($connect, "INSERT INTO order_cart_add (session_id, order_date, shipping_price, shipping_pincode, size) 
            VALUES ('$session_id', '$order_date', '$shipping_price', '$shipping_pincode', '$size')") or die(mysqli_error($connect));
   } else {
        $get_cart_value = mysqli_fetch_assoc($get_cart);
        $order_cart_add_id = $get_cart_value['order_cart_add_id'];
        mysqli_query($connect, "UPDATE order_cart_add SET shipping_price='$shipping_price', shipping_pincode='$shipping_pincode' 
            WHERE order_cart_add_id = '$order_cart_add_id'") or die(mysqli_error($connect));
   }

   $res = mysqli_query($connect, "SELECT * FROM order_cart WHERE session_id='$session_id' AND product_id = $product_id AND orderStatus ='no'") or die(mysqli_error($connect));
   $count = mysqli_num_rows($res);

   if ($count == 0) {
        mysqli_query($connect, "INSERT INTO order_cart (product_id, session_id, quantity, order_price, orderStatus, size) 
            VALUES ('$product_id', '$session_id', '$quantity_ordered', '$order_price', 'no', '$size')") or die(mysqli_error($connect));
   } else {
        $row = mysqli_fetch_assoc($res);
        $qty = $row['quantity'] + $quantity_ordered;
        $new_price = $qty * $product_price;
        $order_cart_id = $row['order_cart_id'];

        mysqli_query($connect, "UPDATE order_cart SET order_price='$new_price', quantity='$qty', orderStatus='no' 
            WHERE order_cart_id = '$order_cart_id'") or die(mysqli_error($connect));
   }

   echo "<div style='width:350px; text-align:center; margin:20% auto; font-family:arial; font-size:14px; border:1px solid #ddd; padding:20px 40px;'>
            Please wait while we update cart...</div>";
   echo "<script>setTimeout(function(){ window.location='shopping-cart.php'; },1000);</script>";
   exit();
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>Product | <?php echo $product_name; ?></title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link rel="stylesheet" href="plugins/bootstrap4/css/bootstrap.min.css">
    <link rel="stylesheet" href="css/style.css">
    <link href="img/ragvilogo.png" rel="shortcut icon" type="image/png">
    <style>
        .col-md-5 { margin-top:100px; }
        body { margin-top:100px; }
    </style>
</head>

<body>
<div class="ps-page">
<?php include 'header.php'; ?>

<div class="ps-product--layout-1">
<div class="container">
    <ul class="ps-breadcrumb">
        <li class="ps-breadcrumb__item"><a href="index.php">Home</a></li>
        <li class="ps-breadcrumb__item"><a href="#">Shop</a></li>
        <li class="ps-breadcrumb__item active"><?php echo $product_name; ?></li>
    </ul>

    <div class="ps-product--detail">
        <div class="row flex-nowrap">
            <div class="col-12 col-md-7">
                <div class="ps-product--gallery">
                    <div class="ps-gallery--image">
                        <div class="slide">
                            <div class="ps-gallery__item">
                                <img src="admin/product/<?php echo $product_image; ?>" alt="<?php echo $product_name; ?>">
                            </div>
                        </div>
                    </div>
                    <div class="ps-product__thumbnail">
                        <div class="slide"><img src="admin/product/<?php echo $product_image; ?>" alt="<?php echo $product_name; ?>"></div>
                    </div>
                </div>
            </div>

            <div class="col-12 col-md-5">
                <h2><?php echo $product_name; ?></h2>
                <form action="" method="POST">
                    <input type="hidden" name="product_id" value="<?php echo $product_id; ?>">
                    <input type="hidden" name="organic_menu_id" value="<?php echo $organic_menu_id; ?>">
                    <input type="hidden" name="session_id" value="<?php echo $session_id; ?>">
                    <input type="hidden" name="product_price" value="<?php echo $product_price; ?>">
                    <input type="hidden" name="registered_users_id" value="<?php echo $registered_users_id; ?>">

                    <div class="ps-product__price">
                        <h6>Price: <span style="color:#ff0000;">₹<?php echo number_format($product_price, 2); ?></span></h6>
                    </div>

                    <div class="ps-product__feature">
                        <h6>Size</h6>
                        <div class="ps-product__size">
                            <label><input type="radio" name="size" value="XL" required> XL</label>
                            <label><input type="radio" name="size" value="L"> L</label>
                            <label><input type="radio" name="size" value="M"> M</label>
                            <label><input type="radio" name="size" value="S"> S</label>
                        </div>
                    </div>

                    <div class="ps-product__quantity">
                        <h6>Quantity</h6>
                        <input type="number" class="form-control" name="quantity" min="1" max="100" value="1">
                    </div>

                    <button type="submit" class="ps-btn" name="add" value="Create">Add to Cart</button>
                </form>
            </div>
        </div>
    </div>
</div>
</div>

<?php include 'footer.php'; ?>
</div>

<script src="plugins/jquery.min.js"></script>
<script src="plugins/bootstrap4/js/bootstrap.min.js"></script>
<script src="js/main.js"></script>
</body>
</html>