Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u184721437

Directory:

/home/u184721437/domains/gr8trend.com/public_html

Free Space:

7.11 TB

🔧 Quick Actions

✏️ Editing: custom-kandora1.php

<?php 
include "include/header.php";
// use PHPMailer\PHPMailer\PHPMailer;
// use PHPMailer\PHPMailer\SMTP;
// use PHPMailer\PHPMailer\Exception;
// require 'PHPMailer/src/Exception.php';
// require 'PHPMailer/src/PHPMailer.php';
// require 'PHPMailer/src/SMTP.php';
// require 'PHPMailer/src/OAuth.php';
// require 'PHPMailer/src/POP3.php';
// require 'PHPMailer/src/IMAP.php';
// require 'PHPMailer/src/SMTP.php';
// require 'PHPMailer/src/PHPMailerAutoload.php';
// require 'PHPMailer/src/PHPMailerOAuth.php';
// require 'PHPMailer/src/PHPMailerPOP3.php';
// require 'PHPMailer/src/PHPMailerIMAP.php';
// require 'PHPMailer/src/PHPMailerSMTP.php';
// require 'PHPMailer/src/PHPMailerException.php';
// require 'PHPMailer/src/PHPMailerOAuthException.php';
// require 'PHPMailer/src/PHPMailerPOP3Exception.php';
// require 'PHPMailer/src/PHPMailerIMAPException.php';
// require 'PHPMailer/src/PHPMailerSMTPException.php';

// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);

$query = mysqli_query($conn, "SELECT * FROM `currency` WHERE status = 1 AND type = '$currencySymbol'");
$currency = mysqli_fetch_array($query);
 ?>
<style>
    ul.nav.nav-pills li button.nav-link.active {
        background: #000;
        color: #fff;
    }

ul.nav.nav-pills li button.nav-link {
        color: #000;    
        background: #dfdfdf;
        margin: 0 5px;
    }
</style>
<div id="page-content">
    <div class="collection-header">
        <div class="collection-hero">
            <div class="collection-hero__image"></div>
            <div class="collection-hero__title-wrapper container">
                <h1 class="collection-hero__title">Custom Kandora</h1>
                <div class="breadcrumbs text-uppercase mt-1 mt-lg-2">
                    <a href="/" title="Back to the home page">Home</a>
                    <span>|</span><span class="fw-bold">Custom Kandora</span>
                </div>
            </div>
        </div>
    </div>

<div class="c-kandora">
        <div class="container">
            <div class="select-kandora">
                <div class="row">
                    <?php
$kandora_category;
$cat_query=mysqli_query($conn,"SELECT * FROM kandora_category_tbl WHERE status=1");
while($cat_row=mysqli_fetch_assoc($cat_query)){
    $kandora_category=$cat_row['id'];
                    ?>
                    <div class="col-lg-3">
                        
                        <button class="btn-ck clickable-div" data-value="<?=$cat_row['title']?>"  data-key='category' data-kandora="<?=$cat_row['id']?>"  onclick="toggleContent(this); toggleContent2(this); cat_fun(<?=$cat_row['id']?>);" >
                            <img src="<?=$base_url?>images/Upload/kandora/<?=$cat_row['image']?>" alt="" class="w-100">
                            <h6><?=$cat_row['title']?></h6>
                            <input type="hidden" name="kandora_name" value="<?=$cat_row['title']?>">
                        </button>
                    </div>
                <?php } ?>
                  
                </div>
            </div>

<div id="hiddenContent">
            <div class="ck-padding">
                <h2 class="text-center">Choose Fabrics</h2>
                <div class="choose-fabrics mb-4">
                    <?php
                    $fabric_type_query = mysqli_query($conn, "SELECT * FROM fabric_type_tbl WHERE status=1");
                    while ($fabric_type_row = mysqli_fetch_assoc($fabric_type_query)) {
                    ?>
                        <a href="#<?=$fabric_type_row['title']?>" class="clickable-div" data-value="<?=$fabric_type_row['title']?>" data-key='Fabrics' data-fabric_type="<?=$fabric_type_row['id']?>">
                            <?=$fabric_type_row['title']?> <br>
                            <span><?=$currencySymbol?> <?=floatval($fabric_type_row['price']) * floatval($currency['conversion'])?></span>
                        </a>
                        <input type="hidden" name="fabric_type" value="<?=$fabric_type_row['title']?>">
                    <?php } ?>
                </div>
            </div>

