In PHP, file_get_contents(), json_decode(), and mysqli_multi_query() functions help developers to read data in json file to insert into MySQL database.
Through this tutorial, we will learn how to import or Insert JSON file data to MySQL database using PHP.
How to Insert JSON data into MySQL database using PHP?
Use the following steps to import/insert JSON file data into MySQL database:
Step 1 – Create Database Configuration
Use the following PHP code to create a connection from MySQL database; as follows:
// Server name => localhost
// Username => root
// Password => empty
// Database name => test
// Passing these 4 parameters
$connect = mysqli_connect("localhost", "root", "", "test");
Step 2 – Read JSON data From File
Use the following PHP code to read JSON data from file; as follows:
// json file name
$filename = "college_subjects.json";
// Read the JSON file in PHP
$data = file_get_contents($filename);
// Convert the JSON String into PHP Array
$array = json_decode($data, true);
Step 3 – Insert JSON data Into MySQL Database
Use the following PHP code to insert JSON file data into MySQL database; as follows:
// Database query to insert data
// into database Make Multiple
// Insert Query
$query .=
"INSERT INTO student VALUES
('".$row["name"]."', '".$row["gender"]."',
'".$row["subject"]."'); ";
The full source code of How to Insert JSON File data into MySQL database using PHP:
<!DOCTYPE html>
<html>
<head>
<script src=
"https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js">
</script>
<link rel="stylesheet" href=
"https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
<script src=
"https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js">
</script>
<style>
.box {
width: 750px;
padding: 20px;
background-color: #fff;
border: 1px solid #ccc;
border-radius: 5px;
margin-top: 100px;
}
</style>
</head>
<body>
<div class="container box">
<h3 align="center">
How to Insert JSON File data into MySQL database using PHP
</h3><br />
<?php
// Server name => localhost
// Username => root
// Password => empty
// Database name => test
// Passing these 4 parameters
$connect = mysqli_connect("localhost", "root", "", "test");
$query = '';
$table_data = '';
// json file name
$filename = "college_subjects.json";
// Read the JSON file in PHP
$data = file_get_contents($filename);
// Convert the JSON String into PHP Array
$array = json_decode($data, true);
// Extracting row by row
foreach($array as $row) {
// Database query to insert data
// into database Make Multiple
// Insert Query
$query .=
"INSERT INTO student VALUES
('".$row["name"]."', '".$row["gender"]."',
'".$row["subject"]."'); ";
$table_data .= '
<tr>
<td>'.$row["name"].'</td>
<td>'.$row["gender"].'</td>
<td>'.$row["subject"].'</td>
</tr>
'; // Data for display on Web page
}
if(mysqli_multi_query($connect, $query)) {
echo '<h3>Inserted JSON Data</h3><br />';
echo '
<table class="table table-bordered">
<tr>
<th width="45%">Name</th>
<th width="10%">Gender</th>
<th width="45%">Subject</th>
</tr>
';
echo $table_data;
echo '</table>';
}
?>
<br />
</div>
</body>
</html>
Conclusion
Through this tutorial, we have learned how to import/Insert JSON file data into MySQL database using PHP or fetch/get data from JSON file and import it into the Mysql database using PHP.
Recommended PHP Tutorials
Recommended:-jQuery Form Validation in PHP
Recommended:-PHP 8 Pagination with Bootstrap Example
Recommended:-User Registration with Email Verification in PHP
Recommended:-How to Add Captcha in PHP Registration Form
Recommended:-PHP Contact Form with jQuery Validation Example
Recommended:-PHP Cookie Set, Get And Delete Example
Recommended:-Insert Update Delete in PHP on Same Page
Recommended:-How to Fetch Data From Database in PHP using Ajax
Recommended:-File Upload in PHP MySQL database
Recommended:-PHP | Implode and Explode Function
Recommended:-Send Reset Password Link Email PHP
Recommended:-PHP Display All Errors Example
Recommended:-PHP Google Places Autocomplete Example
Recommended:-PHP Move and Copy File From One Folder to Another
Recommended:-PHP Dropzone File Upload Tutorial Example
Recommended:-PHP Signature Pad using Jquery Ajax Example
Recommended:-PHP 8 MySQL Ajax Live Search Autocomplete Example
Recommended:-PHP Google Firebase CRUD Example Tutorial
Recommended:-Replace First and Last Character From String PHP
Recommended:-How to Install PHP 8 on Ubuntu 20.04 using Terminal
Recommended:-PHP Sending Email (text/html)|PHP Mail() Function
Recommended:-Import CSV File into MySQL using PHP
Recommended:-Upload File to AWS S3 Bucket In PHP
Recommended:-Login with Facebook using PHP
Recommended:-PHP MySQL jQuery Ajax Pagination
Recommended:-PHP and MySQL DataTables Server-side Processing
Recommended:-Datatables CRUD with Ajax, PHP & MySQL
Recommended:-PHP Environment Variables Windows 10 Xampp
Recommended:-PHP Add Days, Month, Year to Date
