function addOrderList($data,$conn) {
$cart = json_decode($data['cart'], true);
foreach($cart as $id =>$value ) {
$resault=mysqli_query($conn,"SELECT 'count' FROM `list` WHERE `id`='$id'") or die(mysqli_error());
$resault=$resault-$cart[$id]['count'];
echo ($resault);
}
}
function addOrder($data,$conn) {
$cart = json_decode($data['cart'], true);
$values = array();
foreach($cart as $id =>$value ) {
$value = sprintf(
"('%s','%s',%d,%d)",
$id,
mysqli_real_escape_string($conn,$cart[$id]['goodname']),
$cart[$id]['goodprice'],
$cart[$id]['count']
);
array_push($values, $value);
}
$values = implode(";", $values);
$values = mysqli_real_escape_string($conn, $values);
$query = sprintf(
"insert into orders2020 (`surname`, `name`, `fathername`, `cart`) values ('%s','%s','%s','%s')",
$data['surname'],
$data['name'],
$data['fathername'],
$values
);
$conn->query($query);
var order = (function($) {
...........
// Валидация формы
function _validate() {
var isValid=false;
var formData = ui.$orderForm.serializeArray();
console.log(formData);
var newformData = formData;
newformData.splice(5,2);
newformData.splice(9,1);
console.log(newformData);
newformData.every(function(value,index,newformData){
if (newformData[index].value !=='') {
return isValid=true;
}
else {isValid=false;}
});
console.log(isValid);
return isValid;
}
function _onSubmitForm(e) {
var isValid,
formData,
cartData,
orderData;
e.preventDefault();перезагружалась
ui.$alertValidation.addClass('hidden');
isValid = _validate();
if (!isValid) {
ui.$alertValidation.removeClass('hidden');
return false;
}
formData = ui.$orderForm.serialize();
cartData = _checkLS();
orderData = formData + '&cart=' + JSON.stringify(cartData);
console.log(orderData);
ui.$orderBtn.attr('disabled', 'disabled').text('Идет отправка заказа...');
$.ajax({
url: 'scripts/order.php',
data: orderData,
type: 'POST',
cache: false, // на всякий случай отказываемся от кэширования
dataType: 'json',
error: _orderError,
success: function(responce) {
if (responce.code === 'success') {
_orderSuccess(responce);
} else {
_orderError(responce);
}
},
complete: _orderComplete
});
}
return {
init: init,
}
})(jQuery);
jQuery(document).ready(order.init);