CURD and associated operations

1. simple query $ userM (& amp; #39; user & amp; #39;); // query a piece of information and return a one-dimensional array $ list $ user-& gt; find (); // query all information, returns the two-dimensional array select or findAll ()...

1. simple query

1. $ User = M ('user ');
2. // Query a piece of information and return a one-dimensional array
3. $ List = $ user-> find ();
4. // Query all information, returns the two-dimensional array select or findAll ()
5. $ List = $ user-> select ();

2. coherent operations in queries

(1) where method

1. $ User-> where ('status = 1')-> order ('create _ time')-> limit (10)-> select ();
2. $ User-> select (array ('order' => 'Create _ time', 'where' => 'status = 1 ', 'limit' => '10 '));
3. $ User-> where ('Id = 1')-> field ('Id, name, email ')-> find ();
4. $ User-> where ('status = 1 and id = 1')-> delete ();
5. $ List = $ user-> where ('Id> 1')-> limit ('5')-> order ('Id desc')-> field ('Id, username')-> select ();

(2) cross-table query $ user-> table ()

1. $ List = $ user-> table ('aoli _ user u, aoli_test t')-> where ('U. id = t. id')-> select ();

(3) the $ user-> data () data method can be replaced. it is mainly used for the save, add, and delete operations to save data.

1. $ Model-> data ($ data)-> add ();
2. $ Model-> data ($ data)-> where ('Id = 3')-> save ();

Parameters of the Data method support objects and arrays. If an object is an array, it is automatically converted. if the data method is not defined, you can use the create method or manually assign values to the Data object.

(4), $ user-> field ()

Specifies which fields to query. the parameter can be a string field ('user. id as uid, m. id as mid '), or an array field (array ('user. ID' => 'uid', 'M. ID' => 'mid '))

(5), $ user-> order ()

The parameter can also be a string order ('Id desc') or an array order (array ('id' => 'desc', 'Username '))

1. $ Model-> field ('Id, nickname as name')-> select ();
2. $ Model-> field (array ('id', 'nickname' => 'name')-> select ();

(6), limit ()

There are two parameters. The first parameter indicates the starting position and the second parameter specifies the number of queries.

Limit ('8'): Query 8 records starting from 1st.

Limit ('3, 8') starts from 3rd and queries 8

(7) page () query pages

(8) group ()

$ User-> group ('')-> select ()

(9) The having method is mainly used for secondary filtering.

(10) join queries. common join queries include INNER join, left join, and right join. the default value is left join.

(11) unique filtering by distinct

Select distinct id, username from ..

Filter out duplicate filtering

$ User-> distinct (true)-> select ();

(12) relation method association model

(13), lock query lock (true)

3. update data save ()

1. $ User = M ('user ');
2. $ Data ['password'] = 'aaa ';
3. $ List = $ user-> where ('Id = 1')-> save ($ data );
4. // Or
5. $ User = M ('user ');
6. $ Data ['password'] = 'aaa ';
7. $ Data ['id'] = '4 ';
8. $ List = $ user-> save ($ data );
9. // Or
10. $ User = M ('user ');
11. $ Data ['password'] = 'aaa ';
12. $ Data ['id'] = '4 ';
13. $ List = $ user-> data ($ data)-> save ();

Create to update data

Create.html:

2.  
3.  
4.  
5.  
6.  
7.  

UserAction. class. php

1. Function create (){
2. $ This-> display ();
3. }
5. Function addit (){
6. $ User = M ('user ');
7. If ($ vo = $ user-> create ()){
8. // $ User-> password = md5 ($ user-> password );
9. If ($ user-> save ()){
10. $ This-> success ('update successful ');
11. } Else {
12. $ This-> error ('update failed ');
13. }
14. }
15. }

$ Vo indicates the number of affected rows, that is, the number of rows Updated. other methods such as setInc (usually numeric fields for operations), the first write segment, and the second write condition, the third write needs to add an integer:

$ List = $ user-> setInc ('price', 'id = 1', 3); // Add 3 to the price Field

SetDec is the subtraction operation.

$ List = $ user-> setDec ('price', 'id = 1', 3); // The price field minus 3

SetField single record targeted modification

$ User-> where ('Id = 1')-> setField (array ('username', 'password'), array ('Google ', 'baidu '));

4. add () data ()

1. $ User = M ('user ');
2. $ Data ['password'] = 'aaa ';
3. $ List = $ user-> data ($ data)-> add ();

$ List is the primary key value after insertion, or you can use createg to add:

1. Function addit (){
2. $ User = M ('user ');
3. $ Vo = $ user-> create ();
4. $ User-> add ();
5. }

The value after form post is compressed to $ vo as an array by using the create method.

5. delete data ()

1. Function del (){
2. $ User = M ('user ');
3. $ List = $ user-> delete (25 );
4. Dump ($ list );
5. }
6. // Or
7. Function del (){
8. $ User = M ('user ');
9. $ List = $ user-> where ('Id> 5')-> delete ();
10. Dump ($ list );
11. }