<?php
            $fabric_type_query2 = mysqli_query($conn, "SELECT * FROM fabric_type_tbl WHERE status=1");
            while ($fabric_type_row2 = mysqli_fetch_assoc($fabric_type_query2)) {
                $fabric_type_id = $fabric_type_row2['id'];
                $fabric_query = mysqli_query($conn, "SELECT * FROM fabric_tbl WHERE status=1 AND fabric_type='$fabric_type_id'");
                while ($fabric_query_data = mysqli_fetch_assoc($fabric_query)) {
                    $fabric_id = $fabric_query_data['id'];
            ?>
                    <div class="ck-padding" id="<?=$fabric_type_row2['title']?>">
                        <h2 class="text-center"><?=$fabric_type_row2['title']?></h2>
                        <h6 class="text-center"><?=$fabric_query_data['title']?></h6>
                        <div class="row cloth-s">
                            <?php
                            $fabric_data_query = mysqli_query($conn, "SELECT * FROM fabric_data_tbl WHERE fabric_id='$fabric_id'");
                            while ($fabric_data_row = mysqli_fetch_assoc($fabric_data_query)) {
                            ?>
                                <a class="bg-select col-md-3 mb-2" href="#front-style" id="" data-fabric_dataa="<?=$fabric_data_row['id']?>">
                                    <img src="<?=$base_url?>images/Upload/kandora/<?=$fabric_data_row['image']?>" style="background:<?=(!empty($_SESSION['data_array']['Fabrics_type']))?'blue':''?>" class="w-100 clickable-div" data-value="<?=$fabric_data_row['title']?>" data-key='Fabrics_type' alt="" >
                                    <div style="d-none" id="fabrics_category"><?=$fabric_type_row2['title']?></div>
                                    <b><?=$fabric_data_row['title']?></b>
                                    <span><?=$currencySymbol?> <?=floatval($fabric_data_row['price']) * floatval($currency['conversion'])?></span>
                                    <p><?=$fabric_data_row['mrf_number']?></p>
                                </a> 
                            <?php } ?>
                        </div>
                    </div>
            <?php
                }
            }
            ?>

</div>

<div class="ck-padding" id="tarboosh">
                    <h2 class="text-center">My Measurements</h2>
                    
                    <div class="cloth-s" id="measurements">
                        <div class="row justify-content-center">
                            <div class="col-lg-12 text-center">
                                <ul class="nav nav-pills mb-3 justify-content-center" id="pills-tab" role="tablist">
                                    <li class="nav-item" role="presentation">
                                        <button class="nav-link active" id="pills-home-tab" data-bs-toggle="pill" data-bs-target="#pills-home" type="button" role="tab" aria-controls="pills-home" aria-selected="true">Request a tailor's visit</button>
                                    </li>
                                    <li class="nav-item" role="presentation">
                                        <button class="nav-link pills-profile-tab" id="pills-profile-tab" data-bs-toggle="pill" data-bs-target="#pills-profile" type="button" role="tab" aria-controls="pills-profile" aria-selected="false">Enter measurements myself</button>
                                    </li>
                                </ul>
                            </div>
                            <hr>
                            <div class="col-lg-12">
                                <div class="tab-content" id="pills-tabContent">
                                    <div class="tab-pane fade show active" id="pills-home" role="tabpanel" aria-labelledby="pills-home-tab">
                                        <div class="formFeilds contact-form form-vertical mt-2 mt-md-0">
                                            <h1 class=" text-capitalize mb-4">Request a tailor's visit </h1>
                                            <form action="" name="contactus" method="post" id="contact-form" class="contact-form">
                                                <div class="row">
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                            <input type="text" class="form-control" placeholder="Full Name " name="user_name" required/>
                                                             <input type="hidden" class="form-control" placeholder="Request a tailer visit" value="Request a tailer Vishite" name="visit_type"  />
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                        <input class="form-control" name="vishit_payment" min="<?=floatval(200) * floatval($currency['conversion'])?>" type="number" placeholder="Minimum payment for the visit <?=$currencySymbol?> <?=floatval(200) * floatval($currency['conversion'])?> ." required/>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                            <input class="form-control" name="email" type="email" placeholder="Email id" required/>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                            <input type="number" class="form-control" placeholder="Phone Name" name="phone" required/>
                                                        </div>
                                                    </div>

