How to delete data in thinkphp5

ThinkPHP 5.0 is a lightweight open source PHP framework. It is based on object-oriented programming ideas and MVC design pattern, providing simple and easy-to-use development tools and efficient and elegant code solutions. During the development process, using ThinkPHP 5.0 often requires operations such as adding, deleting, modifying, and querying data to the database.

1. Basic syntax

In ThinkPHP 5.0, the basic syntax for deleting data is:

Db::name('table')->where('condition')->delete();

Among them, Db::name('table') specifies the name of the data table to be operated, where('condition') specifies the conditions for deleting data, delete() indicates performing deletion operate.

2. Delete the data with the specified ID

If you want to delete the data with the specified ID in the database, you can proceed as follows:

Db::name('table')->delete(1);

Among them, 1 represents the ID number of the data to be deleted.

3. Delete data that meets the conditions

If you want to delete multiple pieces of data that meet the conditions, you can use the where condition Construct a delete statement. For example, to delete all data in the database with a status value of 0, you can write:

Db::name('table')->where('status', 0)->delete();

The above statement will delete the data table table All data in the status value is 0.

4. Delete multiple pieces of data

In ThinkPHP 5.0, you can delete multiple pieces of data that meet specified conditions at the same time. For example, to delete data whose status value is 0 and score value is less than 60, you can write:

Db::name(&#39;table&#39;)->where(&#39;status&#39;, 0)->where(&#39;score&#39;, &#39;<&#39;, 60)->delete();

The above statement will delete all status values ​​in the data table table that are 0 and score values ​​are less than 60 data.

5. Delete all data

If you want to delete all the data in the data table, you can use the following SQL statement:

truncate table table;

In ThinkPHP 5.0, you can also use the following code to operate:

Db::name('table')->truncate();

Note: The truncate() method does not support conditional deletion operations and is only used to delete data in the data table. All data.

6. Delete related operations

When deleting data, we often need to consider some related operations, such as deleting data in related tables at the same time , or delete related files, etc. In ThinkPHP 5.0, you can use the hook function after_delete() to perform related operations. For example, to delete the corresponding disk file when deleting data, you can write like this:

use think\Model;

class User extends Model
{
    protected static function afterDelete($user)
    {
        // 删除磁盘文件
        unlink('/path/to/file/' . $user['avatar']);
    }
}

The above code means that when deleting data, the after_delete() hook function will be triggered and the deleted file will be passed in. data.

The above is the detailed content of How to delete data in thinkphp5. For more information, please follow other related articles on the PHP Chinese website!