Tuesday, February 11, 2025
HomePHPThe way to insert information into MySQL database utilizing Laravel 11

The way to insert information into MySQL database utilizing Laravel 11


To insert information right into a MySQL database utilizing Laravel 11, it’s important to observe the beneath steps:

Minimal requirement: PHP 8.2 or increased is required to run Laravel 11. 

Step 1: Create a database

create databse userdb

Step 2: Create the MySQL desk (tblusers)

Desk construction for desk tblusers

CREATE TABLE `tblusers` (
  `id` int(11) NOT NULL,
  `firstName` varchar(255) DEFAULT NULL,
  `lastName` varchar(255) DEFAULT NULL,
  `emailId` varchar(255) DEFAULT NULL,
  `mobileNumber` bigint(11) DEFAULT NULL,
  `handle` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `metropolis` varchar(255) DEFAULT NULL,
  `postingDate` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Step 3: Set Up Your Surroundings
Ensure your MySQL database is correctly configured. In your .env file, configure the database connection:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=your_database_name
DB_USERNAME=your_database_username
DB_PASSWORD=your_database_password

Step 4: Create a blade file (sources/views/kind.blade.php)

<html>
<head>
<title></title>
<hyperlink href="https://cdn.jsdelivr.web/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">
<script src="https://cdn.jsdelivr.web/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js"></script>
<fashion>
    physique {
  background: #fafbfb;
}
/* FOOTER STYLES
–––––––––––––––––––––––––––––––––––––––––––––––––– */
.page-footer {
  place: mounted;
  proper: 0;
  backside: 50px;
  show: flex;
  align-items: middle;
  padding: 5px;
  z-index: 1;
}

.page-footer a {
  show: flex;
  margin-left: 4px;
}</fashion>
</head>
<physique>
    <div class="container my-5">
        <div class="row justify-content-center">
          <div class="col-lg-9">
            <h1 class="mb-3">Register with us</h1>
            <hr />
            @if(session('success'))
            <div class="alert alert-success">{{ session('success') }}</div>
        @endif
        @if(session('error'))
        <div class="alert alert-danger">{{ session('error') }}</div>
        @endif

            <kind technique="put up" motion="{{ route('insertdata') }}">
              @csrf
              <div class="row g-3">
                <div class="col-md-6">
                  <label for="your-name" class="form-label">First Title</label>
                  <enter sort="textual content" class="form-control" id="firstName" title="firstName"  worth="{{ outdated('firstName') }}">
                  <span class="text-danger">
                  @error('firstName')
                  {{ $message }}
                  @enderror
                  </span>
                </div>
            
                <div class="col-md-6">
                  <label for="your-surname" class="form-label">Final Title</label>
                  <enter sort="textual content" class="form-control" id="lastName" title="lastName"  worth="{{ outdated('lastName') }}">
                  <span class="text-danger">
                    @error('lastName')
                    {{ $message }}
                    @enderror
                    </span>
                </div>
                <div class="col-md-6">
                  <label for="your-email" class="form-label"> Electronic mail ID</label>
                  <enter sort="e mail" class="form-control" id="emailId" title="emailId"  worth="{{ outdated('emailId') }}">
                  <span class="text-danger">
                    @error('emailId')
                    {{ $message }}
                    @enderror
                    </span>
                </div>
                <div class="col-md-6">
                  <label for="your-subject" class="form-label">Cellular No</label>
                  <enter sort="textual content" class="form-control" id="mobileNumber" title="mobileNumber"  worth="{{ outdated('mobileNumber') }}">
                  <span class="text-danger">
                    @error('mobileNumber')
                    {{ $message }}
                    @enderror
                    </span>
                </div>
                <div class="col-12">
                  <label for="your-message" class="form-label">Handle</label>
                  <textarea class="form-control" id="handle" title="handle" rows="5" > {{ outdated('handle') }}</textarea>
                  <span class="text-danger">
                    @error('handle')
                    {{ $message }}
                    @enderror
                    </span>
                </div>
                <div class="col-md-6">
                    <label for="your-email" class="form-label"> Metropolis</label>
                    <enter sort="textual content" class="form-control" id="metropolis" title="metropolis"  worth="{{ outdated('metropolis') }}">
                    <span class="text-danger">
                      @error('metropolis')
                      {{ $message }}
                      @enderror
                      </span>
                  </div>
                  <div class="col-md-6">
                    <label for="your-subject" class="form-label">State</label>
                    <enter sort="textual content" class="form-control" id="state" title="state"  worth="{{ outdated('state') }}">
                    <span class="text-danger">
                      @error('state')
                      {{ $message }}
                      @enderror
                      </span>
                  </div>


                <div class="col-12">
                  <div class="row">
                    <div class="col-md-6">
                      <button sort="submit" class="btn btn-dark w-100 fw-bold" title="submit" >Submit</button>
                    </div>
                  </div>
                </div>
              </div>
            </kind>
          </div>
        </div>
      </div>
      
</physique>
</html>

Step 5: Create a Mannequin and Migration
Create a mannequin that can correspond to the database desk you wish to insert information into. You are able to do this utilizing the artisan command:

php artisan make:mannequin your_ModelName

//for this tutorial
php artisan make:mannequin UserInsert

You outline the desk title and fields which might be mass assignable (e.g., firstname, LastName, emailId) on this mannequin.

<?php
namespace AppModelsmodel;
use IlluminateDatabaseEloquentModel;

class UserInsert extends Mannequin
{
    protected $desk="tblusers";
	public $timestamps = false;
    protected $fillable = [
		'firstName', 'lastName','emailId', 'mobileNumber','handle','state','metropolis'
	];
}

Step 6: Create a controller for dealing with consumer inputs and insert the info into the database.

php artisan make:controller your_contollername
//For this tutorial
php artisan make:controller insertController
<?php
namespace AppHttpControllers;
use IlluminateSupportFacadesDB;
use IlluminateHttpRequest;
Use AppModelsUserInsert;

class insertController extends Controller
{
    public perform insertdata(Request $request){
        $request->validate([
            'firstName' => 'required',
            'lastName' => 'required',
            'emailId' => 'required',
            'mobileNumber' => 'required|numeric|digits:10',
            'handle' => 'required',
            'state' => 'required',
             'metropolis' => 'required'
            
                    ]);

                    $consumer=DB::desk('tblusers')
                    ->insert([
                        'firstName' => $request->firstName,
                        'lastName' => $request->lastName,
                        'emailId' => $request->emailId,
                        'mobileNumber' => $request->mobileNumber,
                        'handle' => $request->handle,
                        'state' => $request->state,
                        'metropolis' => $request->metropolis
                    ]);
                    if($consumer){
                        return redirect()->route('kind')->with('success', 'Information inserted efficiently.');
                    } else{
                        return redirect()->route('kind')->with('error', 'One thing went unsuitable . Please Strive once more.');
                    }
}
}

Step7: Add a Path to Deal with the Type Submission

<?php
use IlluminateSupportFacadesRoute;
use AppHttpControllersinsertController;

// For kind
Route::get('/', perform () {
    return view('kind');
})->title('kind');

// For Type Submission
Route::put up('/insertdata',[insertController::class,'insertdata'])->title('insertdata');

The way to run the Script

1. Obtain the venture zip file

2. Extract the file and duplicate insert-app  folder

3. Paste inside root listing (for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/Html)

4.Open PHPMyAdmin (http://localhost/phpmyadmin)

5. Create a database with the title  userdb

6. Import userdb.sql file(given contained in the zip package deal in SQL file folder)

7. Run these command

PS C :> cd xampp/htdocs/insert-app

PS C:xampphtdocsinsert-app> php artisan serve

8. After that open the browser run the script

http://127.0.0.1:8000/

Obtain Full supply code(Insert Information Utilizing Laravel11)
Dimension: 27.4 MB
Model: V 1.0

The put up The way to insert information into MySQL database utilizing Laravel 11 appeared first on PHPGurukul.

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Recent Comments