The example in this article describes the method of yii2 implementing search based on time. Share it with everyone for your reference, the details are as follows:
// date to search $date = DateTime::createFromFormat('m/d/Y', '10/27/2014'); $date->setTime(0,0,0); // set lowest date value $unixDateStart = $date->getTimeStamp(); // add 1 day and subtract 1 second $date->add(new DateInterval('P1D')); $date->sub(new DateInterval('PT1S')); // set highest date value $unixDateEnd = $date->getTimeStamp(); $query->andFilterWhere( ['between', 'created_at', $unixDateStart, $unixDateEnd]);
Readers who are interested in more Yii-related content can check out the special topics on this site: "Introduction to Yii Framework and Summary of Common Techniques", "Summary of Excellent PHP Development Framework", "Basic Tutorial for Getting Started with Smarty Templates", "php Date and Time" Usage Summary", "php object-oriented programming introductory tutorial", "php string (string) usage summary", "php mysql database operation introductory tutorial" and "php common database operation skills summary"
I hope this article will be helpful to everyone’s PHP program design based on the Yii framework.