<div class="col-lg-4">
                                                        <div class="form-group">
                                                            <select name="country" class="form-control" id="country_id" required>
                                                                <option value="0" disabled selected>Select Country</option>
                                                                <?php
                                                                    $country_sql=mysqli_query($conn,"SELECT * FROM country_tbl WHERE status=1");
                                                                    while($country_row=mysqli_fetch_assoc($country_sql)){
                                                                ?>
                                                                    <option value="<?=$country_row['id']?>"><?=$country_row['country']?></option>
                                                                <?php }?>
                                                              
                                                            </select>

</div>
                                                    </div>
                                                    <div class="col-lg-4">
                                                        <div class="form-group">
                                                            <select name="state" class="form-control" id="state_id">
                                                                <option value="0" disabled selected>Select First Country</option>
                                                                   
                                                            </select>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-4">
                                                        <div class="form-group">
                                                            <select name="city" class="form-control" id="city_id">
                                                                <option value="0" disabled selected>Select First State</option>
                                                                   
                                                            </select>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-12">
                                                        <div class="form-group">
                                                            <textarea id="ContactFormMessage" name="address" class="form-control" rows="4" placeholder="Location / Full Address"></textarea>
                                                            <span class="error_msg" id="message_error"></span>
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="row justify-content-center">
                                                    <div class="col-lg-4">
                                                        <div class="form-group mailsendbtn mb-0 w-100">
                                                            <input class="btn w-100 rounded" type="submit" name="contactus_tailor_visit" value="Send Tailor's Message" />
                                                            <div class="loading"><img class="img-fluid" src="assets/images/ajax-loader.gif" alt="loading"></div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </form>
                                            <div class="response-msg"></div>
                                        </div>
                                    </div>
                                    <div class="tab-pane fade" id="pills-profile" role="tabpanel" aria-labelledby="pills-profile-tab">
                                        <div class="formFeilds contact-form form-vertical mt-2 mt-md-0">
                                            <h1 class="text-capitalize mb-4">Enter measurements myself <img src="b1.jpg"  alt="" class="float-end w-25"></h1>
                                            <form action="" name="contactus" method="post" id="contact-form" class="contact-form">
                                                <div class="row">
                                                    <div class="col-12 col-sm-12 col-md-6 col-lg-6">
                                                        <div class="form-group">
                                                        <div class="d-flex">
                                                            <strong class="fs-5">1.</strong>&nbsp;<input type="text" class="form-control" placeholder="Neck Size" name="neck_size" />
                                                        </div>
                                                               <input type="hidden" class="form-control" name="name" value="myself measurements " />
                                                        </div>
                                                    </div>

