CRUD APPLICATION PART 1 ( HOW TO INSERT DATA INTO DATABASE )

 ROUTE CODE:

Route::get('/employee' , [EmployeeController::class,'index']);
Route::post('/employee' , [EmployeeController::class,'create']);

CONTROLLER CODE:
<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB; // MUST INLCUDE THIS NAMESPACE FOR USING DATABASE QUERIES

class EmployeeController extends Controller
{
    public function index()
    {
            return view('employee');
    }

    public function create(Request $request)
    {
        //echo "Insert data ";
       $name = request('name');
       $age = request('age');
       $salary = request('salary');

       //echo $name . "  ". $age . "  ". $salary;

       $query = DB::insert('insert into employees (name,age,salary) values (?,?,?)',[$name,$age,$salary]);

       if($query)
       {
            echo "Data successfully inserted";

       }
       else{
        echo "Data insertion failed";

       }



    }
}

HTML CODE:




<div class="container">
    <div class="row">
        <div class="col-6">
    <form action="{{url('/employee')}}" method="POST">
        @csrf
        <input type="text" name="name" placeholder="Enter your name"><br>

        <input type="text" name="age" placeholder="Enter your age"><br>
        <input type="text" name="salary" placeholder="Enter your salary"><BR>



        <button type="submit"> SUBMIT </button>
    </form>

        </div>
    </div>
</div>