Топ дня: 160845238

Тема закрыта by FullTwo scam

И так новая проблема , есть код и он не считает по дням

 /*Вывод за день*/

 $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 кошелек

 $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