How to find result older than a week in php

We can fetch the data older than a week in php. We use ‘Interval 7 Day’ to find the mysql result. Subtract the 7 days from current date.

PHP

$rs=mysqli_query($db,"SELECT * FROM `video` where date >= CURDATE() - INTERVAL 7 DAY");