CRUD Operation on JSON File using PHP

HE11

Audience Engagement Tactician

Rep

Vouches

Posts

Likes

Bits

2 MONTHS

2 2 MONTHS OF SERVICE

LEVEL 2 1000 XP

OP
Feb 27, 2025
0

2

Getting Started

In the previous tutorial, How to create JSON File from MySQL Database using PHP, we have discussed on how to create a JSON file from MySQL Database.

This time, we are going to create a CRUD on JSON file and we're going to use the json file generated in the previous tutorial as our sample json file.

Displaying our Data

First, we display the data in our json file in the form of a table and we are going to add the three actions: add, edit and delete.

Create a new file, name it as index.php and paste the codes below.

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>CRUD Operation on JSON File using PHP</title>
</head>
<body>
<a href="add.php">Add</a>
<table border="1">
<thead>
<th>ID</th>
<th>Firstname</th>
<th>Lastname</th>
<th>Address</th>
<th>Gender</th>
<th>Action</th>
</thead>
<tbody>
<?php
//fetch data from json
$data

=

file_get_contents

(

'members.json'

)

;
//decode into php array
$data

=

json_decode

(

$data

)

;
$index

=

0

;
foreach

(

$data

as

$row

)

{
echo

"
<tr>
<td>"

.

$row

->

id

.

"</td>
<td>"

.

$row

->

firstname

.

"</td>
<td>"

.

$row

->

lastname

.

"</td>
<td>"

.

$row

->

address

.

"</td>
<td>"

.

$row

->

gender

.

"</td>
<td>
<a href='edit.php?index="

.

$index

.

"'>Edit</a>
<a href='delete.php?index="

.

$index

.

"'>Delete</a>
</td>
</tr>
"

;
$index

++;
}
?>
</tbody>
</table>
</body>
</html>

Creating our Add Form and Script

Next, we are going to create our add form with the add script whenever the form is submitted. Create a new file, name it as add.php and paste the codes below.

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>CRUD Operation on JSON File using PHP</title>
</head>
<body>
<form method="POST">
<a href="index.php">Back</a>
<p>
<label for="id">ID</label>
<input type="text" id="id" name="id">
</p>
<p>
<label for="firstname">Firstname</label>
<input type="text" id="firstname" name="firstname">
</p>
<p>
<label for="lastname">Lastname</label>
<input type="text" id="lastname" name="lastname">
</p>
<p>
<label for="address">Address</label>
<input type="text" id="address" name="address">
</p>
<p>
<label for="gender">Gender</label>
<input type="text" id="gender" name="gender">
</p>
<input type="submit" name="save" value="Save">
</form>
<?php
if

(

isset

(

$_POST

[

'save'

]

)

)

{
//open the json file
$data

=

file_get_contents

(

'members.json'

)

;
$data

=

json_decode

(

$data

)

;
//data in out POST
$input

=

array

(
'id'

=>

$_POST

[

'id'

]

,
'firstname'

=>

$_POST

[

'firstname'

]

,
'lastname'

=>

$_POST

[

'lastname'

]

,
'address'

=>

$_POST

[

'address'

]

,
'gender'

=>

$_POST

[

'gender'

]
)

;
//append the input to our array
$data

[

]

=

$input

;
//encode back to json
$data

=

json_encode

(

$data

,

JSON_PRETTY_PRINT)

;
file_put_contents

(

'members.json'

,

$data

)

;
header

(

'location: index.php'

)

;
}
?>
</body>
</html>

Creating our Edit Form and Script

Next, we create our edit form containing the data of selected row/item in our data with the script to update our json if the form is submitted.

Create a new file, name it as edit.php and paste the codes below.

<?php
//get the index from URL
$index

=

$_GET

[

'index'

]

;
//get json data
$data

=

file_get_contents

(

'members.json'

)

;
$data_array

=

json_decode

(

$data

)

;
//assign the data to selected index
$row

=

$data_array

[

$index

]

;
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>CRUD Operation on JSON File using PHP</title>
</head>
<body>
<form method="POST">
<a href="index.php">Back</a>
<p>
<label for="id">ID</label>
<input type="text" id="id" name="id" value="<?php

echo

$row

->

id

;

?>

">
</p>
<p>
<label for="firstname">Firstname</label>
<input type="text" id="firstname" name="firstname" value="<?php

echo

$row

->

firstname

;

?>

">
</p>
<p>
<label for="lastname">Lastname</label>
<input type="text" id="lastname" name="lastname" value="<?php

echo

$row

->

lastname

;

?>

">
</p>
<p>
<label for="address">Address</label>
<input type="text" id="address" name="address" value="<?php

echo

$row

->

address

;

?>

">
</p>
<p>
<label for="gender">Gender</label>
<input type="text" id="gender" name="gender" value="<?php

echo

$row

->

gender

;

?>

">
</p>
<input type="submit" name="save" value="Save">
</form>
<?php
if

(

isset

(

$_POST

[

'save'

]

)

)

{
//set the updated values
$input

=

array

(
'id'

=>

$_POST

[

'id'

]

,
'firstname'

=>

$_POST

[

'firstname'

]

,
'lastname'

=>

$_POST

[

'lastname'

]

,
'address'

=>

$_POST

[

'address'

]

,
'gender'

=>

$_POST

[

'gender'

]
)

;
//update the selected index
$data_array

[

$index

]

=

$input

;
//encode back to json
$data

=

json_encode

(

$data_array

,

JSON_PRETTY_PRINT)

;
file_put_contents

(

'members.json'

,

$data

)

;
header

(

'location: index.php'

)

;
}
?>
</body>
</html>

Creating our Delete Script

Lastly, we create the script that deletes the row/item in our json file. Create a new file, name it as delete.php and paste the codes below.

<?php
//get the index
$index

=

$_GET

[

'index'

]

;
//fetch data from json
$data

=

file_get_contents

(

'members.json'

)

;
$data

=

json_decode

(

$data

)

;
//delete the row with the index
unset

(

$data

[

$index

]

)

;
//encode back to json
$data

=

json_encode

(

$data

,

JSON_PRETTY_PRINT)

;
file_put_contents

(

'members.json'

,

$data

)

;
header

(

'location: index.php'

)

;
?>

That ends this tutorial. Happy Coding :)

Download

You must upgrade your account or reply in the thread to view the hidden content.

CRUD Operation on JSON File using PHP

More options

HE11

452,513

356,598

356,625