通过 laravel 中的 url 传递多个字符串作为参数以从数据库中删除特定数据

发布于01月04日

我想删除通过url传递的多个字符串数据，用‘，’分隔.

场景是:

http://127.0.0.1:8888/remove/lui,kui

通过此路径，将删除数据库中的名称字段值的Lui和Kui数据.

我的web.php号文件

Route::get("/remove/{name}",[MyController::class,"remove"]);

MyController.php行文件

use App\Models\City;   
function remove($name){

}

谢谢，你的建议会很有帮助的.

推荐答案

You can accomplish this with the following:个

//The string of names
$names = "cat,cat,cat,mouse,dog,rabbit";

//We break it down, seperate them by comma, then add them to an array
//After we will get the unique values only of that array
$arrayOfNames = array_unique(explode(',', $names));
    
//search in the name column for any of these values
//delete if found
//note that you can change the word "name" to any other column name
City::whereIn('name', $arrayOfNames)->delete();

如果你在你的模型中有软删除特征，并想硬删除它:https://laravel.com/docs/9.x/eloquent#soft-deleting

//search in the name column for any of these values
//hard delete if found
City::whereIn('name', $arrayOfNames)->forceDelete();

如果您将来对此感兴趣，也可以进行更新:

//search in the name column for any of these values
//update if found
City::whereIn('name', $arrayOfNames)->update(['age' => 123, 'updated_at' => now()]);

希望它对您有很好的效果:)