Home » MongoDB, PHP5 September 2017

PHP & MongoDB: Very Simple Add, Edit, Delete, View (CRUD) [Beginner Tutorial]

In this article, I will be presenting simple PHP & MongoDB code to add, edit, delete and view data. This kind of system is also referred to CRUD (Create, Read, Update, Delete).

Here is a step-by-step guide on creating a CRUD system using PHP & MongoDB:

I suppose, you have already installed MongoDB. If not, you may refer to my previous article on Introduction to MongoDB.

Install php-mongodb extension

In Ubuntu Linux, you can install it with the following command:

If you are using PHP 5.6, then you can use the following command:

After installing the extension, you have to restart Apache. You can do it with the following command in Ubuntu:

We will now create a new MongoDB database. Let us name the database as test. We will also create a new table named users and add some data into that table.

In MongoDB,
Tables are called as “Collection”
Rows are called as “Documents”
Columns are called as “Fields”

Open terminal/command-prompt & Go to Mongo Shell with the following command:

Show all databases

Create new database named test

use command will create & switch to a new database if not present OR it will only switch to the database if already present.

Create unique index for email field

We make “email” field as unique so that duplicate entries for emails will generate error message. Each user is uniquely identified by “email”. The user ID in MongoDB is automatically generated as 12-byte ObjectId.

Create collection named users

Collection in MongoDB is equivalent to tables in MySQL or other RDBMS.

Query the collection

Now, we will create a config.php file which contains database connection code. This code connects to the MongoDB database. This file is included in all PHP pages where database connection is necessary.

config.php

To add data into database, we need an html form.

add.html

Form action on add.html is add.php. It means that the submitted form data will go to add.php. In add.php, we do a simple validation of checking if the entered name, email & age are empty or not. If they are all filled then the data will be inserted into database table/collection.

add.php

Data from database is fetched and displayed in index.php file. This is our homepage. This file also contains a link to add data. On every row of displayed data, there is also a link to edit and delete data. Below is a sample image of our homepage:

CRUD PHP MySQL

index.php

Each row/document of data can be edited separately. Row/Document ID is passed in the URL of edit.php. ID uniquely identifies the data entry.

While adding data, we had two files: add.html and add.php. While editing data, I have kept the entire thing in a single edit.php file. Edit form in HTML and database update code in PHP are present in the same file.

In the code below, at first a single row entry of data is fetched based on the id. The fetched data is displayed in the edit form. When user edits the data and submits the form, then some simple validation is done for empty data. When everything is correct, then that particular entry of data is updated in database.

edit.php

Each row/document of data can be deleted separately. Row/Document ID is passed in the URL of delete.php. ID uniquely identifies the data entry. After deletion, the user is redirected to homepage (index.php).

delete.php

Download Full Source Code: Simple Create, Read, Update, Delete in PHP & MongoDB

Hope this helps. Thanks.

PHP

Get New Post by Email

Find me on

FacebookTwitterGoogle+LinkedInRSS Feed