PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE `history`( `time` datetime, `Profit` int, `type` int ); INSERT INTO `history` VALUES ('2021-11-29 10:10:10', 5, 1), ('2021-11-30 10:10:10', 5, 1), ('2021-11-30 10:10:12', 5, 1); -- [{"time":"30.11.2021","Profit":10},{"time":"29.11.2021","Profit":26},{"time":"28.11.2021","Profit":12},{"time":"27.11.2021","Profit":10},{"time":"26.11.2021","Profit":13},{"time":"25.11.2021","Profit":13},{"time":"24.11.2021","Profit":13}] SELECT DATE(`time`) `Day`, SUM(`Profit`) `DaylyProfit` FROM `history` WHERE `time` > DATE_SUB(CURRENT_DATE, INTERVAL 6 DAY) GROUP BY `Day`;
Copy Clear
Copy Format Clear
<?php $query = "SELECT DATE(`time`) `Day`, SUM(`Profit`) `DaylyProfit` FROM `history` WHERE `type` = 1 AND `time` > DATE_SUB(CURRENT_DATE, INTERVAL 6 DAY) GROUP BY `Day` ORDER BY `Day` DESC;"; $result = $mysqli->query($query); $all = $result -> fetch_all(MYSQLI_ASSOC); echo json_encode($all);
Show:  
Copy Clear