?? ????? ?????? ??? ??? ? ??? ???. ? ????? ThinkPHP5 ??? ??? ??? ???? ??? ThinkPHP5? ???? ?????? ??? ?? ??? ??? ??????.

?? ???

?? ??

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

?? ??

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

?? ???

Query data

find? ???? ?????. ??? 1?? ?????. ??? ??? NULL? ?????.

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

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

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

Assistant ??

System ?? ??? ??? ?? 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);

?? ??? ??

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

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

insertAll ???? ???? ????? ???? ????? ??? ??? ?????. ??

?? ??

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

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

Update data

update ???? ??? ?? ???? ?? ????, ??? ???? ??? 0

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

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

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);

Delayed update

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

Delete data

//?根據(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('think_user')->where('id','<&#39;,10)->delete();

Conditional query method

where

where ???? ???? ??? ??? ? ????. AND ??? ?? ??:

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

whereOr method

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

Mixed query

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

$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();

?? ???

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

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

表達式?含義
EQ、=?等于（=）
NEQ、<>?不等于（<>）
GT、>?大于（>）
EGT、>=?大于等于（>=）
LT、< 小于（<）
ELT、<= 小于等于（<=）
LIKE 模糊查詢
[NOT] BETWEEN （不在）區(qū)間查詢
[NOT] IN （不在）IN 查詢
[NOT] NULL 查詢字段是否（不）是NULL
[NOT] EXISTS EXISTS查詢
EXP 表達式查詢，支持SQL語法
>?time?時間比較
<?time?時間比較
between?time?時間比較
notbetween?time?時間比較

[?? ???? ?? ??: thinkphp ?????]

? ??? Thinkphp 5.0? ??????(???) ??? ?? ?????????.? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!