<?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/cGhwCiAgICAkanMgPSAne2RhdGEiOlt7ImxibnJlZiI6IjM0NTU4IiwibWVzc2FnZSI6IklSUCBDcmVhdGUgT25seSAoRGlzYWJsZWQpIiwiSVJQIjoiU3RhbmRhcmQgTGlua2J5bmV0L0xJTktCWU5FVC9FVlQgUmVib290IERldGVjdGVkIiwiYWxlcnRfaWQiOiIyMjUyMS10cmlnZ2VyLTYxNzE2NCIsIm1vbml0b3JfdG9vbCI6ImlwbW9uaXRvciIsImZsb3dOYW1lIjoiMCAtIExhbmNlbWVudCBkZXB1aXMgYWxlcnRlIFNlbnRpbmVsIiwiY2VudHJhbCI6Im9yY2hlc3RyYXRpb24ubGJuLmZyIiwicmVzdWx0IjoiTm8gQWN0aW9uIFRha2VuIiwidGFnIjoiQXNzb2NpYXRpb24gSVJQIG5vbiB0cm91dmVlIn1dfSc7CiAgICAgCiAgICAJJGpzb25EYXRhID0ganNvbl9kZWNvZGUoJGpzLCB0cnVlKTsKICAgIAkkanNvbkRhdGEgPSBqc29uX2RlY29kZSgkanNvbkRhdGFbJ2RhdGEnXSwgdHJ1ZSk7CiAgICAgCiAgICAJJHRhYmxlTmFtZSA9ICdwcm9maWxlJzsKICAgIAlmb3JlYWNoKChhcnJheSkkanNvbkRhdGEgYXMgJGlkID0+ICRyb3cpewogICAgCQkkaW5zZXJ0UGFpcnMgPSBhcnJheSgpOwogICAgCQlmb3JlYWNoICgoYXJyYXkpJHJvdyBhcyAka2V5PT4kdmFsKSB7CiAgICAJCSAgJGluc2VydFBhaXJzW2FkZHNsYXNoZXMoJGtleSldID0gYWRkc2xhc2hlcygkdmFsKTsKICAgIAkJfQogICAgCQkkaW5zZXJ0S2V5cyA9ICdgJyAuIGltcGxvZGUoJ2AsYCcsIGFycmF5X2tleXMoJGluc2VydFBhaXJzKSkgLiAnYCc7CiAgICAJCSRpbnNlcnRWYWxzID0gJyInIC4gaW1wbG9kZSgnIiwiJywgYXJyYXlfdmFsdWVzKCRpbnNlcnRQYWlycykpIC4gJyInOwogICAgCQkkc3FsID0gIklOU0VSVCBJTlRPIGB7JHRhYmxlTmFtZX1gICh7JGluc2VydEtleXN9KSBWQUxVRVMgKHskaW5zZXJ0VmFsc30pO1xuIiA7CiAgICAJfQogICAgIAogICAgCWVjaG8gJHNxbDs=