<?php
$js = '{"data":"[{\"candidate_id\":\"SM_009\",\"FirstName\":\"dffdf\",\"LastName\":\"dffdf\",\"DOB\":\"1990-01-02\"}]"}';
	//$js = '[{"candidate_id":"SM_009","FirstName":"test","LastName":"dummy","DOB":"1990-06-05"}]';
 
	$jsonData = json_decode($js, true);
	$jsonData = json_decode($jsonData['data'], true);
 
	$tableName = 'profile';
	foreach((array)$jsonData as $id => $row){
		$insertPairs = array();
		foreach ((array)$row as $key=>$val) {
		  $insertPairs[addslashes($key)] = addslashes($val);
		}
		$insertKeys = '`' . implode('`,`', array_keys($insertPairs)) . '`';
		$insertVals = '"' . implode('","', array_values($insertPairs)) . '"';
		$sql = "INSERT INTO `{$tableName}` ({$insertKeys}) VALUES ({$insertVals});\n" ;
	}
 
	echo $sql;

PD9waHAKJGpzID0gJ3siZGF0YSI6Ilt7XCJjYW5kaWRhdGVfaWRcIjpcIlNNXzAwOVwiLFwiRmlyc3ROYW1lXCI6XCJkZmZkZlwiLFwiTGFzdE5hbWVcIjpcImRmZmRmXCIsXCJET0JcIjpcIjE5OTAtMDEtMDJcIn1dIn0nOwoJLy8kanMgPSAnW3siY2FuZGlkYXRlX2lkIjoiU01fMDA5IiwiRmlyc3ROYW1lIjoidGVzdCIsIkxhc3ROYW1lIjoiZHVtbXkiLCJET0IiOiIxOTkwLTA2LTA1In1dJzsKCgkkanNvbkRhdGEgPSBqc29uX2RlY29kZSgkanMsIHRydWUpOwoJJGpzb25EYXRhID0ganNvbl9kZWNvZGUoJGpzb25EYXRhWydkYXRhJ10sIHRydWUpOwoJCgkkdGFibGVOYW1lID0gJ3Byb2ZpbGUnOwoJZm9yZWFjaCgoYXJyYXkpJGpzb25EYXRhIGFzICRpZCA9PiAkcm93KXsKCQkkaW5zZXJ0UGFpcnMgPSBhcnJheSgpOwoJCWZvcmVhY2ggKChhcnJheSkkcm93IGFzICRrZXk9PiR2YWwpIHsKCQkgICRpbnNlcnRQYWlyc1thZGRzbGFzaGVzKCRrZXkpXSA9IGFkZHNsYXNoZXMoJHZhbCk7CgkJfQoJCSRpbnNlcnRLZXlzID0gJ2AnIC4gaW1wbG9kZSgnYCxgJywgYXJyYXlfa2V5cygkaW5zZXJ0UGFpcnMpKSAuICdgJzsKCQkkaW5zZXJ0VmFscyA9ICciJyAuIGltcGxvZGUoJyIsIicsIGFycmF5X3ZhbHVlcygkaW5zZXJ0UGFpcnMpKSAuICciJzsKCQkkc3FsID0gIklOU0VSVCBJTlRPIGB7JHRhYmxlTmFtZX1gICh7JGluc2VydEtleXN9KSBWQUxVRVMgKHskaW5zZXJ0VmFsc30pO1xuIiA7Cgl9CgoJZWNobyAkc3FsOw==