The most comprehensive experience and techniques in using THinkPHP in history, easier to use than the manual

The most comprehensive experience and tips on using THinkPHP in history, it is easier to use than the manual. Don’t miss it if you pass by.
Summary of experience and skills in using THinkPHP (1) http://www.jb100.net/html/content-28-475-1.html
Summary of experience and skills in using THinkPHP (2) http://www.jb100.net/html/content-28-477-1.html
Summary of experience and skills in using THinkPHP (3) http://www.jb100.net/html/content-28-479-1.html
Summary of experience and skills in using THinkPHP (4) http://www.jb100.net/html/content-28-248-1.html

This is the most comprehensive summary of THINKPHP usage techniques in history. It is easier to use than a manual. Various usages are explained in detail. It is especially suitable for novices. Don’t miss it if you pass by!

Promise:
1. All class library files must use .class.php as the file suffix, and the class name and file name must be consistent
2. The class name of the controller is suffixed with Action
3. The class name of the model is suffixed with Model, and the first letter of the class name must be capitalized
4. All database table names are in lowercase,

Such as:
Data table name: prefix_table name
Model class name: Table name Model Note: The first letter of the table name here must be capitalized
Create object: D('table name') Note: The first letter of the table name here must be capitalized

Define controller class
class IndexAction extends Action{
public function show(){
echo 'This is the new show operation';
}
}
Then enter
in the browser http://localhost/myApp/index.php/Index/show/

Define model class:
class table name Model extends Model{
[//Manually define fields [optional]
protected $fields = array(
'id',
'username',
'email',
'age',
'_pk'=>'id', //Primary key
'_autoInc'=>true //Whether to auto-increment
)
]
}

Recorded changes:
$User = D("User") // Instantiate User object
$User->find(1) // Find the record with id 1
$User->name = 'ThinkPHP' // Modify the name field of the found record to ThinkPHP
$User->save() // Save modified data
Update the value of a specific field
$User->setField('name','TopThink','id=1')
It can also support operations on fields
$User->setField('score','(score+1)','id=1')

Create a new record, method 1:
$User = new UserModel() //Instantiate User object
$User->Field name = field value //Assign a value to the field
$User->add() //Add record
Create a new record, method 2:
$data['field name'] = field value; //Assign a value to the field
$User = D('User'); //Instantiate the User object
$User->add($data); //$insertId, the return value of the Add method is the latest inserted primary key value, which can be obtained directly.
Added multiple records:
$User = new UserModel()
$data[0]['name'] = 'ThinkPHP'
$data[0]['email'] = 'sjolzy@chen.com'
$data[1]['name'] = 'Fleeting Years'
$data[1]['email'] = 'chen@sjolzy.cn'
$User>addAll($data)

Delete record
$User->find(2)
$User->delete() // Delete the found record
$User->delete('5,6') // Delete data with primary keys 5 and 6
$User->deleteAll() // Delete all the queried data

Record query

$User->getDbFields() //Get the current data fields
$User->findAll(); //Find all records
$User->findAll('1,3,8') //Query the record set whose primary key is 1,3,8
$User->count() // Get the number of records
$User->max('score') // Get the user's maximum points
$User->min('score','score>0') // Get the minimum points of users whose points are greater than 0
$User->avg('field name') // Get the average of the field values ​​of all records
$User->sum('Field name') // Statistical field value
$User->getN(2,'score>80','score desc') // Return the 2nd record that meets the conditions
$User->getN(2,'score>80','score desc') //You can also get the last second record
$User->first('score>80','score desc') //If you want to query the first record, you can also use
$User->last('score>80','score desc') // Get the last record
$User->top(5,'','score desc') // Get the top 5 records with the highest points
$User->getBy('name','liu21st') //Query records based on field values

$Model = new Model() // Instantiate a model object that does not correspond to any data table
$Model->query("select * from think_user where status=1")

$objrs = $Model->query("select * from think_user where status=1") //Custom query
$Model->execute("update think_user set name='thinkPHP' where status=1") //SQL operation used to update and write data, return the number of records affected

$User->startTrans() // Start transaction
$User->commit() // Submit transaction
$User->rollback() //Transaction rollback

Template:

$this->assign('name',$value); //Use the assign method in the Action class to assign values ​​to template variables. Regardless of the variable type, assign is always used for assignment

$this->display() // Output template file

Batch assignment
$array['name'] = 'thinkphp'
$array['email'] = 'chen@sjolzy.cn'
$array['phone'] = '12335678'
$this->assign($array)

$this->display() // Call the read operation template of the User module
$this->display('edit') // Call the edit operation template of the User module
$this->display('Member:read') // Call the read operation template of the Member module
$this->display('Xp@User:edit') // Call the edit operation template of the User module of the Xp theme
$this->display('../Member/read.html') // Directly specify the full name of the template file

Template tag:

{ } or {//Comment content } //Template comments
{$user['name']} //Output array variable
{$user:name} //Output the properties of the object

In order to facilitate template definition, regardless of whether the output template variable is an array or an object, it can be output in the following unified way:
{$user.name}
If it is the output of a multi-dimensional array or multi-layer object attribute, please use the following definition method:
{$user['sub']['name']}
{$user:sub:name}

Use function:
Format: {$varname|function1|function2=arg1,arg2,### }
Description:
There cannot be a space between the { and $ symbols, and there will be no problem with spaces in the following parameters
### represents the parameter position of the template variable itself
. . . . . . . . . . . . .

Since there are too many words, here are only some of my experiences and tips. More exciting sharing URLs are as follows:

Summary of experience and skills in using THinkPHP (1) http://www.jb100.net/html/content-28-475-1.html
Summary of experience and skills in using THinkPHP (2) http://www.jb100.net/html/content-28-477-1.html
Summary of experience and skills in using THinkPHP (3) http://www.jb100.net/html/content-28-479-1.html
Summary of experience and skills in using THinkPHP (4) http://www.jb100.net/html/content-28-248-1.html