PHP [HELP] XML to SQL using PHP CODE

[rakhistha]

Guys, patulong naman po. I have this code kaso hindi ko alam kung saan ako nagkaka problema. hindi pumapasok sa SQL Database ko ung mga info from my XML.

Eto po ung code at XML.


<?php
$db = mysqli_connect("localhost", "root", "","workers") or die ("Error" . mysqli_error($db));
$xml=simplexml_load_file("employee_info.xml");
$success = true;
foreach($xml->children() as $value)
{
$SQL_QUERY = "INSERT INTO emp_info (emp_lname, emp_fname, emp_mname, emp_gender, emp_desgination) VALUES
('".$value->emp_lname."','".$value->emp_fname."', '".$value->emp_mname."', '".$value->emp_gender."',
'".mysqli_real_escape_string($db,$value->emp_desgination)."')";
if ($result = mysqli_query ($db, $SQL_QUERY)) {
}
else {
$success = false;
}
}
if ($success){
echo "SUCCESS IMPORT";
}
else {
echo "FAILED";
}
?>

 

[KarmaPanda]

ano po output?
success or fail?

 

[rakhistha]

Ok na po..nagfailed nung una..buti meron ung mysqli_error..pang debug..thanks kapatid..nadebug ko na..typo error sa sql query..imbes na $value->designation..desgination..