Add Created_by and Modified_by values to database on form submission

Hi @supunsam

Why you want to store the name and not the user id? The ID is a much better reference. If users change their name your lost the reference for example.

You don't have to pass the id/name in the form but you can call the user ID in your controller by

Auth()->user()->id; // user ID
Auth()->user()->name; // user name.

you could use an observer to listen to the creating event and automatically add the id of the logged in user

Hi @supunsam , if you want to create a reference for created user and modified user you can define a relationship for this. You can follow the code below.

In your controller

public function store(Request $request,Model $model){
    $data = $request->all();
    $data['user_id'] = auth()->user()->id;
    $model->create($data);
    return ........
}


public function update(Request $request,Model $model){
    $data = $request->all();
    $data['modified_user_id'] = auth()->user()->id;
    $model->update($data);
    return ........
}

and then in your model

public function created_user(){
    return $this->belongsTo(User::class);
}

public function updated_user(){
    return $this->belongsTo(User::class, 'modified_user_id');
}

and your database should like this,

  |  ......  |  user_id  |  modified_user_id  |

you modified_user_id column should nullable,

then you can call the relationship like this,

$model = Model::find(1);

$created_user_name = $model->created_user->name

$updated_user_name = $model->updated_user->name

Of course. I meant the user-id, not the username. my bad.

Thank you very much @utpal2015 . Your method simply works. Anyhow, I also figured out to do this with hidden input submissions as well. But your method is a much cleaner one. Thanks.