How to update a table in laravel with a specific column value

Question

Please, some help I'm trying a different ways to update an especific row. Im trying with models, I posted my first attempt. That is not good... The other option is to update each column, but, will be usefull has other ideas or options...

Route::put('/usuario/{fk_id_tid}/{ident}', function (Request $request, $fk_id_tid, $ident) {

$validator = Validator::make($request->all(), [
    'ident' => 'required|digits_between:5,12',
    'fname' => 'required|max:20',
    'mname' => 'required|max:20',
    'lname' => 'required|max:20',
    'lname2' => 'required|max:20',
    'email' => 'email',
    'telefono' => 'min:7',
    'celular' => 'min:10',
]);

if ($validator->fails()){
    return redirect('/usuarios')
        ->withErrors($validator)
        ->withInput();

}        

$user =  DB::table('usuario')->where('fk_id_tid', $fk_id_tid)->where('ident', $ident)->first();  
$user->fk_id_tid = $request->id_tid;
$user->ident = $request->ident; 
$user->fname = $request->fname;
$user->mname = $request->mname;
$user->lname = $request->lname;
$user->lname2 = $request->lname2;
$user->email = $request->email;
$user->telefono = $request->telefono;
$user->celular = $request->celular;

$user->save();

return redirect('/usuarios');

});

the information of the columns comes with a post method.

Thanks for any help...

And why is it "not good"?

Amarnasan
– Amarnasan

2018-04-18 07:19:02 +00:00
Commented Apr 18, 2018 at 7:19 — Amarnasan
– Amarnasan, Commented Apr 18, 2018 at 7:19
Do you have Usuario model?

Levente Otta
– Levente Otta

2018-04-18 07:24:52 +00:00
Commented Apr 18, 2018 at 7:24 — Levente Otta
– Levente Otta, Commented Apr 18, 2018 at 7:24
Yes I have an Usuario Model,

Richard Camilo Saavedra Coneo
– Richard Camilo Saavedra Coneo

2018-04-19 01:56:33 +00:00
Commented Apr 19, 2018 at 1:56 — Richard Camilo Saavedra Coneo
– Richard Camilo Saavedra Coneo, Commented Apr 19, 2018 at 1:56

Nikita · Accepted Answer · 2018-04-18 10:13:15Z

1

Try this. Hope it will help you.Thanks.

$updateDetails=array(
  'fk_id_tid' => $request->id_tid;
  'ident'     => $request->ident; 
  'fname' => $request->fname;
  'mname' => $request->mname;
  'lname' => $request->lname;
  'lname2' => $request->lname2;
  'email' => $request->email;
  'telefono' => $request->telefono;
  'celular' => $request->celular;
);

DB::table('usuario')
    ->where('fk_id_tid', $fk_id_tid)
    ->where('ident', $ident)
    ->update($updateDetails);

answered Apr 18, 2018 at 10:13

Nikita

4372 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Richard Camilo Saavedra Coneo Over a year ago

I try 3 ways, the best one was the Nikita option, The other two present some kind of dificulty when we run the querys...

Rajeev Radhakrishnan · Accepted Answer · 2018-04-18 07:25:08Z

0

The other way is

$user =  DB::table('usuario')->where('fk_id_tid', $fk_id_tid)->where('ident', $ident)->first();  

$user->fk_id_tid = $request->id_tid;

if($request->ident)
{
  $user->ident = $request->ident;
} 

......

if($request->celular)
{
   $user->celular = $request->celular;
}

$user->save();

This updates specific columns depends upon inputs

answered Apr 18, 2018 at 7:25

Rajeev Radhakrishnan

99410 silver badges18 bronze badges

Comments

Nick · Accepted Answer · 2018-04-18 07:26:45Z

0

Use next syntax instead of fetching and saving:

DB::table('usuario')
    ->where('fk_id_tid', $fk_id_tid)
    ->where('ident', $ident)
    ->update([
        'mname' => $request->mname,
        'lname' => $request->lname2,
        'email' => $request->email,
        'telefono' => $request->telefono,
        'celular' => $request->celular,
    ]
);

answered Apr 18, 2018 at 7:26

Nick

10.2k8 gold badges65 silver badges97 bronze badges

Comments

Kuldeep Mishra · Accepted Answer · 2018-04-18 07:43:42Z

 DB::table('usuario')
   ->where('fk_id_tid', $fk_id_tid)
   ->where('ident', $ident)
   ->update([
    'mname' => $request->mname,
    'lname' => $request->lname2,
    'email' => $request->email,
    'telefono' => $request->telefono,
    'celular' => $request->celular,
  ]
);

or you can use model , just define your all fillable field in model and write query like this.

       Usuario::where('fk_id_tid', $fk_id_tid)
      ->where('ident', $ident)
    ->update([
    'mname' => $request->mname,
   'lname' => $request->lname2,
  'email' => $request->email,
  'telefono' => $request->telefono,
  'celular' => $request->celular,
   ]
);

//Usuario your model name , define your all field in the model like

public $fillable = ['add your all filable field here'];

Collectives™ on Stack Overflow

How to update a table in laravel with a specific column value

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related