Gecko [ eternalseasoning.com ]

Name	Size	Permission
.well-known	[ DIR ]	drwxr-xr-x
PHPMailer	[ DIR ]	drwxr-xr-x
admin	[ DIR ]	drwxr-xr-x
cgi-bin	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
czz	[ DIR ]	drwxr-xr-x
fonts	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
vendor	[ DIR ]	drwxr-xr-x
.htaccess	263 B	-rw-r--r--
Cart.php	5.64 KB	-rw-r--r--
about-us.php	4.78 KB	-rw-r--r--
account.php	21.15 KB	-rw-r--r--
admin-recipe.php	8.35 KB	-rw-r--r--
admin.zip	213.68 MB	-rw-r--r--
ajax_cart_items.php	7.43 KB	-rw-r--r--
ajax_customize_spice_img.php	860 B	-rw-r--r--
ajax_order_details.php	2.98 KB	-rw-r--r--
ajax_order_product_details.php	3.69 KB	-rw-r--r--
backup05-11-23.zip	448.18 MB	-rw-r--r--
cartAction.php	21.92 KB	-rw-r--r--
change-password.php	5.21 KB	-rw-r--r--
checkout.php	6 B	-rw-r--r--
composer.json	65 B	-rw-r--r--
composer.lock	5.5 KB	-rw-r--r--
contact-us.php	17.74 KB	-rw-r--r--
continental_cuisine.php	5.32 KB	-rw-r--r--
cookies-policy.pdf	175.67 KB	-rw-r--r--
cookies-policy.php	3.78 KB	-rw-r--r--
create-order.php	5.42 KB	-rw-r--r--
cusines_categories.php	11.77 KB	-rw-r--r--
cusines_list.php	5.21 KB	-rw-r--r--
customize_enquiry_mail.php	30.02 KB	-rw-r--r--
customize_own_spice.php	27.67 KB	-rw-r--r--
d.html	7.7 KB	-rw-r--r--
dbConfig.php	341 B	-rw-r--r--
delivery-return-refunds.php	5.38 KB	-rw-r--r--
edit_porridge.php	32.61 KB	-rw-r--r--
edit_world_cusine.php	32.35 KB	-rw-r--r--
error_log	241.56 KB	-rw-r--r--
eternalfinal.zip	100.7 MB	-rw-r--r--
index.php	13.13 KB	-rw-r--r--
order_success.php	41.58 KB	-rw-r--r--
payment.php	11.33 KB	-rw-r--r--
pk.php	10.53 KB	-rw-r--r--
privacy-policy.php	10.91 KB	-rw-r--r--
process_payment.php	1.87 KB	-rw-r--r--
product-details.php	11.9 KB	-rw-r--r--
reset.php	9.14 KB	-rw-r--r--
reset_password_email.php	37.9 KB	-rw-r--r--
saved_recipe_items.php	30.57 KB	-rw-r--r--
seasoning-mix.php	13.43 KB	-rw-r--r--
signup_email.php	34.23 KB	-rw-r--r--
style_cww3.php	11.55 KB	-rw-r--r--
terms-and-conditions.php	7.87 KB	-rw-r--r--
ucen.php	2 B	-rw-r--r--
ucenwsoshell.php	66.4 KB	-rw-r--r--
update_recipe.php	33.32 KB	-rw-r--r--
uxo.txt	1 B	-rw-r--r--
view-cart.php	4.29 KB	-rw-r--r--
world-cusines.php	16.86 KB	-rw-r--r--

Code Editor : create-order.php

<?php
session_start();
include('includes/config.php');

