Laravel 7 MongoDB CRUD Tutorial Example
Laravel is the most popular framework of php. laravel better than another PHP framework because it handles the command base. so let us see about laravel 7 MongoDB CRUD tutorial example. it was released on Sept 03, 2019.
Now, we follow the below step for creating the laravel 7 MongoDB CRUD operation(Laravel 7 CRUD example).
Overview
Step 1: Install Laravel 7
Step 2: Configure MongoDB database
Step 3: Install laravel-mongodb Package
Step 4: Add Route
Step 5: Create Model and Controller
Step 6: Create Blade Files
Step 1: Install Laravel 7
We are going to install laravel 7, so first open the command prompt or terminal and go to go to xampp htdocs folder directory using the command prompt. after then run the below command.
1 | composer create-project --prefer-dist laravel/laravel laravel7_crud_mongodb |
Step 2: Configure MongoDB database
After the complete installation of laravel. we have to database configuration. now we will open the .env file and add the MONGO_DB_HOST, MONGO_DB_PORT, MONGO_DB_DATABASE, MONGO_DB_USERNAME and MONGO_DB_PASSWORD in the .env file.
1 2 3 4 5 | MONGO_DB_HOST=127.0.0.1 MONGO_DB_PORT=27017 MONGO_DB_DATABASE=mongoproject MONGO_DB_USERNAME=SECRET MONGO_DB_PASSWORD=SECRET |
Now, we have to add a connection array of MongoDB in the config/database.php file.
1 2 3 4 5 6 7 8 9 10 11 12 13 | 'connections' => [ ... 'mongodb' => [ 'driver' => 'mongodb', 'host' => env('MONGO_DB_HOST', 'localhost'), 'port' => env('MONGO_DB_PORT', 27017), 'database' => env('MONGO_DB_DATABASE'), 'username' => env('MONGO_DB_USERNAME'), 'password' => env('MONGO_DB_PASSWORD'), 'options' => [] ], ] |
Step 3: Install laravel-mongodb Package
Now, we are going to install the “jenssegers/mongodb” package using the below command.
1 | composer require jenssegers/mongodb |
After the install the package We will add below providers in the “config/app.php” file.
1 2 3 4 5 6 7 8 9 10 11 12 | <?php return [ .... 'providers' => [ .... Jenssegers\Mongodb\MongodbServiceProvider::class, ] ..... ] ?> |
Step 4: Add Route
We have to need put below the student resource route in routes/web.php
1 | Route::resource('student','StudentController'); |
Step 5: Create a Model and Controller
Here below command help to create the controller and model.
1 | php artisan make:controller StudentController --resource --model=Student |
Student.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | <?php namespace App; use Illuminate\Database\Eloquent\Model; class Student extends Model { protected $connection = 'mongodb'; protected $collection = 'students'; protected $fillable = [ 'first_name','last_name', 'address' ]; } ?> |
StudentController.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 | <?php namespace App\Http\Controllers; use App\Student; use Illuminate\Http\Request; class StudentController extends Controller { /** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // $students = Student::all(); return view('student.list', compact('students','students')); } /** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create() { // return view('student.create'); } /** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { // $request->validate([ 'txtFirstName'=>'required', 'txtLastName'=> 'required', 'txtAddress' => 'required' ]); $student = new Student([ 'first_name' => $request->get('txtFirstName'), 'last_name'=> $request->get('txtLastName'), 'address'=> $request->get('txtAddress') ]); $student->save(); return redirect('/student')->with('success', 'Student has been added'); } /** * Display the specified resource. * * @param \App\Student $student * @return \Illuminate\Http\Response */ public function show(Student $student) { // return view('student.view',compact('student')); } /** * Show the form for editing the specified resource. * * @param \App\Student $student * @return \Illuminate\Http\Response */ public function edit(Student $student) { // return view('student.edit',compact('student')); } /** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param \App\Student $student * @return \Illuminate\Http\Response */ public function update(Request $request,$id) { // $request->validate([ 'txtFirstName'=>'required', 'txtLastName'=> 'required', 'txtAddress' => 'required' ]); $student = Student::find($id); $student->first_name = $request->get('txtFirstName'); $student->last_name = $request->get('txtLastName'); $student->address = $request->get('txtAddress'); $student->update(); return redirect('/student')->with('success', 'Student updated successfully'); } /** * Remove the specified resource from storage. * * @param \App\Student $student * @return \Illuminate\Http\Response */ public function destroy(Student $student) { // $student->delete(); return redirect('/student')->with('success', 'Student deleted successfully'); } } ?> |
Step 6: Create Blade Files
So finally, first we will create the layout.blade.php files and the second time we will create list.blade.php, create.blade.php, view.blade.php, and edit.blade.php in “resources/ views/student/” directory.
layout.blade.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | <!DOCTYPE html> <html lang="en"> <head> <title>Bootstrap Example</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/css/bootstrap.min.css"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/js/bootstrap.min.js"></script> </head> <body> <div class="container"> @yield('content') </div> </body> </html> |
list.blade.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 | @extends('student.layouts.app') @section('content') <div class="row"> <div class="col-lg-11"> <h2>Laravel 7 Mongodb CRUD Tutorial Example</h2> </div> <div class="col-lg-1"> <a class="btn btn-success" href="{{ route('student.create') }}">Add</a> </div> </div> @if ($message = Session::get('success')) <div class="alert alert-success"> <p>{{ $message }}</p> </div> @endif <table class="table table-bordered"> <tr> <th>No</th> <th>First Name</th> <th>Last Name</th> <th>Address</th> <th width="280px">Action</th> </tr> @php $i = 0; @endphp @foreach ($students as $student) <tr> <td>{{ ++$i }}</td> <td>{{ $student->first_name }}</td> <td>{{ $student->last_name }}</td> <td>{{ $student->address }}</td> <td> <form action="{{ route('student.destroy',$student->id) }}" method="POST"> <a class="btn btn-info" href="{{ route('student.show',$student->id) }}">Show</a> <a class="btn btn-primary" href="{{ route('student.edit',$student->id) }}">Edit</a> @csrf @method('DELETE') <button type="submit" class="btn btn-danger">Delete</button> </form> </td> </tr> @endforeach </table> @endsection |
create.blade.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 | @extends('student.layouts.app') @section('content') <div class="row"> <div class="col-lg-11"> <h2>Add New Student</h2> </div> <div class="col-lg-1"> <a class="btn btn-primary" href="{{ url('student') }}"> Back</a> </div> </div> @if ($errors->any()) <div class="alert alert-danger"> <strong>Whoops!</strong> There were some problems with your input.<br><br> <ul> @foreach ($errors->all() as $error) <li>{{ $error }}</li> @endforeach </ul> </div> @endif <form action="{{ route('student.store') }}" method="POST"> @csrf <div class="form-group"> <label for="txtFirstName">First Name:</label> <input type="text" class="form-control" id="txtFirstName" placeholder="Enter First Name" name="txtFirstName"> </div> <div class="form-group"> <label for="txtLastName">Last Name:</label> <input type="text" class="form-control" id="txtLastName" placeholder="Enter Last Name" name="txtLastName"> </div> <div class="form-group"> <label for="txtAddress">Address:</label> <textarea class="form-control" id="txtAddress" name="txtAddress" rows="10" placeholder="Enter Address"></textarea> </div> <button type="submit" class="btn btn-default">Submit</button> </form> @endsection |
view.blade.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | @extends('student.layouts.app') @section('content') <div class="row"> <div class="col-lg-11"> <h2>Laravel 7 CRUD Example</h2> </div> <div class="col-lg-1"> <a class="btn btn-primary" href="{{ url('student') }}"> Back</a> </div> </div> <table class="table table-bordered"> <tr> <th>First Name:</th> <td>{{ $student->first_name }}</td> </tr> <tr> <th>Last Name:</th> <td>{{ $student->first_name }}</td> </tr> <tr> <th>Address:</th> <td>{{ $student->address }}</td> </tr> </table> @endsection |
edit.blade.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 | @extends('student.layouts.app') @section('content') <div class="row"> <div class="col-lg-11"> <h2>Update Student</h2> </div> <div class="col-lg-1"> <a class="btn btn-primary" href="{{ url('student') }}"> Back</a> </div> </div> @if ($errors->any()) <div class="alert alert-danger"> <strong>Whoops!</strong> There were some problems with your input.<br><br> <ul> @foreach ($errors->all() as $error) <li>{{ $error }}</li> @endforeach </ul> </div> @endif <form method="post" action="{{ route('student.update',$student->id) }}" > @method('PATCH') @csrf <div class="form-group"> <label for="txtFirstName">First Name:</label> <input type="text" class="form-control" id="txtFirstName" placeholder="Enter First Name" name="txtFirstName" value="{{ $student->first_name }}"> </div> <div class="form-group"> <label for="txtLastName">Last Name:</label> <input type="text" class="form-control" id="txtLastName" placeholder="Enter Last Name" name="txtLastName" value="{{ $student->last_name }}"> </div> <div class="form-group"> <label for="txtAddress">Address:</label> <textarea class="form-control" id="txtAddress" name="txtAddress" rows="10" placeholder="Enter Address">{{ $student->address }}</textarea> </div> <button type="submit" class="btn btn-default">Submit</button> </form> @endsection |
We can start the server and run this example using the below command.
1 | php artisan serve |
Now we will run our example using the below Url in the browser.
1 | http://127.0.0.1:8000/student |