Summary of related content about database operation return values ​​in ThinkPHP

Reprinted from: Summary of database operation return values ​​in ThinkPHP

Keywords: Thinkphp, return value, database operation, select return value, add return value, setDec return value

Thinkphp in The Think\Model class provides the basic CURD (Create, Update, Read and Delete) of the database, which can be easily operated through this class.
The main methods of Model class and extension class are:

1. Create operation:
   create() (non-chain), add(), addAll()
   Supported chain operations include:
   table, data, field, relation, validate, auto, filter, scope, bind, token, comment

2. ##Update operation

   save( ), setField(), setInc(), setDec()
   Supported chain operations are:
   where, table, alias, field, order, lock, relation, scope, bind, comment
   

3. Read operation

   find(), select(), getField(), Count, Max, Min, Avg, Sum
   Supported chain operations are:
   where, table, alias, field, order, group, having, join, union, distinct, lock, cache, relation, result, scope, bind, comment
   

4. Delete operation

   delete()
   Supported chain operations include:
   where, table, alias, order, lock, relation, scope, bind, comment
   

##The possible return values ​​of these methods are false /true/one-digit array/two-dimensional array/numeric (number)/null/Instances of the class itself are summarized as follows:

1. Chain operation:

So chain operation Both return instances of the Model class, that is, you can use the return value to continue calling instance methods.

$User=M("User");
$U1=$User->$where("id = 1");//$U1可以继续调用其他方法。
$result=$U1->select();
//-------一般情况下没有必要这样，下面一句代码即可实现
$result=M("User")->$where("id = 1")->select();

2. Create operation

create return value:

If an error occurs, false is returned;

If successful, the created data is returned

create It is a non-chain operation, and the return value may be a Boolean value, so strict judgment must be made during the operation:

$User = M("User");
if($User->create()){
//进行更多操作
}

add return value, addAll return value

Success: If the primary key is an automatic growth type, the return value is the new record Id value (addAll is the maximum value), otherwise it returns true;
If an error occurs, it returns false;

3. Update operation

save return value (setField, setInc, and setDec all call the save method at the end, so the return value is consistent with save ):
• save The return value is the number of records affected (may be 0). If an update error occurs, false is returned. Therefore, identity must be used to determine whether the update fails.

  
  

4. Read operation

find return value
1. If the query error occurs, the return value of find is false

   If the query result If it is empty, NULL is returned. If the query is successful, an associative array is returned (the key value is the field name or alias).
   
   

select return value
2. If the query error occurs, the return value of select is false.

   If the query result is empty, NULL is returned, otherwise a two-dimensional array is returned.
   
   

getField return value
getField($field): $field is a field and returns the first value of the field in the database The value of the row
getField($field,true):$field is a field and returns a one-dimensional array containing the field
getField ($fields): $fields is two fields (separated by ","), and returns an array of array($field1=>$field2); if $field is multiple fields, returns a multi-dimensional array similar to select, key Named field1.
getField($fields,”:”): $field is multiple fields and returns an array similar to array($field1=>”$field2:$field3”)
If there is an error in the query, the return value of getField is false
The query is successful:

Count, Max, Min, Avg, Sum return value
4. If the query error occurs, the return value is false

   If the query is successful, the corresponding value is returned
   
   

5. Delete operation

delete Return value: true if successful, false if query error

• This article explains the summary of the return value of database operations in ThinkPHP. For more related content, please visit Follow php Chinese website.

  related suggestion:

Related content about thinkphp base class

ThinkPHP users Login and registration related code cases

About thinkphp5 database operations

##

The above is the detailed content of Summary of related content about database operation return values ​​in ThinkPHP. For more information, please follow other related articles on the PHP Chinese website!