Home > PHP Framework > ThinkPHP > body text

How to use the delete method in thinkphp

王林
Release: 2023-05-27 13:24:47
forward
2149 people have browsed it

1. Use the delete method

In ThinkPHP, we can use the delete method to delete data. This method is very simple and only needs to be used in the model. Just use the delete method, for example:

$user = UserModel::get(1);
$user->delete();
Copy after login

This way you can delete the user with ID 1. If your Model does not specify a primary key, you can use the following method:

$user = UserModel::get(['name' => 'thinkphp']);
$user->delete();
Copy after login

In this way, you can delete the user named thinkphp.

2. Chain deletion

In ThinkPHP, we can also use chain deletion to delete data. This method is more commonly used, such as:

$user = UserModel::where('id', 1)->delete();
Copy after login

This method will delete the user data with ID 1 and return the number of deleted rows.

3. Soft deletion

In ThinkPHP, we can also use soft deletion to delete data. The so-called soft deletion means marking the data as deleted rather than actually deleting the data. This operation is useful in data recovery, data query, etc. We can use soft deletion in the model, for example:

class UserModel extends Model
{
    use SoftDelete;

    protected $deleteTime = 'delete_time';

    protected $defaultSoftDelete = 0;

    protected $autoWriteTimestamp = true;
}
Copy after login

In this example, we use the Trait of SoftDelete and set the delete_time field to the deletion time. In this way, when we use the delete method or chain deletion method, the corresponding data will be marked as deleted instead of actually deleting the data.

4. Batch deletion

When developing projects, we sometimes need to delete data in batches. There are two methods:

1. Use SQL Statement

We can directly use SQL statements to delete data in batches, for example:

Db::table('user')->where('id', 'in', [1, 2, 3])->delete();
Copy after login

This method will delete user data with IDs 1, 2, and 3, and return the number of deleted rows.

2. Use the delete method of the model

We can also use the delete method of the model to delete data in batches, for example:

UserModel::destroy([1, 2, 3]);
Copy after login

This method will delete the IDs 1 and 2 , 3 user data, and returns the number of deleted rows.

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

Related labels:
source:yisu.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template