$data=$this->request->get('text');
$pageParam=['query' =>$this->request->get()];
$limit=1;
$news_list=model('app\admin\model\Event')->where(array('category_id'=>22,'status'=>array('neq','hidden'),'title'=>array('like','%'.$data.'%')))->order('createtime','desc')->paginate($limit, false, $pageParam);
$this->assign('news_list',$news_list); //get带参搜索分页
$wherein = (array)$this->request->request("wherein/a");
if ($wherein && is_array($wherein))
{
foreach ($wherein as $k => $v)
{
$query->where($k, 'in', $v);
}
}
//后端基类 新增修改自定义下拉分类列表
$list = addtion($list, 'category_ids');
表格显示多分类
//验证规则
use think\Validate;
if($this->request->isPost()){
$data=input('post.');
$name=trim($data['name']);
$password=trim($data['password']);
$email=trim($data['email']);
$cpwd=trim($data['cpwd']);
$add=trim($data['add']);
$company=trim($data['company']);
$rule = [
'email' => 'require|email',
'name' => 'require',
'password' => 'require|length:6,10',
'cpwd' => 'require|length:6,10',
'add' => 'require',
'company' => 'require',
];
$msg = [
'name.require' => 'Name can not be empty',
'password.require' => 'Password can not be empty',
'password.length' => 'Password must be 6 to 10 characters',
'cpwd.require' => 'Confirm Password can not be empty',
'cpwd.length' => 'Confirm Password must be 6 to 10 characters',
'add.require' => 'Address can not be empty',
'company.require' => 'Company can not be empty',
'email.require' => 'Email can not be empty',
'email.email' => 'Email is incorrect',
];
$validate = new Validate($rule, $msg);
$result = $validate->check($data);
if(!$result){
return json(array('msg'=>$validate->getError()));
}else{
$password=md5($password);
$cpwd=md5($cpwd);
if($password!=$cpwd){
return json(array('msg'=>'The Confirm Password entered do not match'));
}else{
$dd=model('app\admin\model\Userlist')->where('mail',$email)->select();
if(count($dd)>0){
return json(array('msg'=>'The Email had been registered'));
}else{
model('app\admin\model\Userlist')->insert(array('mail'=>$email,'name'=>$name,'password'=>$password,'address'=>$add,'company'=>$company,'companytype'=>$data['companytype'],
'country'=>$data['country'],'region'=>$data['region'],'jobs'=>$data['jobs'],'createtime'=>time(),'updatetime'=>time()));
return json(array('code'=>0,'u'=>'/index/user/login','msg'=>'Sign up successful'));
}
}
}
}
//邮箱
use app\common\library\Email;
public function email(){
$name=$this->request('post.name');
//print_r($name);
$receiver = '';
$email = new Email;
$result = $email
->to($receiver)
->subject("")
->message('.$title.'<br/>'.$tel)
->send();
}
data-params='{"custom[type]":["in","znews,zstory"]}' //下拉栏Selectpage多个类别展示
其次快速搜索默认只会搜索主键id这个字段,如果你需要搜索其它字段,则需要在服务端你的控制器中定义$searchFields这个值,如下
protected $searchFields = 'id,name,title';