<div class="col-12 col-sm-12 col-md-6 col-lg-6">
                                                        <div class="form-group">
                                                        <div class="d-flex">
                                                        <strong class="fs-5">2.</strong>&nbsp;<input type="text" class="form-control" name="shoulder_size" placeholder="Shoulder Size" />
                                                        </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                        <div class="d-flex">
                                                        <strong class="fs-5">3.</strong>&nbsp;<input class="form-control" type="text" name="chest_size" placeholder="Chest Size" />
                                                        </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                        <div class="d-flex">
                                                            <strong class="fs-5">4.</strong>&nbsp;<input type="text" class="form-control" placeholder="Upper Waist Size" name="upper_waist_size"/>
                                                        </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                        <div class="d-flex">
                                                            <strong class="fs-5">5.</strong>&nbsp;<input type="text" class="form-control" placeholder="Waist Size" name="waist_size"/>
                                                        </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                        <div class="d-flex">
                                                            <strong class="fs-5">6.</strong>&nbsp;<input type="text" name="sleeve_size" class="form-control" placeholder="Full Sleeve Size" />
                                                        </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                        <div class="d-flex">
                                                            <strong class="fs-5">7.</strong>&nbsp;<input type="text" name="under_arm_size" class="form-control" placeholder="Under Arm Size" />
                                                        </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                        <div class="d-flex">
                                                            <strong class="fs-5">8</strong>&nbsp;<input type="text" class="form-control" placeholder="Full Length Size" name="full_length_size" />
                                                        </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                            <select name="measurements_type" id="" class="form-control">
                                                                <option value="preferred_fitting">Preferred Fitting</option>
                                                                <option value="regular">Regular</option>
                                                                <option value="slim fit">Slim Fit</option>
                                                                <option value="loose fit">Loose Fit</option>
                                                            </select>
                                                        </div>
                                                    </div>
                                                    
                                                </div>
                                                <h1>Enter your Kandora Measurements below (in inch only) <img src="s1.jpg" alt="" class="float-end w-25"></h1>

<div class="col-12 col-sm-12 col-md-6 col-lg-6">
                                                        <div class="form-group">
                                                        <div class="d-flex">
                                                        <strong class="fs-5">2.</strong>&nbsp;<input type="text" class="form-control" name="c_shoulder_size" placeholder="Shoulder Size" />
                                                        </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                        <div class="d-flex">
                                                        <strong class="fs-5">3.</strong>&nbsp;<input class="form-control" type="text" name="c_chest_size" placeholder="Chest Size" />
                                                        </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                        <div class="d-flex">
                                                            <strong class="fs-5">4.</strong>&nbsp;<input type="text" class="form-control" placeholder="Upper Waist Size" name="c_upper_waist_size"/>
                                                        </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                        <div class="d-flex">
                                                            <strong class="fs-5">5.</strong>&nbsp;<input type="text" class="form-control" placeholder="Waist Size" name="c_waist_size"/>
                                                        </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                        <div class="d-flex">
                                                            <strong class="fs-5">6.</strong>&nbsp;<input type="text" name="c_sleeve_size" class="form-control" placeholder="Full Sleeve Size" />
                                                        </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                        <div class="d-flex">
                                                            <strong class="fs-5">7.</strong>&nbsp;<input type="text" name="c_under_arm_size" class="form-control" placeholder="Under Arm Size" />
                                                        </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                        <div class="d-flex">
                                                            <strong class="fs-5">8</strong>&nbsp;<input type="text" class="form-control" placeholder="Full Length Size" name="c_full_length_size" />
                                                        </div>
                                                        </div>
                                                    </div>
                                                    
                                                    <div class="col-lg-6">
                                                        <div class="form-group">
                                                            <select name="c_measurements_type" id="" class="form-control">
                                                                <option value="preferred_fitting">Preferred Fitting</option>
                                                                <option value="regular">Regular</option>
                                                                <option value="slim fit">Slim Fit</option>
                                                                <option value="loose fit">Loose Fit</option>
                                                            </select>
                                                        </div>
                                                    </div>
                                                    
                                                    <div class="col-lg-12">
                                                        <div class="form-group">
                                                            <textarea id="ContactFormMessage" name="c_address" class="form-control" rows="4" placeholder="Message"></textarea>
                                                            <span class="error_msg" id="message_error"></span>
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="row justify-content-center">
                                                    <div class="col-lg-4">
                                                        <div class="form-group mailsendbtn mb-0 w-100">
                                                            <input class="btn w-100 rounded" type="submit" name="contactus_measurements_myself" value="Send Message" />
                                                            <div class="loading"><img class="img-fluid" src="assets/images/ajax-loader.gif" alt="loading"></div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </form>
                                            <div class="response-msg"></div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

// Set the clicked button as active
        button.classList.add("active");

// Show the hidden content
        var content = document.getElementById("hiddenContent");
        content.style.display = "block";
    }
