List of ThinkPHP's CURD methods and query methods

The so-called CURD. That is, the four basic operations (CURD) of database operations: C:create (create), U:update (update), R:read (read) and D:detele (delete).
In ThinkPHP, methods with these names are not necessarily used. Here are the common methods: select, find, findAll, save, create, etc.:

D reading:
select->() query data set , the same as findAll->(). For example:
$User->where('status=1′)->order('create_time')->limit(10)->select();
Note: In continuous operations, except the select method must Except for the last one, the order of calling methods for other consecutive operations is not sequential. For example, the following code is equivalent to the above:
$User->order('create_time')->where('status=1′ )->limit(10)->select();

find->() method, similar to the above two methods. The difference is that only one piece of data is returned. Can be used together with getField->() to obtain a field value of a record.

select has the same effect as findall, and returns a two-dimensional array. Such as

array(1) {

[0] => array(8)

{ ["rank_id"] => string(3) “151″

["rank_name"] => string( 7) “Test 9″

["rank_memo"] => string(3) “123″

["uid”] => string(5) “59471″

["rank_kw"] => string(6) "Important"

["rank_uptime"] => string(10) "1280202914″

["isverify"] => string(1) "0″

["ishot"] => ; string(1) “0″

}

}

find has the following effect, returning a one-dimensional array:

array(8) {

["rank_id"] => string(3) "151″

["rank_name"] => string(7) "Test 9″

["rank_memo"] => string(3) "123″

["uid"] => string( 5) “59471″

["rank_kw"] => string(6) “Important”

["rank_uptime"] => string(10) “

1280202914″ ["isverify"] => string (1) “0″

["ishot"] => string(1) “0″

}

Where method: used to query or update the definition of conditions

Table method: define the data table to be operated on Name
$Model->Table('think_user user')->where('status>1′)->select();

field method: Define the field to be queried
The parameters of the field method support strings and arrays, for example,
$Model->field('id,nickname as name')->select();
$Model->field(array('id','nickname'=>'name '))->select();
If you do not use the field method to specify a field, the default is equivalent to using field('*').

U update, C creation:

data, add, save methods: data object assignment, addition, save. For example:
$data['name'] = 'ThinkPHP';
$data['email'] = 'ThinkPHP@gmail.com';
$Model->data($data)->add(); //Newly added, equivalent to insert, written in a coherent way
$Model->add($data); //Newly added, equivalent to insert, written in a non-consecutive way
$Model->data($data)->where ('id=3′)->save(); //Modify, equivalent to update

It should be noted that in the save method, if the data has not changed, the default return operation is FALSE. But this save execution is OK, this needs attention.

create->() automatically forms data in the form of $data from the POST fields

$User=D(“User”);
$User->create(); //Data submitted through the form by default Create
$User->add(); //Add

setInc and setDec methods. For updates to statistical fields (usually numeric types):
$Model->setInc('score','id=5′,3); // The user's points are increased by 3
$Model->setInc( 'score','id=5′); // The user's points are increased by 1
$Model->setDec('score','id=5′,5); // The user's points are decreased by 5
$Model- >setDec('score','id=5′); // The user's points are reduced by 1

D Delete:

delete->() delete data
$User->where('status=0′ )->order('create_time')->limit('5′)->delete();

Other common methods of Model:

order method: result sorting For example:
order('id desc' )
The sorting method supports sorting multiple fields
order('status desc,id asc')
The parameters of the order method support strings and arrays. The usage of arrays is as follows:
order(array('status'=>' desc','id'))

limit method: Result limit
limit('1,10′)
If limit('10′) is used, it is equivalent to limit('0,10′)

page method: Query paging. The usage of the Page method is similar to the limit method. The format is:
Page(‘page[,listRows]‘)
Page represents the current number of pages, and listRows represents the number of records displayed on each page. For example, if 10 records are displayed on each page, get the data on page 2:
Page('2,10′)
listRow If you don't write it, the value of limit('length') will be read, for example, it means that every page If the page displays 25 records, get the data on page 3:
limit(25)->page(3);
If limit is not set, the default is to display 20 records per page.

Join method: Query Join support. The parameters of the Join method support strings and arrays, and the join method is the only method that can be called multiple times in a coherent operation. For example:
$Model->join(' work ON artist.id = work.artist_id')->join('card ON artist.card_id = card.id')->select();
LEFT is used by default JOIN method, if you need to use other JOIN methods, you can change it to
$Model->join('RIGHT JOIN work ON artist.id = work.artist_id')->select();

Distinct method: query Disiinct support. Perform unique filtering when querying data
$Model->Distinct(true)->select();

Relation method: related query support
$Model->Relation(true)->select();

Conditional query

$map->put('name','php'); //name='php'

('name',array('like','think')); //name like '…'

('id',array('in',array(1,2,4)));

('id',array('10′,'3′,'or')) ; //id>=10 or <=3

thinkphp multi-table query statement

1. table() function
thinkphp provides a table() function. For specific usage, please refer to the following statement:
$list=$Demo ->table('think_blog blog,think_type type')->where('blog.typeid=type.id')->field('blog.id as id,blog.title,blog.content,type. typename as type')->order('blog.id desc' )->limit(5)->select();
echo $Demo->getLastSql(); //Print the SQL statement and view it Let’s take a look

2. Join() function
Look at the code:
$Demo = M('artist');
$Demo->join('RIGHT JOIN think_work ON think_artist.id = think_work.artist_id' );
/ /You can use INNER JOIN or LEFT JOIN. Be sure to pay attention to the prefix of the table name here!
echo $Demo->getLastSql(); //Print the SQL statement and check it