`field`æ¹æ³ä¸»è¦ä½ç¨æ¯æ è¯è¦è¿åæè
æä½çå段ï¼å¯ä»¥ç¨äºæ¥è¯¢ååå
¥æä½ã
## ç¨äºæ¥è¯¢
### æå®å段
å¨æ¥è¯¢æä½ä¸`field`æ¹æ³æ¯ä½¿ç¨æé¢ç¹çã
~~~
Db::table('user')->field('id,title,content')->select();
~~~
è¿é使ç¨fieldæ¹æ³æå®äºæ¥è¯¢çç»æéä¸å
å«id,title,contentä¸ä¸ªå段çå¼ãæ§è¡çSQLç¸å½äºï¼
~~~
SELECT id,title,content FROM user
~~~
å¯ä»¥ç»æ个å段设置å«åï¼ä¾å¦ï¼
~~~
Db::table('user')->field('id,nickname as name')->select();
~~~
æ§è¡çSQLè¯å¥ç¸å½äºï¼
~~~
SELECT id,nickname as name FROM user
~~~
### 使ç¨SQLå½æ°
å¯ä»¥å¨`fieldRaw`æ¹æ³ä¸ç´æ¥ä½¿ç¨å½æ°ï¼ä¾å¦ï¼
~~~
Db::table('user')->fieldRaw('id,SUM(score)')->select();
~~~
æ§è¡çSQLç¸å½äºï¼
~~~
SELECT id,SUM(score) FROM user
~~~
> é¤äº`select`æ¹æ³ä¹å¤ï¼ææçæ¥è¯¢æ¹æ³ï¼å
æ¬`find`çé½å¯ä»¥ä½¿ç¨`field`æ¹æ³ã
### 使ç¨æ°ç»åæ°
`field`æ¹æ³çåæ°å¯ä»¥æ¯ææ°ç»ï¼ä¾å¦ï¼
~~~
Db::table('user')->field(['id','title','content'])->select();
~~~
æç»æ§è¡çSQLååé¢ç¨å符串æ¹å¼æ¯çæçã
æ°ç»æ¹å¼çå®ä¹å¯ä»¥ä¸ºæäºå段å®ä¹å«åï¼ä¾å¦ï¼
~~~
Db::table('user')->field(['id','nickname'=>'name'])->select();
~~~
æ§è¡çSQLç¸å½äºï¼
~~~
SELECT id,nickname as name FROM user
~~~
### è·åææå段
å¦ææä¸ä¸ªè¡¨æé常å¤çå段ï¼éè¦è·åææçå段ï¼è¿ä¸ªä¹è®¸å¾ç®åï¼å 为ä¸è°ç¨fieldæ¹æ³æè
ç´æ¥ä½¿ç¨ç©ºçfieldæ¹æ³é½è½åå°ï¼ï¼
~~~
Db::table('user')->select();
Db::table('user')->field('*')->select();
~~~
ä¸é¢çç¨æ³æ¯çæçï¼é½ç¸å½äºæ§è¡SQLï¼
~~~
SELECT * FROM user
~~~
ä½æ¯è¿å¹¶ä¸æ¯æ说çè·åææå段ï¼èæ¯æ¾å¼çè°ç¨ææå段ï¼å¯¹äºå¯¹æ§è½è¦æ±æ¯è¾é«çç³»ç»ï¼è¿ä¸ªè¦æ±å¹¶ä¸è¿åï¼èµ·ç æ¯ä¸ä¸ªæ¯è¾å¥½çä¹ æ¯ï¼ï¼ä¸é¢çç¨æ³å¯ä»¥å®æé¢æçä½ç¨ï¼
~~~
Db::table('user')->field(true)->select();
~~~
`field(true)`çç¨æ³ä¼æ¾å¼çè·åæ°æ®è¡¨çææå段å表ï¼åªæä½ çæ°æ®è¡¨æ100个å段ã
### å段æé¤
å¦ææå¸æè·åæé¤æ°æ®è¡¨ä¸ç`content`å段ï¼ææ¬å段çå¼é常èå
åï¼ä¹å¤çææå段å¼ï¼æ们就å¯ä»¥ä½¿ç¨fieldæ¹æ³çæé¤åè½ï¼ä¾å¦ä¸é¢çæ¹å¼å°±å¯ä»¥å®ç°æ说çåè½ï¼
~~~
Db::table('user')->withoutField('content')->select();
~~~
å表示è·åé¤äºcontentä¹å¤çææå段ï¼è¦æé¤æ´å¤çå段ä¹å¯ä»¥ï¼
~~~
Db::table('user')->withoutField('user_id,content')->select();
//æè
ç¨
Db::table('user')->withoutField(['user_id','content'])->select();
~~~
>[danger] 注æçæ¯ å段æé¤åè½ä¸æ¯æ跨表åjoinæä½ã
## ç¨äºåå
¥
é¤äºæ¥è¯¢æä½ä¹å¤ï¼`field`æ¹æ³è¿æä¸ä¸ªé常éè¦çå®å
¨åè½--**å段åæ³æ§æ£æµ**ã`field`æ¹æ³ç»åæ°æ®åºçåå
¥æ¹æ³ä½¿ç¨å°±å¯ä»¥å®æ表åæ交çå段åæ³æ§æ£æµï¼å¦ææ们å¨è¡¨åæ交çå¤çæ¹æ³ä¸ä½¿ç¨äºï¼
~~~
Db::table('user')->field('title,email,content')->insert($data);
~~~
å³è¡¨ç¤ºè¡¨åä¸çåæ³å段åªæ`title`,`email`å`content`å段ï¼æ 论ç¨æ·éè¿ä»ä¹æ段æ´æ¹æè
æ·»å äºæµè§å¨çæ交å段ï¼é½ä¼ç´æ¥å±è½ãå 为ï¼å
¶ä»ææå段æ们é½ä¸å¸æç±ç¨æ·æ交æ¥å³å®ï¼ä½ å¯ä»¥éè¿èªå¨å®æåè½å®ä¹é¢å¤éè¦èªå¨åå
¥çå段ã
>[danger] å¨å¼å¯æ°æ®è¡¨åæ®µä¸¥æ ¼æ£æ¥çæ
åµä¸ï¼æ交äºéæ³å段ä¼æåºå¼å¸¸ï¼å¯ä»¥å¨æ°æ®åºè®¾ç½®æ件ä¸è®¾ç½®ï¼
> ~~~
> // å
³éä¸¥æ ¼å段æ£æ¥
> 'fields_strict' => false,
> ~~~
- åºè¨
- åºç¡
- å®è£
- å¼åè§è
- ç®å½ç»æ
- é ç½®
- æ¶æ
- 请æ±æµç¨
- æ¶ææ»è§
- å ¥å£æ件
- å¤åºç¨æ¨¡å¼
- 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
- éå½
- å©æå½æ°
- å级æ导
- æ´æ°æ¥å¿