Query Language in ThinkPHP: common query 1) string format $ list $ user-& gt; where (& amp; #39; usernamebbbb & amp; #39;)-& gt; select (); 2) array form $ data [& amp; #39; username & amp; #39;]...
Query Language in ThinkPHP:
Universal query
1) string format
$ List = $ user-> where ('username = bbbbbb')-> select ();
2) array form
- $ Data ['username'] = 'bbbbbb ';
- $ List = $ user-> where ($ data)-> select ();
3) object form
- $ User = M ('user ');
- $ A = new stdClass ();
- $ A-> username = 'bbbbbb ';
- $ List = $ user-> where ($ a)-> select ();
Query expression
EQ (=)
NEQ (! =)
GT (>) LT (<) [NOT] BETWEEN (corresponding to between IN SQL) IN
EGT (> =) ELT (<=) LIKE (corresponding to like in SQL)
EXP (complicated to use standard SQL statements)
Interval query
- $ Map ['id'] = array ('GT ', 3), array ('Lt', 10), 'OR ');
- $ Map ['name'] = array ('like', '% a %'), array ('like', '% B % '), array ('like', '% c %'), 'thinkphp', 'or ');
The corresponding query conditions are: ('name' LIKE '% a %') OR ('name' LIKE '% B %') OR ('name' LIKE '% c % ') OR ('name' = 'thinkphp ');
Combined query:
1) string mode query (_ string)
- $ User = M ('user ');
- $ Data [id] = array ('neq', 1 );
- $ Data ['username'] = 'aaaaa ';
- $ Data ['_ string'] = 'userpass = 123 and createtime = 100 ';
- $ List = $ user-> where ($ data)-> select ();
2) request string query method
- $ Data ['id'] = array ('GT ', 100 );
- $ Data ['_ query'] = 'userpass = 1 & username = aa & _ logic = or ';
- $ List = $ user-> where ($ data)-> select ();
3) composite query
- $ Wh ['username'] = array ('like', '% thinkphp % ');
- $ Wh ['userpass'] = array ('like', '3% ');
- $ Wh ['_ logic'] = 'or ';
- $ Data ['_ complex'] = $ wh;
- $ Data ['id'] = array ('GT ', 100 );
- $ List = $ user-> where ($ data)-> select ();
Corresponds to: (id> 100) AND (namelike '% thinkphp %') OR (titlelike '% thinkphp % '))
Statistics Query
- Count (): $ num = $ user-> count (); $ num = $ user-> count ('id ');
- Max ():
- Min ():
- Avg ():
- Sum ():
Locate query
The current model must inherit the advanced model class before it can be used.
- $ User-> where ('score> 0')-> order ('score desc')-> getN (2 );
- $ User-> where ('score> 80')-> order ('score desc')-> getN (-2 );
- $ User-> where ('score> 80')-> order ('score desc')-> first ();
- $ User-> where ('score> 80')-> order ('score desc')-> last ();
SQL query
- $ Model = new Model ();
- $ List = $ model-> query ("select * from think_user where id> 1 and id <10 ");
- $ Model = new Model ();
- $ Model-> execute ("update think_user set name = 'thinkphp' where status = 1 ");
Dynamic query
- $ User = $ User-> getByName ('liu21st ');
- $ User = $ User-> getFieldByName ('liu21st', 'id ');
- $ User-> where ('score> 80')-> order ('score desc')-> top5 ();