</script>

</div>

// Function to handle fabric selection
function toggleContent2(button) {
    const fabricDataId = button.getAttribute('data-fabric_data');
    const title = button.getAttribute('data-title');
    const price = button.getAttribute('data-price');
    const kandoraId = button.getAttribute('data-kandora');

const fabricObject = {
        id: fabricDataId,
        title: title,
        price: price,
        kandora: kandoraId
    };

// Check if the fabric is already selected
    if (selectedFabrics.some(fabric => fabric.id === fabricDataId)) {
        // Remove from selection if already selected
        selectedFabrics = selectedFabrics.filter(fabric => fabric.id !== fabricDataId);
        button.classList.remove('selected'); // Optional: Add class for selected state
    } else {
        // Add to selection
        selectedFabrics.push(fabricObject);
        button.classList.add('selected'); // Optional: Add class for selected state
    }
}

// Function to submit selected fabrics
function submitSelection() {
    if (selectedFabrics.length === 0) {
        alert("No fabrics selected!");
        return;
    }

const xhr = new XMLHttpRequest();
    xhr.open("POST", "insert_selection.php", true);
    xhr.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");

xhr.onreadystatechange = function () {
        if (xhr.readyState === 4 && xhr.status === 200) {
            alert('Selection saved: ' + xhr.responseText);
            // Optionally clear selection
            selectedFabrics = [];
            // Optionally remove selected class from buttons here
        }
    };

xhr.send("fabric_data=" + JSON.stringify(selectedFabrics));
}
</script>

function addToSession(element) {
    // Get the key and data from the button's data attributes
    const key = element.getAttribute('data-key') || element.getAttribute('data-key2');
    const data = element.getAttribute('data-value') || element.getAttribute('data-value2');

// Get the ID from the button's data-kandora attribute
    const fabricDataId = element.getAttribute('data-kandora');

// Get the content from the hidden div
    const fabricCategoryDiv = document.getElementById('fabrics_category');
    const fabricCategory = fabricCategoryDiv ? fabricCategoryDiv.innerText : ''; // Get the text content
   
    console.log('Sending data:', { key, data, fabricDataId, fabricCategory });

// Perform the AJAX request using Fetch API
    fetch('custom-kandora_session.php', {
        method: 'POST',
        headers: {
            'Content-Type': 'application/x-www-form-urlencoded'
        },
        body: 'key=' + encodeURIComponent(key) + 
              '&data=' + encodeURIComponent(data) + 
              '&fabric_category=' + encodeURIComponent(fabricCategory) + 
              '&id=' + encodeURIComponent(fabricDataId) // Include the ID in the request body
    })
    .then(response => response.json())  // Parse the JSON response
    .then(responseData => {
        if (responseData.status === 'success') {
            // Update the page with the updated session data
            console.log('Updated Session Data:', responseData.data);
            //alert('Data added to session with key: ' + key);
        } else {
            alert('Error: ' + responseData.message);
        }
    })
    .catch(error => {
        console.error('Error:', error);
        alert('An error occurred!');
    });

// Change background color of the clicked element
    changeBackgroundColor(element);
}

// Event listener for dynamically generated elements
document.addEventListener('DOMContentLoaded', () => {
    document.body.addEventListener('click', (event) => {
        // Check if the clicked element is a button with class 'clickable-div'
        if (event.target.closest('.clickable-div')) {
            event.preventDefault(); // Prevent default behavior (for anchor tags)
            addToSession(event.target.closest('.clickable-div'));
        }
    });
});
</script>

// Get the form data safely
    const formData = {};
    const fields = [
        'user_name', 'email', 'country', 'state', 'city', 'flat_no',
        'building_name', 'street', 'area', 'landmark', 'post_code',
        'address', 'phone'
    ];

fields.forEach(field => {
        const element = document.querySelector(`[name="${field}"]`);
        formData[field.replace('_id', '')] = element ? element.value || 'Not Provided' : 'Not Provided';
    });

formData.visit = 'No'; // Default value

