<?php
$js = '{data":{"lbnref":"34558","message":"IRP Create Only (Disabled)","IRP":"Standard Linkbynet/LINKBYNET/EVT Reboot Detected","alert_id":"22521-trigger-617164","monitor_tool":"ipmonitor","flowName":"0 - Lancement depuis alerte Sentinel","central":"orchestration.lbn.fr","result":"No Action Taken","tag":"Association IRP non trouvee"}}';
$tableName = 'profile';
foreach((array)$jsonData as $id => $row){ foreach ((array)$row as $key=>$val) { }
$sql = "INSERT INTO `{$tableName}` ({$insertKeys}) VALUES ({$insertVals});\n" ;
}
echo $sql;
ICAgIDw/cGhwCiAgICAkanMgPSAne2RhdGEiOnsibGJucmVmIjoiMzQ1NTgiLCJtZXNzYWdlIjoiSVJQIENyZWF0ZSBPbmx5IChEaXNhYmxlZCkiLCJJUlAiOiJTdGFuZGFyZCBMaW5rYnluZXQvTElOS0JZTkVUL0VWVCBSZWJvb3QgRGV0ZWN0ZWQiLCJhbGVydF9pZCI6IjIyNTIxLXRyaWdnZXItNjE3MTY0IiwibW9uaXRvcl90b29sIjoiaXBtb25pdG9yIiwiZmxvd05hbWUiOiIwIC0gTGFuY2VtZW50IGRlcHVpcyBhbGVydGUgU2VudGluZWwiLCJjZW50cmFsIjoib3JjaGVzdHJhdGlvbi5sYm4uZnIiLCJyZXN1bHQiOiJObyBBY3Rpb24gVGFrZW4iLCJ0YWciOiJBc3NvY2lhdGlvbiBJUlAgbm9uIHRyb3V2ZWUifX0nOwogICAgIAogICAgCSRqc29uRGF0YSA9IGpzb25fZGVjb2RlKCRqcywgdHJ1ZSk7CiAgICAJJGpzb25EYXRhID0ganNvbl9kZWNvZGUoJGpzb25EYXRhWydkYXRhJ10sIHRydWUpOwogICAgIAogICAgCSR0YWJsZU5hbWUgPSAncHJvZmlsZSc7CiAgICAJZm9yZWFjaCgoYXJyYXkpJGpzb25EYXRhIGFzICRpZCA9PiAkcm93KXsKICAgIAkJJGluc2VydFBhaXJzID0gYXJyYXkoKTsKICAgIAkJZm9yZWFjaCAoKGFycmF5KSRyb3cgYXMgJGtleT0+JHZhbCkgewogICAgCQkgICRpbnNlcnRQYWlyc1thZGRzbGFzaGVzKCRrZXkpXSA9IGFkZHNsYXNoZXMoJHZhbCk7CiAgICAJCX0KICAgIAkJJGluc2VydEtleXMgPSAnYCcgLiBpbXBsb2RlKCdgLGAnLCBhcnJheV9rZXlzKCRpbnNlcnRQYWlycykpIC4gJ2AnOwogICAgCQkkaW5zZXJ0VmFscyA9ICciJyAuIGltcGxvZGUoJyIsIicsIGFycmF5X3ZhbHVlcygkaW5zZXJ0UGFpcnMpKSAuICciJzsKICAgIAkJJHNxbCA9ICJJTlNFUlQgSU5UTyBgeyR0YWJsZU5hbWV9YCAoeyRpbnNlcnRLZXlzfSkgVkFMVUVTICh7JGluc2VydFZhbHN9KTtcbiIgOwogICAgCX0KICAgICAKICAgIAllY2hvICRzcWw7