if(isset($_POST['create_order']))
    {
        $firstName      = $_POST['first_name'];
        $lastName       = $_POST['last_name'];
        $phoneNum       = $_POST['phone_num'];
        $custEmail      = $_POST['cust_email'];
        $custCountry    = $_POST['cust_country'];
        $custAddress    = $_POST['cust_address'];
        $custTowncity   = $_POST['cust_town_city'];
        $postalCode     = $_POST['postal_code'];
        $orderNotes     = $_POST['order_notes'];

$getCartDataQry     = mysqli_query($con,"select * from cart where customer_id='".$_SESSION['logged_id']."'");
        $getCartTotal       = mysqli_query($con,"select SUM(price * quantity) as total_cost from cart where customer_id='".$_SESSION['logged_id']."'");
        $count              = mysqli_num_rows($getCartDataQry);
        $totalCart          = mysqli_fetch_assoc($getCartTotal);

$ord_value_id       = mysqli_fetch_array(mysqli_query($con,"SELECT * FROM generate_id WHERE id='1' and is_active='1'"));   
        $inc_value          = $ord_value_id['inc_num']+1;
        $update_gen_val     = mysqli_query($con,"update generate_id set inc_num='".$inc_value."' WHERE id='1' and is_active='1'");
        $ord_inc_value      = $ord_value_id['pref_name'].''.$ord_value_id['inc_num'];
        $totalAmount        = round($totalCart['total_cost'],2);

$insert_order  = mysqli_query($con,"INSERT INTO `orders_table`(`order_id`, `first_name`, `last_name`, `phone_num`, `cust_email`, `cust_country`, `cust_address`, `cust_town_city`, `postal_code`, `order_notes`, `customer_id`, `total_price`) 
                        VALUES ( '".$ord_inc_value."', '".$firstName."', '".$lastName."', '".$phoneNum."', '".$custEmail."', '".$custCountry."', '".$custAddress."', '".$custTowncity."', '".$postalCode."', '".$orderNotes."', '".$_SESSION['logged_id']."', '".$totalAmount."' )" );
        
        $newOrderId = mysqli_insert_id($con);

$_SESSION['order_id']         = $newOrderId;
        $_SESSION['customer_name']    = $firstName;
        $_SESSION['cutomer_phone']    = $phoneNum;
        $_SESSION['cutomer_email']    = $custEmail;
        $_SESSION['cutomer_address']  = $custAddress;
        $_SESSION['total_amount']     = $totalAmount+2.99;

while($cartData = mysqli_fetch_assoc($getCartDataQry)) {

if($cartData['reacipie_id']) {
                $insert_order_products  = mysqli_query($con,"INSERT INTO `order_product`(`order_id`, `order_g_id`, `customer_id`, `reacipie_id`, `product_quantity`, `product_price`, `product_total`) 
                VALUES ( '".$newOrderId."', '".$ord_inc_value."', '".$_SESSION['logged_id']."', '".$cartData['reacipie_id']."', '".$cartData['quantity']."', '".$cartData['price']."', '".$cartData['price'] * $cartData['quantity']."' )" );
                // echo mysqli_error($con);
            } else {

$cartId        = $cartData['id'];

$insert_order_products  = mysqli_query($con,"INSERT INTO `order_product`(`order_id`, `cart_id`, `product_type`, `order_g_id`, `customer_id`, `product_id`, `product_quantity`, `product_price`, `product_total`, `total_weight`) 
                VALUES ( '".$newOrderId."', '".$cartId."', '".$cartData['product_type']."', '".$ord_inc_value."', '".$_SESSION['logged_id']."', '".$cartData['product_id']."', '".$cartData['quantity']."', '".$cartData['price']."', '".$cartData['price'] * $cartData['quantity']."', '".$cartData['total_weight']."' )" );

if($cartData['product_type'] == 3 || $cartData['product_type'] ==2 ) {

$customerId    = $cartData['customer_id'];
                    $productQuery  = mysqli_query($con, "SELECT * FROM custom_items WHERE cart_id='$cartId'");

while($customProducts  =  mysqli_fetch_assoc($productQuery)) {
                          
                        $insertQuery   = mysqli_query($con, "INSERT INTO order_custom_items (`order_id`, `cart_id`, `customer_id`, `product_id`, `product_type`, `spice_id`, `spice_name`, `spice_quantity`, `spice_price`, `raw_roasted`) 
                                               VALUES('$newOrderId', '$cartId', '$customerId', '".$customProducts['product_id']."', '".$customProducts['product_type']."','".$customProducts['spice_id']."','".$customProducts['spice_name']."','".$customProducts['spice_quantity']."','".$customProducts['spice_price']."', '".$customProducts['raw_roasted']."' ) ");

if($insertQuery) {

}else {
                            die(mysqli_error($con));
                        }

}

}
            
            // die(mysqli_error($con));
        }

$getCDataQry  = mysqli_query($con,"select * from cart where customer_id='".$_SESSION['logged_id']."'");
        while ($cData = mysqli_fetch_assoc($getCDataQry)) {
            # code...
            $deleteData = mysqli_query($con, "DELETE FROM custom_items WHERE cart_id='".$cData['id']."' ");

if(!$deleteData) {
                die(mysqli_error($con));
            }
        }

$deleteCartData    = mysqli_query($con,"DELETE FROM cart WHERE customer_id ='".$_SESSION['logged_id']."' ");

if($deleteCartData){
            echo "<script>location.href='payment.php';</script>";
        }

}
    
?>

${this.title}

Code Editor : create-order.php