Loading...
PHP/MySQL | SQL Запрос
И так новая проблема , есть код и он не считает по дням

php
/*Вывод за день*/
$o_day = $db->prepare('SELECT SUM(`summa`) FROM `pay` WHERE `platform` = ? AND `time` = "'.(time()-86400).'" AND `status` = ?');
$o_day -> execute([$pl['id'],$n]);

$o_day = $o_day ->fetch(PDO :: FETCH_COLUMN);
print_r($o_day);
if(!isset($o_day)) $o_day = '0.00';
/*END*/
$m_day = $db->prepare('SELECT SUM(`summa`) FROM `pay` WHERE `platform` = ? AND `time` = ? AND `status` = ?');
$m_day -> execute([$pl['id'],(time()-(86400) * 7),$n]);
$m_day = $m_day ->fetch(PDO :: FETCH_COLUMN);
if(!isset($m_day)) $m_day = '0.00';
/*END неделя*/
$m_m = $db->prepare('SELECT SUM(`summa`) FROM `pay` WHERE `platform` = ? AND `time` = ? AND `status` = ?');
$m_m -> execute([$pl['id'],time()-(86400 * 31),$n]);
$m_m = $m_m ->fetch(PDO :: FETCH_COLUMN);
if(!isset($m_m)) $m_m = '0.00';
/*END Месяц*/
$m_year = $db->prepare('SELECT SUM(`summa`) FROM `pay` WHERE `platform` = ? AND `time` = ? AND `status` = ?');
$m_year -> execute([$pl['id'],time()-(86400 * 365),$n]);
$m_year = $m_year ->fetch(PDO :: FETCH_COLUMN);
if(!isset($m_year)) $m_year = '0.00';
/*END Год*/


Кто поправить , готов накинуть ради бонуса немного монет на QIWI кошелек
php
$o_day = $db->prepare('SELECT SUM(summa) FROM `pay` WHERE `platform` = :id AND `time` >= CURDATE() AND `status` = :status');
$o_day->execute([':id' => $pl['id'], ':status' => $n]);

print_r($o_day->fetchcolumn());

________
посл. ред. 15.03.2020 в 20:44; всего 3 раз(а); by Jack Sparrow
Онлайн: 5
Время:
Gen. 0.0831
(c) Bym.Guru 2010-2025