예제 #1
0
 /**
  * blogのindexAction
  * blogのファイル一覧を取得
  */
 public function indexAction()
 {
     $db = new DataBase();
     // 日付指定
     $beginTime = $this->get('beg', '00000000');
     $endTime = $this->get('end', '30000000');
     if ('00000000' !== $beginTime or '30000000' !== $endTime) {
         $beginTime = (new \DateTime($beginTime))->format('Ymd');
         $endTime = (new \DateTime($endTime))->format('Ymd');
         var_dump($beginTime);
         var_dump($endTime);
         $db->selectQuery('tbl_blog')->where('datetime', [$beginTime, $endTime], 'BETWEEN')->orderBy('datetime');
     } else {
         $db->selectQuery('tbl_blog')->orderBy('datetime')->limit(5);
     }
     // 最近5件
     $this->set('blogList', $db->fetchAll());
 }