function getOne(){
$conn = connect();
//Получаю order_id отвечающий условию
$result = mysqli_query($conn,"SELECT * FROM `stat` WHERE `delivery`='Почта' AND `cost`='0' ORDER BY order_id LIMIT 1");
if (mysqli_num_rows($result)>0){
$row = mysqli_fetch_row($result);
$id = $row[0];
}
// Получаю данные из таблиц
$result = mysqli_query($conn,"SELECT * FROM `stat` WHERE `order_id`='$id'");
$result2 = mysqli_query($conn,"SELECT * FROM `orders` WHERE `id`='$id'");
$row = mysqli_fetch_assoc($result) + mysqli_fetch_assoc($result2);
echo json_encode($row);
// Отправка письма
function sendMail($options) {
$headers = "Content-type: text/html; charset=utf-8 \r\n";
$headers .= 'From: =?utf-8?B?' . base64_encode($options['fromName']) . '?=<' . $options['fromEmail'] . '>';
return mail($options['toEmail'], $options['subject'], $options['body'], $headers);
}
function addOrderList($data,$conn) {
$cart = json_decode($data['cart'], true);
foreach($cart as $id =>$value ) {
$result = mysqli_query($conn,"SELECT `count` FROM `list` WHERE `id`='$id'") or die (mysqli_error());
$row=mysqli_fetch_row($result);
$row=(int)$row[0];
$result=$row-$cart[$id]['count'];
if ($result<0){$result=0;};
mysqli_query($conn,"UPDATE `list` SET `count`='{$result}' WHERE `id`='$id'") or die (mysqli_error());
var_dump($result);
}
}
CLIENT -> SERVER: EHLO pito