Skip to main content

Laravel CRUD With MongoDB

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 8 MongoDB CRUD tutorial example. it was released on Sept 03, 2019.

Now, we follow the below step for creating the laravel 8 MongoDB CRUD operation(Laravel 8 CRUD example).

Overview

Step 1: Install Laravel 8

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 8

We are going to install laravel 8, so first open the command prompt or terminal and go to xampp htdocs folder directory using the command prompt. after then run the below command.

1

composer create-project --prefer-dist laravel/laravel laravel8_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

2

3

use App\Http\Controllers\StudentController;

 

Route::resource('student',StudentController::class);

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

19

<?php

 

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

 

 

 

class Student extends Model

{

    use HasFactory;

    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\Models\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 8 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 8 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



Comments

  1. It was such a pleasure for me to read an article like this you have write very good article that is very easy to understand.

    ReplyDelete

Post a Comment

Popular posts from this blog

Php Interview Questions

1. What Is PHP ? 2. How can I disable the output of error messages inside the HTML page? 3. Can I return other file formats (like Word, Excel, etc) using PHP? 4. Is there any way to force PHP to do garbage collection before the end of the request? 5. Why does require($file_name) in a loop just include the first file repeatedly? 6. Can you include and call C libraries in PHP scripts? How? 7. What's the best way to start writing a PHP program? 8. Passing variables with REQUIRE function (part II) 9. I use a /cgi-bin/ad.pl for displaying rotating banners at the top of my html files. How can I insert the output of this cgi in an "included" file ? 10. please tell me how to let a html document read content from a .txt file, spit this out in a table, and how to update the specific file with a form 11. How can I add authentication to my site with PHP? I have authentication working only with one page. 12. Where can I get documentation for the Zend API? 13....

5 Significant Reasons For Having A Good Website For Your Business

In this era, where everything is now available online, and people are becoming more and more Internet dependant, any company needs to have a well-built website. People tend to check any company online before getting any service from them. A well-built website will help to make you a good impression on your consumers, and they will gain reliability on you. A well-maintained site is the essence of a good company, and without a website, you will fail to make that vital first impression on your customers. It would be best if you also used   website promotion   to promote your website. The certain benefits of having a website are mentioned below. Accessible: A website makes your business available to people 24*7. People can search your website anytime they want and visiting your website will provide them with relevant information that they are looking for. If you hire a  responsive   web design company ,  then you can be sure of your website to make an excell...