/** * 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()); }