/*Вывод за день*/ $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 Год*/
$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());