// Set cookies with a 1-day expiration
    const maxAge = 86400; // 1 day in seconds
    for (const key in formData) {
        setCookie(key, formData[key], maxAge);
    }

// Optional: Confirm cookies are set (for debugging)
    console.log('Cookies set:', document.cookie);
});

</script>

<?php
if (isset($_POST['contactus_tailor_visit'])) {

// Sanitize and assign POST data to variables
    $name = $_POST['user_name'];
    $vishit_payment = $_POST['vishit_payment'];
    $email = $_POST['email'];
    $country = $_POST['country'];
    $state = $_POST['state'];
    $city = $_POST['city'];
    $address = $_POST['address'];
    $phone = $_POST['phone'];
    $flat_no = $_POST['flat_no'];
    $area = $_POST['area'];
    $building_name = $_POST['building_name'];
    $street = $_POST['street'];
    $landmark = $_POST['landmark'];
    $post_code = $_POST['post_code'];
    $visit = 'yes';

$user_check = mysqli_query($conn, "SELECT * FROM user_tbl WHERE email='$email' AND user_type=1");
  if(mysqli_num_rows($user_check)){
    echo'<script>alert("An account with this email address already exists. Please log in or set a new password to continue!!")</script>';

echo'<script>window.location="login.php"</script>';
          return;
   
    
  }else{

$ChkQry1=mysqli_query($conn,"SELECT * FROM `user_tbl` WHERE email='$email' AND user_type=0") or die(mysqli_error($conn));
    if(mysqli_num_rows($ChkQry1)>0){

$qq1="UPDATE `user_tbl` SET 
    `name`='$name', 
    `email`='$email',
    `phone`='$phone',
    `country`='$country',
    `state`='$state',
    `city`='$city',
    `flat_no`='$flat_no', 
    `street`='$street',
    `landmark`='$landmark', 
    `area`='$area',   
    `post_code`='$post_code',
    `tailer_visit`='$visit',
    `vishit_payment`='$vishit_payment',
    `address`='$address',
    `building_name`='$building_name',
    `user_type`='0' WHERE email='$email'";
    $Usertbl = mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM user_tbl WHERE email='$email' AND user_type=0"));
    $userId = $Usertbl['user_id'];

}else{

$qq1="INSERT `user_tbl` SET 
    `name`='$name', 
    `email`='$email',
    `phone`='$phone',
    `country`='$country',
    `state`='$state',
    `city`='$city',
    `flat_no`='$flat_no', 
    `street`='$street',
    `area`='$area',
    `landmark`='$landmark',   
    `post_code`='$post_code',
    `tailer_visit`='$visit',
    `vishit_payment`='$vishit_payment',
    `address`='$address',
    `building_name`='$building_name',
    `user_type`='0'";
        
    if (mysqli_query($conn, $qq1)) {
        $user_id = mysqli_insert_id($conn);
        $Usertbl = mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM user_tbl WHERE id='$user_id' AND user_type=0"));
        $formatted = sprintf("%04d", $Usertbl['id']);
        $userId = 'USER' . $formatted;
        mysqli_query($conn, "UPDATE `user_tbl` SET `user_id`='$userId' WHERE id='" . $Usertbl['id'] . "' AND user_type=0");
    } else {
        die("Error inserting user: " . mysqli_error($conn));
    }
    }
    // Insert into user_tbl
    // $qq1 = "INSERT INTO `user_tbl` (`name`, `email`, `phone`, `country`, `city`, `company`, `apartment`, `post_code`, `address`, `user_type`,`tailer_visit`) VALUES ('$name', '$email', '$phone', '$country', '0', '$city', '0', '0', '0', '$address', '0', '$visit')";
    
}
    // Insert into kandora_order_tbl
    $date = date('m-d-y');
    $kandora_order = "INSERT INTO `kandora_order_tbl`(`user_id`, `payment`, `payment_status`, `status`, `add_date`) 
                      VALUES ('$userId','$vishit_payment','0','0','$date')";
    if (mysqli_query($conn, $kandora_order)) {
        $orderid = mysqli_insert_id($conn);
        $Ordertbl = mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM kandora_order_tbl WHERE id='$orderid'"));
        $formatted = sprintf("%04d", $Ordertbl['id']);
        $invoice_id = 'ORD' . $formatted;
        mysqli_query($conn, "UPDATE `kandora_order_tbl` SET `order_id`='$invoice_id' WHERE id='" . $Ordertbl['id'] . "'");
    } else {
        die("Error inserting order: " . mysqli_error($conn));
    }

// Insert into custom_kandora_tbl
    $category = $fabric_type = $fabric_category = null;
    $cloth_type = $cloth_value = [];

if (isset($_SESSION['data_array']) && is_array($_SESSION['data_array'])) {
        foreach ($_SESSION['data_array'] as $item) {
            switch ($item['key']) {
                case 'category':
                    $category = mysqli_real_escape_string($conn, $item['data']);
                    break;
                case 'Fabrics':
                    $fabric_type = mysqli_real_escape_string($conn, $item['data']);
                    break;
                case 'Fabrics_type':
                    $fabric_category = mysqli_real_escape_string($conn, $item['data']);
                    break;
                default:
                    $cloth_type[] = mysqli_real_escape_string($conn, $item['key']);
                    $cloth_value[] = mysqli_real_escape_string($conn, $item['data']);
                    break;
            }
        }
    }

$qq = "INSERT INTO `custom_kandora_tbl` (`user_id`, `order_id`, `category`, `fabric`, `fabric_type`) 
            VALUES ('$userId', '$invoice_id', '$category', '$fabric_type', '$fabric_category')";

if (mysqli_query($conn, $qq)) {
        $custom_tbl_id = mysqli_insert_id($conn);
       // echo "Inserted into custom_kandora_tbl, custom_tbl_id: $custom_tbl_id<br>";
    } else {
        die("Error inserting into custom_kandora_tbl: " . mysqli_error($conn));
    }

// Insert into custom_kandora2_tbl
    foreach ($cloth_type as $index => $type) {
        $value = isset($cloth_value[$index]) ? $cloth_value[$index] : '';
        
        $qq2 = "INSERT INTO `custom_kandora2_tbl` (`user_id`, `order_id`, `custom_id`, `cloth_type`, `cloth_value`) 
                VALUES ('$userId', '$invoice_id', '$custom_tbl_id', '$type', '$value')";
        
        //echo "SQL Query for custom_kandora2_tbl: $qq2<br>";  // Debugging SQL query
        
        if (!mysqli_query($conn, $qq2)) {
            die("Error inserting into custom_kandora2_tbl: " . mysqli_error($conn));
        }
        //echo "Inserted into custom_kandora2_tbl for cloth type: $type with value: $value<br>";
    }

// Final success message
    //echo '<script>alert("Thanks For this order !!")</script>';
     echo'<script>window.location="thankyou.php"</script>';

}

