Save form data into database

 This post will help  step by step to understand , how to save your HTML form data into Mysql Database.

Database Table structure 

Form

Step 1

Make  HTML Form , code is given below

<form method="post" action="index">

    @csrf

    Name : <input type="text" name="name" placeholder="Your Name" required class="form-control"><br>

    Phone : <input type="text" name="phone" required placeholder="Phone Number" class="form-control"><br>

    Message :

    <textarea rows="5" name="message" required placeholder="Message" class="form-control"></textarea><br>

    <input type="submit" value="Save" name="submit">

</form>

Step 2 

Create Model by given command

php artisan make:model stumodel 

Model Location :  app\Models

Model Code

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class stumodel extends Model

{

protected $table = 'kashiquery';

    use HasFactory;

public $timestamps=false;

protected $fillable = [

'name', 'phone','message','createddate'

];

}

Step 3 : Create Controller

Create controller by given command below

Command : PHP artisan make:controller common

Controller location : app\Http\Controllers

Code

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\stumodel;

class common extends Controller

{

    public function AddData(Request $req)

{

        $data=new stumodel;

//$r = $req->input();

$data->name=$req["name"];

$data->phone=$req["phone"];

$data->message=$req["message"];

$data->createddate=date("Y-m-d");

$data->save();

return redirect('index');

    }

}

 

Step 4 : Configure Route

Route File Location : \routes\web.php 

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\common;

Route::get('/', function () {

    return view('index');

});

Route::view('index','index');

Route::post('index',[common::class,'AddData']);

Next Topic