ThinkPHPå ç½®äºé常çµæ´»çæ¥è¯¢æ¹æ³ï¼å¯ä»¥å¿«éçè¿è¡æ°æ®æ¥è¯¢æä½ï¼æ¥è¯¢æ¡ä»¶å¯ä»¥ç¨äºCURDçä»»ä½æä½ï¼ä½ä¸ºwhereæ¹æ³çåæ°ä¼ å ¥å³å¯
1ï¼ç´æ¥ä½¿ç¨å符串ä½ä¸ºæ¥è¯¢æ¡ä»¶
$User = M("User"); // å®ä¾åUser对象æåçæçSQLè¯å¥æ¯
SELECT * FROM think_user WHERE type=1 AND status=1
2ï¼ä½¿ç¨æ°ç»ä½ä¸ºæ¥è¯¢æ¡ä»¶
$User = M("User"); // å®ä¾åUser对象æåçæçSQLè¯å¥æ¯
SELECT * FROM think_user WHERE `name`='thinkphp' AND status=1
å¦æè¿è¡å¤å段æ¥è¯¢ï¼é£ä¹å段ä¹é´çé»è®¤é»è¾å ³ç³»æ¯ é»è¾ä¸ ANDï¼ä½æ¯ç¨ä¸é¢çè§åå¯ä»¥æ´æ¹é»è®¤çé»è¾å¤æï¼éè¿ä½¿ç¨ _logic å®ä¹æ¥è¯¢é»è¾ï¼
$User = M("User"); // å®ä¾åUser对象æåçæçSQLè¯å¥æ¯
SELECT * FROM think_user WHERE `name`='thinkphp' OR `account`='thinkphp'
3ï¼ä½¿ç¨å¯¹è±¡æ¹å¼æ¥æ¥è¯¢ ï¼è¿é以stdClasså 置对象为ä¾ï¼
$User = M("User"); // å®ä¾åUser对象æåçæçSQLè¯å¥åä¸é¢ä¸æ ·
SELECT * FROM think_user WHERE `name`='thinkphp' AND status=1
使ç¨å¯¹è±¡æ¹å¼æ¥è¯¢å使ç¨æ°ç»æ¥è¯¢çæææ¯ç¸åçï¼å¹¶ä¸æ¯å¯ä»¥äºæ¢çï¼å¤§å¤æ°æ
åµä¸ï¼æ们
建议éç¨æ°ç»æ¹å¼æ´å é«æï¼å¦å¤ï¼å¦ä¹ thinkPHPéè¦å¦ä¼ä½¿ç¨tpæåã