How to insert data in database - Laravel

        How to insert data in database - Laravel
        Insert Data In Data Base Laravel 

        We going to show you that how to insert data in database - Laravel

        These Are given steps you follow and complete your task .

        1st we create a table in databse

        The INSERT INTO statement is used to insert new data to a MySQL table:

        INSERT INTO table_name (column1, column2, column3,...)
        VALUES (value1, value2, value3,...)
        To learn more about SQL, please visit our SQL tutorial.

        For creating table the SQL query is:

        SQL Query
        CREATE TABLE student_details
        (
        id int NOT NULL AUTO_INCREMENT,
        first_name varchar(50),
        last_name varchar(50),
        city_name varchar(50),
        email varchar(50),
        PRIMARY KEY (id)
        );

        Create 3 files for insert data in Laravel :

        StudInsertController.php (app/Http/Controllers/StudInsertController.php)
        stud_create.php (resources/views/stud_create.php)
        web.php (routes/web.php)
        stud_create.blade.php(View File)

        <!DOCTYPE html>
        <html>
        <head>
        <title>Student Management | Add</title>
        </head>
        <body>
        @if (session('status'))
        <div class="alert alert-success" role="alert">
            <button type="button" class="close" data-dismiss="alert">×</button>
            {{ session('status') }}
        </div>
        @elseif(session('failed'))
        <div class="alert alert-danger" role="alert">
            <button type="button" class="close" data-dismiss="alert">×</button>
            {{ session('failed') }}
        </div>
        @endif
        <form action = "/create" method = "post">
            <input type = "hidden" name = "_token" value = "<?php echo csrf_token(); ?>">
            <table>
            <tr>
            <td>First Name</td>
            <td><input type='text' name='first_name' /></td>
            <tr>
            <td>Last Name</td>
            <td><input type="text" name='last_name'/></td>
            </tr>
            <tr>
            <td>City Name</td>
            <td>
            <select name="city_name">
            <option value="bbsr">Bhubaneswar</option>
            <option value="cuttack">Cuttack</option>
            </select></td>
            </tr>
            <tr>
            <td>Email</td>
            <td><input type="text" name='email'/></td>
            </tr>

            <tr>
            <td colspan = '2'>
            <input type = 'submit' value = "Add student"/>
            </td>
            </tr>
            </table>
        </form>
        </body>
        </html>


        <!-- StudInsertController.php(Controller File) -->

        <?php
        namespace App\Http\Controllers;
        use App\StudInsert;
        use Illuminate\Http\Request;
        use \Illuminate\Http\Response;
        use Illuminate\Support\Facades\Validator;
        use Illuminate\Validation\Rule;

        class StudInsertController extends Controller
        {
            
            public function insert(){
                $urlData = getURLList();
                return view('stud_create');
            }
            public function create(Request $request){
                $rules = [
                    'first_name' => 'required|string|min:3|max:255',
                    'city_name' => 'required|string|min:3|max:255',
                    'email' => 'required|string|email|max:255'
                ];
                $validator = Validator::make($request->all(),$rules);
                if ($validator->fails()) {
                    return redirect('insert')
                    ->withInput()
                    ->withErrors($validator);
                }
                else{
                    $data = $request->input();
                    try{
                        $student = new StudInsert;
                        $student->first_name = $data['first_name'];
                        $student->last_name = $data['last_name'];
                        $student->city_name = $data['city_name'];
                        $student->email = $data['email'];
                        $student->save();
                        return redirect('insert')->with('status',"Insert successfully");
                    }
                    catch(Exception $e){
                        return redirect('insert')->with('failed',"operation failed");
                    }
                }
            }
        }
        StudInsert.php(Model File)
        <?php
        namespace App;

        use Illuminate\Database\Eloquent\Model;

        class StudInsert extends Model
        {
            protected $table = 'student_details';
            public $timestamps = true;
            /**
             * The attributes that are mass assignable.
             *
             * @var array
             */
            protected $fillable = [
                'first_name', 'last_name','city_name', 'email',
            ];
        }
        web.php
        <?php
        /*
        |--------------------------------------------------------------------------
        | Web Routes
        |--------------------------------------------------------------------------
        |
        | You visit web page and past this route code.
        |
        */
        //insert data
        Route::get('insert','StudInsertController@insertform');
        Route::post('create','StudInsertController@insert');