搜索间隔，搜索时间跨度（c层代码）

在数据库users表中加一个字段search_time上次搜索时间（注意字段类型int）

public function actionAdmin(){
$session = Yii::$app->session;
$session->open();
$id = $session["id"];
// var_dump($id);die;
$admin = Yii::$app->db->createCommand('SELECT * FROM users where id = '.$id)->queryOne();
// $data = urlencode(base64_encode($id));
$data = $this->encrypt($id,'E',"a");
$admin["turl"] = $admin["url"]."index.php/?r=test/index&id=".$data;
$users = Yii::$app->db->createCommand('SELECT * FROM users where p_id = '.$id)->queryAll();
$cont = count($users);
if(Yii::$app->request->isPost){
$s_time = strtotime(Yii::$app->request->post("s_time"));
$e_time = strtotime(Yii::$app->request->post("e_time"));
$c = $e_time-$s_time;
$search_time = time();
if($search_time-$admin["search_time"]<10){
echo "搜索间隔必须在10秒以上";
die();
}else{
if($c-3600*24*2>0){
echo "时间跨度不能超过3天";
die();
}else{
Yii::$app->db->createCommand()->update('users', ["search_time"=>$search_time], "id =".$id)->execute();
$users = Yii::$app->db->createCommand('SELECT * FROM users where p_id = '.$id.' and r_time>"'.$s_time.'" and r_time<"'.$e_time.'"')->queryAll();
$cont = count($users);
}
}
// var_dump($users);die;
}
foreach($users as $k=>$v){
$son = Yii::$app->db->createCommand('SELECT * FROM users where p_id = '.$v['id'])->queryAll();
$s_cont = count($son);
$users[$k]['son'] = $s_cont;
}
$users = $this->arr_sort($users,'son','desc');
// var_dump($users);die;
return $this->render("admin",["admin"=>$admin,"users"=>$users,"cont"=>$cont]);
}