Shulou(Shulou.com)06/03 Report--

This article mainly introduces "using php+mysql to query the data instances of that day, this week and this month". In the daily operation, I believe many people have doubts about using php+mysql to query the data examples of that day, this week and this month. I have consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "using php+mysql to query data instances of that day, this week and this month." Next, please follow the editor to study!

/ / where video is the table name; / / createtime is the field; / the database time field is a timestamp / on the day of the query: $start = date ('Y-m-d 00lv 00lv 00'); $end = date (' Y-m-d Hlav table_ s'); SELECT * FROM `table_ name` WHERE `time` > = unix_timestamp ('$start') AND `time` = unix_timestamp ('. $start.') AND `time` = unix_timestamp ('$start') AND `time`

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.