function get_sum1()
{
if (isset($_POST['delivery_date'])) {
global $link;
$delivery_date = $_POST['delivery_date'];
$sql = "SELECT SUM ('manager_comment') FROM Users WHERE courier=1 AND delivery_date='$delivery_date'" AND delivery_status=1";
$result = mysqli_query($link, $sql);
return $result;
}
}
Пробовал такой запрос, но это не совсем то, что нужно.
Но что-то не совсем то.
$sql = "SELECT SUM(manager_comment) as summa FROM Users WHERE courier=1 AND delivery_date='$delivery_date' AND delivery_status=1";
as summaв вашем коде.
function get_sum_1()
{
global $link;
if (isset($_POST['delivery_date'])) {
$delivery_date = $_POST['delivery_date'];
$sql = "SELECT SUM(sum) as summa FROM Users WHERE courier=1 AND delivery_date='$delivery_date' AND delivery_status=1";
$result = mysqli_query($link, $sql);
$users = mysqli_fetch_all($result, MYSQLI_ASSOC);
return $users;
}
}
function get_sum1()
{
if (isset($_POST['delivery_date'])) {
global $link;
$delivery_date = $_POST['delivery_date'];
$sql = "SELECT SUM(manager_comment) as summa FROM users WHERE courier=1 AND delivery_date='$delivery_date' AND delivery_status=1";
$result = mysqli_query($link, $sql);
$users = mysqli_fetch_all($result, MYSQLI_ASSOC);
return $users[0]['summa'];
}
else
{
return false;
}
}
print get_sum1();
<?php
$post = get_cargo_users1();
?>
<?php foreach ($post as $users): ?>
<form method="post" action="dost.php">
<tbody>
<tr>
<td><?=$users['id']?></td>
<td><?=htmlspecialchars($users['delivery_adress'], ENT_QUOTES)?></td>
<td><?=htmlspecialchars($users['delivery_time'], ENT_QUOTES)?></td>
<td><?=htmlspecialchars($users['surname'], ENT_QUOTES)?> <?=htmlspecialchars($users['name'], ENT_QUOTES)?> <?=htmlspecialchars($users['second_name'], ENT_QUOTES)?></td>
<td><?=htmlspecialchars($users['sum'], ENT_QUOTES)?></td>
<td><button type="submit" formmethod="post" name="delivered" class="btn btn-xs btn-success mb-3" id="delivered">Отдал</button></td>
<td><button type="submit" formmethod="post" name="undelivered" class="btn btn-xs btn-danger mb-3">Отказ</button></td>
<td><button type="button" formmethod="post" name="delivery" class="btn btn-xs btn-warning mb-3" data-toggle="modal" data-target="#exampleModalLong">Перенос</button></td>
</tr>
</tbody>
</form>
<?php endforeach ?>
<?php
$link=mysqli_connect("localhost","root","","test");
global $link;
function get_sum1()
{
global $link;
$sql = "SELECT *,SUM(sum) as summa FROM users WHERE courier=1";
$result = mysqli_query($link, $sql);
$users = mysqli_fetch_all($result, MYSQLI_ASSOC);
return $users[0];
}
$users=get_sum1();
?>
<form method="post" action="dost.php">
<tbody>
<tr>
<td><?=$users['id']?></td>
<td><?=htmlspecialchars($users['delivery_adress'], ENT_QUOTES)?></td>
<td><?=htmlspecialchars($users['delivery_time'], ENT_QUOTES)?></td>
<td><?=htmlspecialchars($users['surname'], ENT_QUOTES)?> <?=htmlspecialchars($users['name'], ENT_QUOTES)?> <?=htmlspecialchars($users['second_name'], ENT_QUOTES)?></td>
<td><?=htmlspecialchars($users['summa'], ENT_QUOTES)?></td>
<td><button type="submit" formmethod="post" name="delivered" class="btn btn-xs btn-success mb-3" id="delivered">Отдал</button></td>
<td><button type="submit" formmethod="post" name="undelivered" class="btn btn-xs btn-danger mb-3">Отказ</button></td>
<td><button type="button" formmethod="post" name="delivery" class="btn btn-xs btn-warning mb-3" data-toggle="modal" data-target="#exampleModalLong">Перенос</button></td>
</tr>
</tbody>
</form>
<td><?php
$post = get_sum1();
foreach ($post as $users): ?><?=htmlspecialchars($users['summa'], ENT_QUOTES)?><?php endforeach ?></td>
function get_sum1()
{
global $link;
$sql = "SELECT *,SUM(manager_comment) as summa FROM users WHERE courier=1";
$result = mysqli_query($link, $sql);
$users = mysqli_fetch_all($result, MYSQLI_ASSOC);
return $users;
}
$post=get_sum1();
foreach ($post as $users): ?><?=htmlspecialchars($users['summa'], ENT_QUOTES)?><?php endforeach ?></td>