Import/insert JSON file data into MySQL database using PHP; Through this tutorial, i am going to show you how to import/insert JSON file data into MySQL database using PHP.
How to Insert/Import JSON Data into MySQL using PHP
Follow the below given steps to import or insert JSON file data into MySQL database using PHP; as follows:
- Step 1 – Create Database Configuration
- Step 2 – Read Json Data From File
- Step 3 – Insert JSON data Into MySQL Database
Step 1 – Create Database Configuration
Use the below given php code to create 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 below given 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 below given 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 complete source code of Import json File Data Into MySQL Database in PHP; is as follows:
<!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>