我必须更新3个表数据,这些表数据是由laravel中的inner连接的。在laravel中是否有查询系统可以一次更新这些内容
发布于 2020-02-26 20:45:00
简单的回答是有!下面是一个快速示例Task.php
class Task extends Model
{
protected $fillable =
[
'user_id',
];
public function user() {
return $this->belongsTo('App\User');
}
public function engagements()
{
return $this->belongsToMany('App\Engagement', 'engagement_task', 'task_id', 'engagement_id');
}
}TasksController.php
public function update(Request $request, Task $task)
{
if ($task->user_id !== auth()->user()->id) {
return response()->json('Unauthorized', 401);
}
$data = $request->validate([
'user_id' => 'required|integer',
]);
$task->update($data);
$status = $request->validate([
'status' => 'required|string'
]);
$task->engagements()->update($status);
return response($task, 200);
}来源:https://laracasts.com/discuss/channels/laravel/how-to-update-multiple-tables-at-the-same-time
https://stackoverflow.com/questions/60414100
复制相似问题