if(isset($_POST['contactus_measurements_myself'])){

// Getting data from the POST request+
   $name =$_COOKIE['user_name'];
   $email = $_COOKIE['email'];
   $country = $_COOKIE['country'];
   $state = $_COOKIE['state'];
   $city = $_COOKIE['city'];
   $flat_no = $_COOKIE['flat_no'];
   $building_name = $_COOKIE['building_name'];
   $street = $_COOKIE['street'];
   $area = $_COOKIE['area'];
   $landmark = $_COOKIE['landmark'];
   $post_code = $_COOKIE['post_code'];
   $address = $_COOKIE['address'];
   $phone = $_COOKIE['phone'];
   $visit = 'No';

// print_r($_POST);
$neck_size  = $_POST['neck_size'];
$shoulder_size  = $_POST['shoulder_size'];
$chest_size  = $_POST['chest_size'];
$upper_waist_size  = $_POST['upper_waist_size'];
$waist_size  = $_POST['waist_size'];
$sleeve_size  = $_POST['sleeve_size'];
$under_arm_size  = $_POST['under_arm_size'];
$full_length_size  = $_POST['full_length_size'];
$measurements_type  = $_POST['measurements_type'];

$c_neck_size  = $_POST['c_neck_size'];
$c_shoulder_size  = $_POST['c_shoulder_size'];
$c_chest_size  = $_POST['c_chest_size'];
$c_upper_waist_size  = $_POST['c_upper_waist_size'];
$c_waist_size  = $_POST['c_waist_size'];
$c_sleeve_size  = $_POST['c_sleeve_size'];
$c_under_arm_size  = $_POST['c_under_arm_size'];
$c_full_length_size  = $_POST['c_full_length_size'];
$c_measurements_type  = $_POST['c_measurements_type'];
$c_address  = $_POST['c_address'];

echo'<script>window.location="login.php"</script>';
          return;

}else{
    $ChkQry1=mysqli_query($conn,"SELECT * FROM `user_tbl` WHERE email='$email' AND user_type=0") or die(mysqli_error($conn));
    if(mysqli_num_rows($ChkQry1)>0){

$qq1="UPDATE `user_tbl` SET 
    `name`='$name', 
    `email`='$email',
    `phone`='$phone',
    `country`='$country',
    `state`='$state',
    `city`='$city',
    `flat_no`='$flat_no', 
    `street`='$street',
    `landmark`='$landmark',   
    `post_code`='$post_code',
    `tailer_visit`='$visit',
    `area`='$area',
    `address`='$address',
    `building_name`='$building_name',
    `user_type`='0' WHERE email='$email'";
    $Usertbl = mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM user_tbl WHERE email='$email' AND user_type=0"));
    $userId = $Usertbl['user_id'];

}else{

// Insert into kandora_order_tbl
    $date = date('m-d-y');
    $kandora_order = "INSERT INTO `kandora_order_tbl`(`user_id`, `payment`, `payment_status`, `status`, `add_date`) 
                      VALUES ('$userId','0','0','0','$date')";
    if (mysqli_query($conn, $kandora_order)) {
        $orderid = mysqli_insert_id($conn);
        $Ordertbl = mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM kandora_order_tbl WHERE id='$orderid'"));
        $formatted = sprintf("%04d", $Ordertbl['id']);
        $invoice_id = 'ORD' . $formatted;
        mysqli_query($conn, "UPDATE `kandora_order_tbl` SET `order_id`='$invoice_id' WHERE id='" . $Ordertbl['id'] . "'");
    } else {
        die("Error inserting order: " . mysqli_error($conn));
    }

$user_measurements = "INSERT `user_measurements_tbl` SET 
 `user_id`='$userId',
 `order_id`='$invoice_id',
 `neck_size`='$neck_size',
 `shoulder_size`='$shoulder_size',
 `chest_size`='$chest_size',
 `upper_waist_size`='$upper_waist_size',
 `waist_size`='$waist_size',
 `sleeve_size`='$sleeve_size',
 `under_arm_size`='$under_arm_size',
 `full_length_size`='$full_length_size',
 `measurements_type`='$measurements_type',
 `c_neck_size`='$c_neck_size',
 `c_shoulder_size`='$c_shoulder_size',
 `c_chest_size`='$c_chest_size',
 `c_upper_waist_size`='$c_upper_waist_size',
 `c_waist_size`='$c_waist_size',
 `c_sleeve_size`='$c_sleeve_size',
 `c_under_arm_size`='$c_under_arm_size',
 `c_full_length_size`='$c_full_length_size',
 `c_measurements_type`='$c_measurements_type',
 `c_address`='$c_address'";

mysqli_query($conn, $user_measurements);

// Insert into custom_kandora_tbl
    $category = $fabric_type = $fabric_category = null;
    $cloth_type = $cloth_value = [];

$qq = "INSERT INTO `custom_kandora_tbl` (`user_id`, `order_id`, `category`, `fabric`, `fabric_type`) 
            VALUES ('$userId', '$invoice_id', '$category', '$fabric_type', '$fabric_category')";

//echo '<script>alert("Thanks For this order !!")</script>';
     echo'<script>window.location="thankyou.php"</script>';

}
   ?>

<?php include "include/footer.php"; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: custom-kandora1.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation