Level 37
Is the updated_by field listed in the $fillable array in the Service model?
Jul 16, 2023
5
Level 1
Updating laravel foreign keys updated_by in services table
I have created two tables that are users and services. Services table have two foreign keys as created_by and updated_by. Now when i try to update the field updated_by in services table it is not updating infact it is returning null value.
Thats the Services model specifying the relationship with users.
public function user(): BelongsTo { return $this->belongsTo(User::class, 'created_by'); }
Thats index, store and update method
public function index() { $service = Service::with('user')->latest()->get(); return view('admin.service.index', compact('service')); }
Service::insert([ 'created_by' => auth()->user()->id, 'description' => $request->description 'title' => $request->title, 'slug' => strtolower(str_replace(' ', '-',$request->title)), 'created_at' => Carbon::now(), 'image' => $save_url, ]);
Update Method
Service::findOrFail($service_id)->update([ 'updated_by' => auth()->user()->id, 'description' => $request->description, 'title' => $request->title, 'slug' => strtolower(str_replace(' ', '-',$request->title)), 'updated_at' => Carbon::now(), 'image' => $save_url, ]);
Thats the table in Index.blade.php
Level 1
@nexxai I have assigned protected guarded property to service model
Level 37
@Hassaan69 Ok, which properties do you have set as guarded?
Level 11
Another possibility is that you're performing the update as non logged in user, so auth()->user()->id is null, then.
Level 122
are the other columns updated correctly?
Please or to participate in this conversation.