0829数据库 查询练习

1.数据库查询

1.1where 查询

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

1.2 NOTLIKE 模糊查询

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

1.3 BETWEEN 查询区间

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

1.4 <> 不等于

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

2.请求

print_r(Request::get());
print_r(Request::post());