PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table oam ( nas int, Mor int, Cas int, Tat int, Data date ); insert into oam values (8, 9, 0, 1, '2021-05-26'), (7, 8, 9, 0, '2021-05-27'), (6, 7, 8, 9, '2021-05-28'), (5, 6, 7, 8, '2021-05-29'), (4, 5, 6, 7, '2021-05-30'), (3, 4, 5, 6, '2021-05-31'), (2, 3, 4, 5, '2021-06-01'), (1, 2, 3, 4, '2021-06-02'); SELECT SUM(nas) AS value_sum FROM oam WHERE DATE(data) = DATE_SUB(DATE(NOW()), INTERVAL 7 DAY) GROUP BY DATE(data) ;
Copy Clear
Copy Format Clear
<?php $result = mysqli_query($mysqli, ' SELECT SUM(nas) AS value_sum FROM oam WHERE DATE(data) = DATE_SUB(DATE(NOW()), INTERVAL 7 DAY) GROUP BY DATE(data)'); $row = mysqli_fetch_assoc($result); $sum = array_sum(range(2,$row['value_sum'])); echo $sum;
Show:  
Copy Clear