在Yii 中刪除數(shù)據(jù)時(shí)，應(yīng)根據(jù)場景選擇合適的方法。若要?jiǎng)h除單條記錄，需先用findOne() 或find()->where(...)->one() 加載模型，再調(diào)用delete() 方法，如$model = Post::findOne(123); if ($model !== null) { $model->delete(); }；此方法會觸發(fā)beforeDelete 和afterDelete 事件。若要?jiǎng)h除多條記錄，可使用Post::deleteAll(['author_id' => 456]) 或帶條件的Post::deleteAll('created_at '2020-01-01'])，但該方法不會觸發(fā)模型事件。對於軟刪除，可通過添加is_deleted 字段並在查詢中加入->andWhere(['is_deleted' => false]) 過濾，並通過更新字段值代替實(shí)際刪除。此外，使用deleteAll() 時(shí)務(wù)必確認(rèn)條件準(zhǔn)確性，處理關(guān)聯(lián)數(shù)據(jù)時(shí)應(yīng)確保外鍵約束，並註意事件觸發(fā)差異。

In Yii, deleting data using models is straightforward, but it's important to understand the right way to do it depending on your use case. The main idea is that you can either delete a single record or multiple records, and there are different methods for each.

Deleting a Single Record

To delete a single record, you first need to load the model with the data you want to delete. This is usually done using findOne() or find()->where(...)->one() . Once you have the model instance, you can call the delete() method on it.

For example:

 $model = Post::findOne(123);
if ($model !== null) {
    $model->delete();
}

This will remove the record with the primary key 123 from the Post model. Make sure to check if the model exists before calling delete() to avoid errors.

Also, keep in mind that this method triggers any beforeDelete and afterDelete events defined in your model. These are useful if you need to perform cleanup tasks or logging before or after deletion.

Deleting Multiple Records

If you want to delete more than one record at once, you can use the deleteAll() method. This method accepts conditions similar to find()->where() and deletes all matching records directly from the database.

Here's how you might delete all posts by a specific author:

 Post::deleteAll(['author_id' => 456]);

You can also pass more complex conditions:

 Post::deleteAll(&#39;created_at < :date&#39;, [&#39;:date&#39; => &#39;2020-01-01&#39;]);

Unlike delete() , the deleteAll() method does not trigger beforeDelete or afterDelete events. So if your model relies on those for cleanup logic, they won't run here. Use this method carefully, especially when dealing with large datasets.

Soft Deletion (Optional but Common)

Sometimes you don't want to permanently delete data but just mark it as deleted. This is called soft deletion. Yii doesn't handle this automatically, but you can implement it easily by adding a column like is_deleted or deleted_at .

You would then filter out soft-deleted records using a query condition:

 // In your model
public static function find()
{
    return parent::find()->andWhere(['is_deleted' => false]);
}

Then, instead of calling delete() , you update the flag:

 $model->is_deleted = true;
$model->save(false); // skip validation if appropriate

This approach helps prevent accidental loss of data and allows recovery if needed.

A Few Things to Watch Out For

• Always double-check your conditions when using deleteAll() — a typo could wipe out more data than intended.
• If you're working with relational data, make sure related records are handled properly — Yii won't automatically manage foreign key constraints unless your database does.
• Be cautious with event triggers: delete() runs them, deleteAll() does not.

基本上就這些。

以上是如何使用YII模型從數(shù)據(jù)庫中刪除數(shù)據(jù)？的詳細(xì)內(nèi)容。更多資訊請關(guān)注PHP中文網(wǎng)其他相關(guān)文章！