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:

1

sudo apt-get install php-mongodb

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

1

sudo apt-get install php5.6-mongo

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

1

sudo service apache2 restart

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:

1

mongo

Show all databases

1

show dbs

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.

1

2

>usetest

switched todb test

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.

1

db.users.createIndex({"email":1},{unique:true})

Create collection named users

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

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.

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

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

<html>

<head>

<title>AddData</title>

</head>

<body>

<?php

//including the database connection file

include_once("config.php");

if(isset($_POST['Submit'])){

$user=array(

'name'=>$_POST['name'],

'age'=>$_POST['age'],

'email'=>$_POST['email']

);

// checking empty fields

$errorMessage='';

foreach($useras$key=>$value){

if(empty($value)){

$errorMessage.=$key.' field is empty<br />';

}

}

if($errorMessage){

// print error message & link to the previous page

echo'<span style="color:red">'.$errorMessage.'</span>';

echo"<br/><a href='javascript:self.history.back();'>Go Back</a>";

}else{

//insert data to database table/collection named 'users'

$db->users->insert($user);

//display success message

echo"<font color='green'>Data added successfully.";

echo"<br/><a href='index.php'>View Result</a>";

}

}

?>

</body>

</html>

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:

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

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

<?php

// including the database connection file

include_once("config.php");

if(isset($_POST['update']))

{

$id=$_POST['id'];

$user=array(

'name'=>$_POST['name'],

'age'=>$_POST['age'],

'email'=>$_POST['email']

);

// checking empty fields

$errorMessage='';

foreach($useras$key=>$value){

if(empty($value)){

$errorMessage.=$key.' field is empty<br />';

}

}

if($errorMessage){

// print error message & link to the previous page

echo'<span style="color:red">'.$errorMessage.'</span>';

echo"<br/><a href='javascript:self.history.back();'>Go Back</a>";

}else{

//updating the 'users' table/collection

$db->users->update(

array('_id'=>newMongoId($id)),

array('$set'=>$user)

);

//redirectig to the display page. In our case, it is index.php

header("Location: index.php");

}

}// end if $_POST

?>

<?php

//getting id from url

$id=$_GET['id'];

//selecting data associated with this particular id

$result=$db->users->findOne(array('_id'=>newMongoId($id)));

$name=$result['name'];

$age=$result['age'];

$email=$result['email'];

?>

<html>

<head>

<title>Edit Data</title>

</head>

<body>

<ahref="index.php">Home</a>

<br/><br/>

<form name="form1"method="post"action="edit.php">

<table border="0">

<tr>

<td>Name</td>

<td><input type="text"name="name"value="<?phpecho$name;?>"></td>

</tr>

<tr>

<td>Age</td>

<td><input type="text"name="age"value="<?phpecho$age;?>"></td>

</tr>

<tr>

<td>Email</td>

<td><input type="text"name="email"value="<?phpecho$email;?>"></td>

</tr>

<tr>

<td><input type="hidden"name="id"value=<?phpecho$_GET['id'];?>></td>

<td><input type="submit"name="update"value="Update"></td>

</tr>

</table>

</form>

</body>

</html>

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

About

Mukesh Chapagain is a graduate of Kathmandu University (Dhulikhel, Nepal) from where he holds a Masters degree in Computer Engineering. Mukesh is a passionate web developer who has keen interest in open source technologies, programming & blogging. more...