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
Онлайн: 6
Время:
Gen. 0.0688
(c) Bym.Guru 2010-2026