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....

Intoduction to DotNetNuke

Intoduction to DotNetNuke                     DNN® ( formerly DotNetNuke® ) is the leading open source web content management platform (CMS) in the Microsoft ecosystem. The product is used to build professional looking and easy-to-use commercial websites, social intranets, community portals, or partner extranets. Containing dynamic content of all types, DNN sites are easy to deploy and update. The DNN Platform has been downloaded more than 8 million times and powers more than 750,000 websites globally. A community of more than 1 million members forms a powerful support network. Thousands of commercial extensions, apps and skins are available at the DNN Store that make extending a DNN site fast and affordable. Free open source extensions are also available from the DNN Extensions Forge . In addition to robust content management, the free, open source DN...