laravel 8 using DB

gistfile1.txt

Validation with messsage


 $messages = [
                'name.required' => 'Please Enter Name.',
                'email.required' => 'Please Enter Email.',
                'password.required' => 'Please Enter Password.',
            ];
            $validator = Validator::make($request->all(), [
                'name' => 'required',
                'email' => 'required',
                'password' => 'required',
            ], $messages);

            if ($validator->fails()) {
                return redirect()->back()->withInput()->withErrors($validator->messages());
            }

================================================

Error messages

  <div class="card">
    @if (count($errors) > 0)
<div class="msgcheck">
@foreach ($errors->all() as $error)
<div class="alert alert-danger alert-dismissible fade show" role="alert">
<strong>Error!</strong> {{ $error }}
<button type="button" class="close" data-dismiss="alert" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
</div>
@endforeach
</div>


================================================


$data = $request->except('_method','_token','submit');

## Create query

$create = DB::table('users')->insert([
                    'name' => $name,
                    'email' => $email,
                    'password' => md5($password)
                ]);

========================================================


update query

        $update = DB::table('users')->where('id', $id)->update([
        'name' => $data['name'],
        'password' => md5($data['password']),
        ]);
        
        
        
========================================================

delete query


$delete = DB::table('users')->where('id', $id)->delete();

$user = User::findOrFail($id)->delete(); 

Store

public function store(Request $request)
    {
       $data = $request->except('update', '_token');

        $newuser = User::create($data);
        if($newuser){
            return redirect('list');
        }
    }

or

$create = DB::table('users')->insert([ 'name' => $name, 'email' => $email, 'password' => md5($password) ]);

Or

       $user = new User;

       $user->name = $request->name;
       $user->email = $request->email;
       $user->password = md5($request->password);
       $user->save();