亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

<?php
????namespace?app\index\model;
????use?think\Model;
????class?User?extends?Model{
????????public?function?getSexAttr($val){
????????????switch($val){
????????????????case?'1':
????????????????????return?"男";
????????????????????break;
????????????????case?'2':
????????????????????return?"女";
????????????????????break;
????????????????default:
????????????????????return?"未知";
????????????????????break;
????????????}
????????}
????}

class?Index?extends?Controller{
????public?function?index(){
????????$res?=?User::count();
????????$res?=?User::where('id','>','5')->count();
????????$res?=?User::max('age');
????????$res?=?User::sum('age');
????????$res?=?User::min('age);
????????$res?=?User::avg('age');//都可以和第一個一樣帶條件查詢
????????dump($res);
????}
}

<?php
????namespace?app\index\controller;
????use?think\Controller;
????use?app\index\model\User;
????class?index?extends?Controller{
????????public?function?index(){
????????????$res?=?User::destroy(function($query){
????????????????$query->where('id','>',5);
????????????});//可以傳ID值或者閉包函數作為條件
????????????dump($res);
????????????$userModel?=?User::get(7);
????????????$userModel->delete();
????????????$res?=?User::where("1=1")
????????????????->delete();
????????????dump($res);
????????}
????}

<?php
????namespace?app\index\controller;
????use?think\Controller;
????use?app\index\model\User;
????class?Index?extends?Controller{
????????$data?=?[];
????????for($i=1;$i<21;$i++){
????????????$data[]?=?[
????????????????'username'=>'zhangsan_'.$i,
????????????????'password'=>md5('sdfa'._$i),
????????????????'age'=>$i
????????????];
????????????$userModel?=?new?User;
????????????$userModel->saveAll($data);
????????????dump($res);
????????????$res?=?User::update([
???????????????'username'=>'wangba',
???????????????'age'=>15,
???????????????'id'=>15
????????????],function($query){
????????????????$query->where('id','LT',5);
????????????});//如果第一個參數不包含條件ID，第二個參數應該設置ID值或指閉包函數為更新條件
????????????dump($res);
????????????$res?=?User::where('id','<',6)
????????????????->update([
????????????????????'username'=>'hehe'
????????????????]);
????????????$userModel?=?User::get(1);
????????????$userModel->username?=?"123";
????????????$userModel->age?=?110;
????????????$usermodel?=?new?User;
????????????$res?=?$userModel->save([
????????????????'username'=>'huhu'
????????????],function($query){
????????????????$query->where("id","<","5");
????????????});
????????????$res?=?$usermodel->saveAll([
????????????????['id'=>1,'username'=>'jingyao'],
????????????????['id'=>2,'username'=>'lihong']
????????????]);
????????}
????}

<?php
????namespace?app\index\controller;
????use?think\Controller;
????use?app\index\model\User;
????class?Index?extends?Controller{
????????public?function?index(){
????????????$user?=?User::create([
????????????????'username'=>'zhangsan',
????????????????'password'=>md5(123456),
????????????????'age'=>13
????????????],['username','age']);//第二個參數設置為true則只插入數據表中存在的字段，數組是允許插入的字段，不設置插入不存在的字段的時候會報錯
????????????dump($res->id);//返回插入的ID
????????????$userModel?=?new?User;
????????????$userModel->username?=?"lisi";
????????????$userModel->password?=?md5('sdfa');
????????????$userModel->save();
????????????dump($userModel->id);
????????????$userModel?=?new?User;
????????????$res?=?$userModel
????????????->allowField(['username'])
????????????->save([
????????????????"username"=>'wangba',
????????????????'password'=>md5('sdfs'),
????????????????'demo'=>123
????????????]);
????????????$res?=?$userModel->saveAll([
????????????????['age'=>17],
????????????????['age'=>18]
????????????]);
????????????foreach($res?as?$val){
????????????????$arr?=?$val->toArray();
????????????????dump($arr);
????????????}
????????}
????}

<?php
????namespace?app\index\controller;
????use?think\Controller;
????use?app\index\controller\User;
????class?index?extends?Controller{
????????$res?=?User::get(function($query){
????????????$query->where("username","eq","zhangsan")
??????????????????->filed("username,email");
????????});
????????$res?=?User::where("id",12)
????????????->field("id,username")
????????????find();
?????????$res?=?User::all(function($query){
?????????????$query->where("id","<","15")
???????????????????->select();
?????????});
?????????$res?=?User::where('id','>',"15")
??????????????->field("username,email")
??????????????->limit(3)
??????????????->order('id?DESC')
??????????????->select();
?????????foreach($res?as?$val){
?????????????$res->toArray();
?????????????dump($val->toArray());
?????????}
?????????$res?=?User::value('email');
?????????$res?=?User::where('id','10')->value('email');
?????????$res?=?User::column("email","username");
?????????dump($res);
????}

<?php
????namespace?app\index\controller;
????use?think\Controller;
????use?app\index\model\User;
????use?think\Loader;
????class?Index?extends?Controller{
????????public?function?index(){
????????????$res?=?User::get(2);
????????????$user?=?new?User;
????????????$res?=?$user::get(3);
????????????$user?=?Loader::model("User");
????????????$user?=?model("User");
????????????$res?=?$user::get(6);
????????????$res?=?$res->toArray();
????????????dump($res);
????????}
????}

鏈式操作方法

$sql = $db->where('id','exp','not in (1,2,3)')->bulidSql();

eq? =????neq <>????lt <????elt <=????gt >????egt >=????between? notbetween????in????not in

$sql = $db->where("id",'lt','3')->buildSql();

$sql = $db->where('id','between','3,4')->buildSql();

$sql = $db->where('id','in',[1,2,3,41])->bulidSql();//in和between第三個參數可為數組或者字符串

$db->where()->delete();

$db->delete($id);

$db->where([])->update([])返回影響的行數

$db->where([])->setField($fieldname,$fieldvalue)更改某個字段值

$db->where([])->setInc($fieldname,$num);增加，不設置第二個參數默認為一

$db->where([])->setDec($fieldname,$num);減少

$db = Db::name(tablename);

$db->insert([]);返回插入記錄行數；

$db->insertGetId([]);返回插入的自增ID；

$db->insertAll([[],[]]);返回批量插入數據成功的行數；

<?php
namespace?app\index\controller;
use?think\Controller;
use?think\Db;
class?Index?extends?Controller{??
????public?function?index(){
????????dump(Config('database'));
????????$res?=?Db::connect();
????????$res?=?Db::connect([
????????????'type'=>'mysql',
????????????'hostname'=>'127.0.0.1',
????????????'database'=>'course',
????????????'usename'=>'root',
????????????'password'=>'root_pw',
????????????'hostport'=>'3306',
????????????'charset'=>'utf8',
????????????'prefix'=>''
????????]);
????????$res=Db::connect('mysql://root:[email protected]:3306/course#utf8');
????????dump($res);
????}

}

find返回的是一維數組，DB::name('表名')，DB::table('表全名')，db()助手函數第三個參數為false防止重新實例化