第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

select colume 結(jié)果存在返回二維數(shù)組? 不存在返回空數(shù)組;

find? value 不存在返回null

截圖匯總

colume('username','email');

返回一維數(shù)組? email? 是key? ?username 為value? ;

前面的為主,? 作為value

colume('username')? 返回一個一維數(shù)組??

->value('username');

返回字符串,一條記錄,相當于tp3 的 getField();

find? 如果有結(jié)果返回 ,應該是返回一維數(shù)組的格式!

Db::execute()? 語句插入數(shù)據(jù)

$db = Db::name('user');

$sql = $db->where("id=1")

???????????????? ->whereor("username=17777") ?? ?

????????????????->where("email =19574653152@qq.com")

?????????????????????? ????????????

????????????????????-->builSql();

/*where 支持的格式 ("id=1")? ("id",1)

????????????????????????????????("id!=1")? ("id","<>",1)

???????????????????????????????? ("id","EXP","not in (1,2,3)")

*/

dump($sql);

Db:table? ?select? column? find value?

Db:query execute

數(shù)據(jù)庫表的選擇：

public function index(){

$db= DB::name('user1');

$res = $db->find(6);

dump($res);

使用User::get(function($query)){$query->where()->field()}查詢

User::where()->field()->find()查詢某一條? 返回對象

User::all(function($query){}獲取多條記錄，使用主鍵? ?返回對象

User::where()->field()->limit()->order()->select();多條查詢? ? 返回對象

User::where()->value()按字段查詢一條? ?返回的是數(shù)組

User::where()->column("email","username")以username為鍵的數(shù)組

$res = User::get(6);

$res = User::where("id",5)

->field("id,username")

->find();

$res= $res->toArray();

$res=User::all(function($query){

$query->where("id","<",6)

->field("id,password");

});

$res = User::where("id","<","6")

->field("id,username")

->limit(5)

->order("id DESC")

->select();

foreach($res as $val){

dump($val->toArray());

}

$res = User::where("id",6)->value('username');

$res = User::column("name","id");

dump($res);

}

}

public function index(){

// $res = User::get(6);

$res= $res->toArray();

dump($res);

}

$db = Db::name('user1');

#插入數(shù)據(jù)

$data=[];

for($i=1; $i<21; $i++){

$data[]=[

'username' => " use_{$i}",

'password' => md5("pwd_{$i}}"),

'email' => "em_{$i}123456@qq.com"

];

}

$res = $db->insertAll($data);

#清空數(shù)據(jù)庫

$res= $db->where('1=1')->delete();

#鏈式操作

$res = Db::table('user1')

->where("id","<","10")

->field("id,username,password")

->page(2,5)

->select();

dump($res);

}

}

$db = Db::name('user1');

#delete 數(shù)據(jù)庫刪除操作

//返回行數(shù)的影響 刪除id為1的一行

// $res = $db->where([

// ? 'id' => 1

// ])->delete();

#清空數(shù)據(jù)庫

// $res = $db->where('1=1')->delete();

dump($res);

$db = Db::name('user1');

#updata 數(shù)據(jù)更新 返回影響的行數(shù)

// 與update不同的是setField每次只能更新一個字段

$res = $db->where([

'id' => 1

])->update([

'username' => ?'xxx'

]);

#setField ?返回影響數(shù)據(jù)的行數(shù) 更新一個字段

$res = $db->where([

'id' => 2

])->setField('username','6666666');

// $db -> where([key => value, key => value, ***])->setInc('INT字段', 自增數(shù)值默認1) 返回影響行數(shù)

// $db -> where([key => value, key => value, ***])->setDec('INT字段', 自減數(shù)值默認1) 返回影響行數(shù)

dump($res);

添加數(shù)據(jù)：

insert? 返回值是影響記錄的行數(shù) 插入數(shù)

insertGetId? 返回值插入數(shù)據(jù)的自增ID

insertAll? 返回插入數(shù)據(jù)成功的行數(shù)

Db::name('不加前綴數(shù)據(jù)庫名')->insert($一維數(shù)組) 返回值是影響記錄的行數(shù)

Db::name('不加前綴數(shù)據(jù)庫名')->insertGetId($一維數(shù)組) 返回ID

Db::name('不加前綴數(shù)據(jù)庫名')->insertAll($二維數(shù)組)? 返回成功插入行數(shù)

<!-- Db::table 方法同上 -->

Db::table('據(jù)庫名')->insert($一維數(shù)組);

或者用SQL語句插入Db::execute(SQL語句)

二維數(shù)組[

? ? ? ?0 =>一維數(shù)組[key=>value]

? ? ? ? ? ? ? ]