æ°æ®åºæä¾çé¾å¼æä½æ¹æ³ï¼å¯ä»¥ææçæé«æ°æ®ååç代ç æ¸
æ°åº¦åå¼åæçï¼å¹¶ä¸æ¯æææçCURDæä½ï¼åçæ¥è¯¢ä¸æ¯æé¾å¼æä½ï¼ã
使ç¨ä¹æ¯è¾ç®åï¼åå¦æ们ç°å¨è¦æ¥è¯¢ä¸ä¸ªUser表ç满足ç¶æ为1çå10æ¡è®°å½ï¼å¹¶å¸ææç
§ç¨æ·çå建æ¶é´æåº ï¼ä»£ç å¦ä¸ï¼
~~~
Db::table('think_user')
->where('status',1)
->order('create_time')
->limit(10)
->select();
~~~
è¿éç`where`ã`order`å`limit`æ¹æ³å°±è¢«ç§°ä¹ä¸ºé¾å¼æä½æ¹æ³ï¼é¤äº`select`æ¹æ³å¿
é¡»æ¾å°æåä¸ä¸ªå¤ï¼å 为`select`æ¹æ³å¹¶ä¸æ¯é¾å¼æä½æ¹æ³ï¼ï¼é¾å¼æä½çæ¹æ³è°ç¨é¡ºåºæ²¡æå
åï¼ä¾å¦ï¼ä¸é¢ç代ç åä¸é¢ççæï¼
~~~
Db::table('think_user')
->order('create_time')
->limit(10)
->where('status',1)
->select();
~~~
å
¶å®ä¸ä»
ä»
æ¯æ¥è¯¢æ¹æ³å¯ä»¥ä½¿ç¨è¿è´¯æä½ï¼å
æ¬ææçCURDæ¹æ³é½å¯ä»¥ä½¿ç¨ï¼ä¾å¦ï¼
~~~
Db::table('think_user')
->where('id',1)
->field('id,name,email')
->find();
Db::table('think_user')
->where('status',1)
->where('id',1)
->delete();
~~~
æ¯æ¬¡`Db`ç±»çéææ¹æ³è°ç¨æ¯å建ä¸ä¸ªæ°çæ¥è¯¢å¯¹è±¡å®ä¾ï¼å¦æä½ éè¦å¤æ¬¡å¤ç¨ä½¿ç¨é¾å¼æä½å¼ï¼å¯ä»¥ä½¿ç¨ä¸é¢çæ¹æ³ã
~~~php
$user = Db::table('user');
$user->order('create_time')
->where('status',1)
->select();
// ä¼èªå¨å¸¦ä¸åé¢çwhereæ¡ä»¶åorderæåºçå¼
$user->where('id', '>', 0)->select();
~~~
å½åæ¥è¯¢å¯¹è±¡å¨æ¥è¯¢ä¹åä»ç¶ä¼ä¿çé¾å¼æä½çå¼ï¼é¤éä½ è°ç¨`removeOption`æ¹æ³æ¸
空é¾å¼æä½çå¼ã
~~~php
$user = Db::table('think_user');
$user->order('create_time')
->where('status',1)
->select();
// æ¸
空whereæ¥è¯¢æ¡ä»¶å¼ ä¿çå
¶å®é¾å¼æä½
$user->removeOption('where')
->where('id', '>', 0)
->select();
~~~
ç³»ç»æ¯æçé¾å¼æä½æ¹æ³å
å«ï¼
| è¿è´¯æä½ | ä½ç¨ | æ¯æçåæ°ç±»å |
| --- | --- | --- |
| where\* | ç¨äºANDæ¥è¯¢ | å符串ãæ°ç»å对象 |
| whereOr\* | ç¨äºORæ¥è¯¢ | å符串ãæ°ç»å对象 |
| whereTime\* | ç¨äºæ¶é´æ¥æçå¿«æ·æ¥è¯¢ | å符串 |
| table | ç¨äºå®ä¹è¦æä½çæ°æ®è¡¨å称 | å符串åæ°ç» |
| alias | ç¨äºç»å½åæ°æ®è¡¨å®ä¹å«å | å符串 |
| field\* | ç¨äºå®ä¹è¦æ¥è¯¢çå段ï¼æ¯æå段æé¤ï¼ | å符串åæ°ç» |
| order\* | ç¨äºå¯¹ç»ææåº | å符串åæ°ç» |
| limit | ç¨äºéå¶æ¥è¯¢ç»ææ°é | å符串åæ°å |
| page | ç¨äºæ¥è¯¢å页ï¼å
é¨ä¼è½¬æ¢ælimitï¼ | å符串åæ°å |
| group | ç¨äºå¯¹æ¥è¯¢çgroupæ¯æ | å符串 |
| having | ç¨äºå¯¹æ¥è¯¢çhavingæ¯æ | å符串 |
| join\* | ç¨äºå¯¹æ¥è¯¢çjoinæ¯æ | å符串åæ°ç» |
| union\* | ç¨äºå¯¹æ¥è¯¢çunionæ¯æ | å符串ãæ°ç»å对象 |
| view\* | ç¨äºè§å¾æ¥è¯¢ | å符串ãæ°ç» |
| distinct | ç¨äºæ¥è¯¢çdistinctæ¯æ | å¸å°å¼ |
| lock | ç¨äºæ°æ®åºçéæºå¶ | å¸å°å¼ |
| cache | ç¨äºæ¥è¯¢ç¼å | æ¯æå¤ä¸ªåæ° |
| with\* | ç¨äºå
³èé¢è½½å
¥ | å符串ãæ°ç» |
| bind\* | ç¨äºæ°æ®ç»å®æä½ | æ°ç»æå¤ä¸ªåæ° |
| comment | ç¨äºSQL注é | å符串 |
| force | ç¨äºæ°æ®éç强å¶ç´¢å¼ | å符串 |
| master | ç¨äºè®¾ç½®ä¸»æå¡å¨è¯»åæ°æ® | å¸å°å¼ |
| strict | ç¨äºè®¾ç½®æ¯å¦ä¸¥æ ¼æ£æµå段åæ¯å¦åå¨ | å¸å°å¼ |
| sequence | ç¨äºè®¾ç½®Pgsqlçèªå¢åºåå | å符串 |
| failException | ç¨äºè®¾ç½®æ²¡ææ¥è¯¢å°æ°æ®æ¯å¦æåºå¼å¸¸ | å¸å°å¼ |
| partition | ç¨äºè®¾ç½®ååºä¿¡æ¯ | æ°ç» å符串 |
| replace | ç¨äºè®¾ç½®ä½¿ç¨REPLACEæ¹å¼åå
¥ | å¸å°å¼ |
| extra | ç¨äºè®¾ç½®é¢å¤æ¥è¯¢è§å |å符串 |
| duplicate| ç¨äºè®¾ç½®DUPLCATEä¿¡æ¯ | æ°ç» å符串 |
>[danger] ææçè¿è´¯æä½é½è¿åå½åç模åå®ä¾å¯¹è±¡ï¼thisï¼ï¼å
¶ä¸å¸¦\*æ è¯ç表示æ¯æå¤æ¬¡è°ç¨ã
- åºè¨
- åºç¡
- å®è£
- å¼åè§è
- ç®å½ç»æ
- é ç½®
- æ¶æ
- 请æ±æµç¨
- æ¶ææ»è§
- å ¥å£æ件
- å¤åºç¨æ¨¡å¼
- URL访é®
- 容å¨åä¾èµæ³¨å ¥
- æå¡
- é¨é¢
- ä¸é´ä»¶
- äºä»¶
- è·¯ç±
- è·¯ç±å®ä¹
- åéè§å
- è·¯ç±å°å
- è·¯ç±åæ°
- è·¯ç±ä¸é´ä»¶
- è·¯ç±åç»
- èµæºè·¯ç±
- 注解路ç±
- è·¯ç±ç»å®
- ååè·¯ç±
- MISSè·¯ç±
- è·¨å请æ±
- URLçæ
- æ§å¶å¨
- æ§å¶å¨å®ä¹
- åºç¡æ§å¶å¨
- 空æ§å¶å¨
- èµæºæ§å¶å¨
- æ§å¶å¨ä¸é´ä»¶
- 请æ±
- 请æ±å¯¹è±¡
- 请æ±ä¿¡æ¯
- è¾å ¥åé
- 请æ±ç±»å
- HTTP头信æ¯
- 伪éæ
- åæ°ç»å®
- 请æ±ç¼å
- ååº
- ååºè¾åº
- ååºåæ°
- éå®å
- æ件ä¸è½½
- æ°æ®åº
- è¿æ¥æ°æ®åº
- åå¸å¼æ°æ®åº
- æ¥è¯¢æé å¨
- æ¥è¯¢æ°æ®
- æ·»å æ°æ®
- æ´æ°æ°æ®
- å é¤æ°æ®
- æ¥è¯¢è¡¨è¾¾å¼
- é¾å¼æä½
- where
- table
- alias
- field
- strict
- limit
- page
- order
- group
- having
- join
- union
- distinct
- lock
- cache
- comment
- fetchSql
- force
- partition
- failException
- sequence
- replace
- extra
- duplicate
- procedure
- èåæ¥è¯¢
- å页æ¥è¯¢
- æ¶é´æ¥è¯¢
- é«çº§æ¥è¯¢
- è§å¾æ¥è¯¢
- JSONå段
- åæ¥è¯¢
- åçæ¥è¯¢
- æ¥è¯¢äºä»¶
- è·åå¨
- äºå¡æä½
- åå¨è¿ç¨
- æ°æ®é
- æ°æ®åºé©±å¨
- 模å
- å®ä¹
- 模åå段
- æ°å¢
- æ´æ°
- å é¤
- æ¥è¯¢
- æ¥è¯¢èå´
- JSONå段
- è·åå¨
- ä¿®æ¹å¨
- æç´¢å¨
- æ°æ®é
- èªå¨æ¶é´æ³
- åªè¯»å段
- 软å é¤
- ç±»å转æ¢
- 模åè¾åº
- 模åäºä»¶
- 模åå ³è
- ä¸å¯¹ä¸å ³è
- ä¸å¯¹å¤å ³è
- è¿ç¨ä¸å¯¹å¤
- è¿ç¨ä¸å¯¹ä¸
- å¤å¯¹å¤å ³è
- å¤æå ³è
- å ³èé¢è½½å ¥
- å ³èç»è®¡
- å ³èè¾åº
- è§å¾
- 模æ¿åé
- è§å¾è¿æ»¤
- 模æ¿æ¸²æ
- 模æ¿å¼æ
- è§å¾é©±å¨
- é误åæ¥å¿
- å¼å¸¸å¤ç
- æ¥å¿å¤ç
- è°è¯
- è°è¯æ¨¡å¼
- Traceè°è¯
- SQLè°è¯
- åéè°è¯
- è¿ç¨è°è¯
- éªè¯
- éªè¯å¨
- éªè¯è§å
- é误信æ¯
- éªè¯åºæ¯
- è·¯ç±éªè¯
- å ç½®è§å
- 表å令ç
- 注解éªè¯
- æ项
- ç¼å
- Session
- Cookie
- å¤è¯è¨
- ä¸ä¼
- å½ä»¤è¡
- å¯å¨å ç½®æå¡å¨
- æ¥ççæ¬
- èªå¨çæåºç¨ç®å½
- å建类åºæ件
- æ¸ é¤ç¼åæ件
- çææ°æ®è¡¨å段ç¼å
- çæè·¯ç±æ å°ç¼å
- è¾åºè·¯ç±å®ä¹
- èªå®ä¹æ令
- æ©å±åº
- æ°æ®åºè¿ç§»å·¥å ·
- Workerman
- thinkå©æå·¥å ·åº
- éªè¯ç
- Swoole
- éå½
- å©æå½æ°
- å级æ导
- æ´æ°æ¥å¿