Saturday 27 June 2015

PHP: Script to import json to mysql in php

<?php 
$content = json_decode(file_get_contents("filename.json")), true);
mysql_connect('localhost', 'user', 'pass');
mysql_select_db('db'); 
foreach($content as $item) {
$columns = implode(", ",array_keys($item));
$escaped_values = array_map('mysql_real_escape_string', array_values($item));
$values = "'".implode("', '", $escaped_values)."'";
$sql = "INSERT INTO `tbl_name`($columns) VALUES ($values)";
mysql_query($sql);
}
 
?>

0 comments:

Post a Comment