1. general queries include the where condition in queries. there are at least three forms of EQNEQ! GT & gt; EGT & gt; LT & lt;/div & gt; ELT & lt; LIKElike [NOT] BETWEEN [not] between [not] in is recommended to use arrays...
1. common query
There are at least three forms of where conditions for a query.
- EQ =
- NEQ! =
- GT>
- EGT> =
- LT <
- ELT <=
- LIKE like
- [NOT] BETWEEN [not]
- [Not] in
Array query is recommended.
1. string format:
'Id> 5 and id <9'
2. array form
- $ User = M ('user ');
- $ Data ['username'] = 'liwenkai ';
- $ List = $ user-> where (array ('username' => 'liwenkai')-> select ();
- $ List = $ user-> where ($ data)-> select ();
3. object form
- $ User = M ('user ');
- $ A = new stdClass ();
- $ A-> username = 'liwenkai ';
- $ List = $ user-> where ($ a)-> select ();
4. query expression
- Equal to EQ
- NEQ is not equal
- GT>
- EGT greater than or equal
- LT is less
- ELT less than or equal
- LIKE is equivalent to like in SQL
- [NOT] BETWEEN Query Interval
- [NOT] IN query set
- EXP refers to the use of standard SQL statements for more complex scenarios.
-
- $ Data ['Field name'] = array ('expression ', 'query condition ');
- $ Data ['liwenkai'] = 'liwenkai'; actually, it refers to $ data ['liwenkai'] = array ('EQ ', 'liwenkai ');
- $ Data ['username'] = array ('like', 'Peng % ');
- $ List = $ user-> where ($ data)-> select ();
II. interval query
- $ User = M ('user ');
- $ Data ['id'] = array ('GT ', 20), array ('Lt', 23), 'and ');
- $ List = $ user-> where ($ data)-> select ();
- Dump ($ list );
- $ Data ['username'] = array ('like', 'p % '), array ('like', 'H %'), 'OR ');
III. combined query
- $ User = M ('user ');
- $ Data ['username'] = 'pengyanjie ';
- $ Data ['password'] = array ('EQ ', 'pengyanjie ');
- $ Data ['id'] = array ('Lt ', 30 );
- $ Data ['_ logic'] = 'or ';
- $ List = $ user-> where ($ data)-> select ();
- Dump ($ list );
IV. Composite query
- $ User = M ('user ');
- $ Data ['username'] = array ('EQ ', 'pengyanjie ');
- $ Data ['password'] = array ('like', 'p % ');
- $ Data ['_ logic'] = 'or ';
- $ Where ['_ complex'] = $ where;
- $ Where ['id'] = array ('Lt ', 30 );
- $ List = $ user-> where ($ data)-> select ();
- Dump ($ list );
- // Equivalent to (id <30) and (username = pengyanjie) or (password like p % ))
5. statistical query
- Echo $ user-> count ();
- Echo'
';
- Echo $ user-> max ('id ');
- Echo'
';
- Echo $ user-> where ('Id <30')-> min ('id ');
- Echo'
';
- Echo $ user-> avg ('id ');
- Echo'
';
- Echo $ user-> sum ('id ');
6. locate and query
- $ User = new AdvModel ('user'); // instantiate the advanced model AdvModel
- // $ User = M ('user', 'commonmodel'); // you can use the CommonModel to inherit the AdvModel.
- $ List = $ user-> order ('Id desc')-> getN (2); // The third entry in the returned result
- Dump ($ list );
-
- $ List = $ user-> order ('Id desc')-> last (); // return the last entry
- $ List = $ user-> order ('Id desc')-> first (); // return the first entry
VII. SQL query
Excute () is mainly used for updating and writing data.
- $ Model = new Model () // instantiate a model object without any data tables
- $ Model-> execute ("update think_user set name = 'thinkphp' where status = 1 ");
Query () is mainly used for query
- $ User = M ();
- $ List = $ user-> query ('select * from aoli_user order by id desc ');
- Dump ($ list );
8. dynamic query
- $ User = M ('user ');
- $ List = $ user-> getByusername ('pengyanjie ');
- $ List = $ user-> getByusername ('pengyanjie ');
- Dump ($ list );
-
- $ User = new AdvModel ('user ');
- $ List = $ user-> top5 (); // The first five
- Dump ($ list );