?? ???

?? ??

Db::query('select * from think_user where id=?',[8]);

?? ??

Db::execute('insert into think_user (id, name) values (?, ?)',[8,'thinkphp']);

?? ???

Query data

find? ???? ???? ??? ??? 1?? ??? ?? ???? ?? ?? return NULL

Db::table('think_user')->where('id',1)->find();

select? ?? ???? ???? ??? ??? 2?? ?????. ??? ???? ??? ? ??? ?????.

Db::table('think_user')->where('status',1)->select();

Assistant ??

??? ? ???? ??? ? ?? db ?? ??? ?????. ??:

db('user')->where('id',1)->find();
db('user')->where('status',1)->select();

??: db ?? ??? ???? ????? ?? ??????? ?? ????? Db::name ?? Db::table ???? ???? ?? ??????. . db ??? ??? ??? ???? ?? ??

db('user',[],false)->where('id',1)->find();
db('user',[],false)->where('status',1)->select();

Add data

? ?? ? ?? ????? ??? ? ????. Db ???? ?? ???? ???? ??????? ???? ?????.

$data = ['foo' => 'bar', 'bar' => 'foo'];
Db::table('think_user')->insert($data);

Add ?? ?? ???

Add ?? ?? ???? Db ???? insertAll ???? ?? ???? ???? ??? ? ????.

$data = [    ['foo' => 'bar', 'bar' => 'foo'],
    ['foo' => 'bar1', 'bar' => 'foo1'],
    ['foo' => 'bar2', 'bar' => 'foo2']
];
Db::name('user')->insertAll($data);

insertAll ???? ????? ??? ???? ??? ?????. ??? ???? ??? 0

// 添加單條數(shù)據(jù)
db('user')->insert($data);

// 添加多條數(shù)據(jù)
db('user')->insertAll($list);

? ?????. ?? ??? ? ????: setField ???? ??? ?? ???? ?? ????, ??? ??? ???? ??? 0

Db::table('think_user')->where('id', 1)->update(['name' => 'thinkphp']);

Db::table('think_user')->where('id',1)->setField('name', 'thinkphp');

自增或自減一個字段的值
// score 字段加 1
Db::table('think_user')->where('id', 1)->setInc('score');
// score 字段加 5
Db::table('think_user')->where('id', 1)->setInc('score', 5);
// score 字段減 1
Db::table('think_user')->where('id', 1)->setDec('score');
// score 字段減 5
Db::table('think_user')->where('id', 1)->setDec('score', 5);

??? ??? ?????.

Db::table('think_user')->where('id', 1)->setInc('score', 1, 10);

where ???? ???? ??? ??? ??? ? ????:

// 根據(jù)主鍵刪除
Db::table('think_user')->delete(1);
Db::table('think_user')->delete([1,2,3]);

// 條件刪除    
Db::table('think_user')->where('id',1)->delete();
Db::table(&#39;think_user&#39;)->where(&#39;id&#39;,&#39;<&#39;,10)->delete();

whereOr ???

Db::table('think_user')
    ->where('name','like','%thinkphp')
    ->where('status',1)
    ->find();

?? ??

where ??? ? whereOr ??? ??? ?? ??? ?? ?? ????? ???. ?? ??? ????:

Db::table('think_user')
    ->where('name','like','%thinkphp')
    ->whereOr('title','like','%thinkphp')
    ->find();

?? ???

?? ???? ???? SQL ?? ??? ???? ThinkPHP ?? ??? ????? ???:

$result = Db::table('think_user')->where(function ($query) {
    $query->where('id', 1)->whereor('id', 2);
})->whereOr(function ($query) {
    $query->where('name', 'like', 'think')->whereOr('name', 'like', 'thinkphp');
})->select();

where('字段名','表達式','查詢條件');
whereOr('字段名','表達式','查詢條件');