1#@!#!123s

: / home3 / encodto1 / salvation.incrediblebengal.com / admin /
Filename : insert_dine_cart.php
back
<?php 
include'config.php';
include'get_session_access.php';
include'function.php';
error_reporting();

$table_id = $_POST['table_id'];
$food_id = $_POST['food_id'];
$food_name = $_POST['food_name'];
$food_qty = $_POST['food_qty'];
$food_price = $_POST['food_price'];
$ip_add = getUserIp();
$order_date = getOrderDate();
$food_subtotal = $food_qty * $food_price;

$check = "SELECT * FROM table_cart WHERE food_id = '$food_id' AND table_id = $table_id";
$res = mysqli_query($conn, $check);
$data = mysqli_fetch_array($res, MYSQLI_NUM);
if($data > 1) {
    $status = '<div class="alert alert-danger" role="alert" data-auto-dismiss="3000">Item already added.</div>';
}
else{
	$sql_insert = "INSERT INTO table_cart(cart_id, table_id, food_id, food_name, food_qty, food_price, food_subtotal, order_date) 
	VALUES('', '$table_id', '$food_id', '$food_name', '$food_qty', '$food_price', '$food_subtotal', '$order_date')";
	$run_sql = mysqli_query($conn, $sql_insert)or die("Entry Failed.");
	if ($run_sql) {
		$status = '<div class="alert alert-success" role="alert" data-auto-dismiss="3000">Item added to cart.</div>';
	}
	else{
		$status = '<div class="alert alert-success" role="alert" data-auto-dismiss="3000">Item not added.</div>';
	}
}

echo $status;
?>