public function actionSearch()
{
定义一个查询方法并去准备资料
$request = \Yii::$app->request;
$data = $request->post();//接收查询数据
//print_r($data);die;
$data['end_time'] = strtotime($data['end_time']);
if($data['end_time'] < $data['start_time'])
{
echo '请正确输入时间';
die();
}
自己尝试做where条件的拼接
$str = ' where 1 = 1 ';
if(!empty($data['start_time']))
{
$str .= ' and addtime > '.$data['start_time'];
{
$str.= ' and addtime < '.$data['end_time'];
}
使用框架查询
$connection = \Yii::$app->db;
$command = $connection->createCommand('SELECT * FROM user1'.$str);
$arr = $command->queryAll();
$num = count($arr);
//var_dump($num);die;
return $this->render('list',['arr'=>$arr,'num'=>$num]);
}
{
定义一个查询方法并去准备资料
$request = \Yii::$app->request;
$data = $request->post();//接收查询数据
//print_r($data);die;
unset($data['_csrf']);
时间函数格式化
$data['end_time'] = strtotime($data['end_time']);
if($data['end_time'] < $data['start_time'])
{
echo '请正确输入时间';
die();
}
自己尝试做where条件的拼接
$str = ' where 1 = 1 ';
if(!empty($data['start_time']))
{
$str .= ' and addtime > '.$data['start_time'];
}
{
$str.= ' and addtime < '.$data['end_time'];
}
使用框架查询
$connection = \Yii::$app->db;
$command = $connection->createCommand('SELECT * FROM user1'.$str);
$arr = $command->queryAll();
$num = count($arr);
//var_dump($num);die;
return $this->render('list',['arr'=>$arr,'num'=>$num]);
}