数据库 查询练习

1.数据库查询

1.1where 查询

1. 可以使用 符号 = > < <=
2. $ret = Db::table('oyk_user')->where('uid','<=',2)->select();
3. print_r($ret);

1.2 NOTLIKE 模糊查询

1. $ret = Db::table('oyk_user')->where('nickname','notlike','%编%')->select();
2. print_r($ret);

1.3 BETWEEN 查询区间

1. $ret = Db::table('oyk_user')->where('uid','between','5,10')->select();
2. print_r($ret);

1.4 <> 不等于

1. $ret = Db::table('oyk_user')->where('uid','<>',3)->select();
2. print_r($ret);

2.请求

1. print_r(Request::get());
2. print_r(Request::post());