Database Administration:Parsing Multiple XML Files and Loading them onto MySQL Database using PHP

<?php
function dblink(){
mysql_connect(“localhost”, “root”, “admin”);
mysql_select_db(“xml_db”);
}

mysql_query(“insert into test_addresss values(‘$getid’, ‘$row1’, ‘$row2’, ‘$row3, ‘$row4’)”)or die(mysql_error());;

if($handle = opendir(‘./pages/downloads/’)){
while(false!==($entry = readdir($handle))){
if($entry!=”.” && $entry!=”..”){
$filename = $entry;

$xml = simplexml_load_file($filename);

$getid = $xml->InputData[0]->National_ID;

$data = $xml->Addresses->Address;
for($i=0;$i<count($data);$i++){
$row1 = $data[$i]->StreetNameNumber;
$row2 = $data[$i]->CityArea;
$row3 = $data[$i]->City;
$row4 = $data[$i]->ZipCode;
$row5 = $data[$i]->ReportDate;
dblink();
mysql_query(“insert into Addresses values(‘$getid’, ‘$row1’, ‘$row2’, ‘$row3, ‘$row4’, ‘$row5’)”)or die(mysql_error());;
}

$data = $xml->Telephones->Telephone;
for($i=0;$i<count($data);$i++){
$row1 = $data[$i]->PhonePrefix;
$row2 = $data[$i]->PhoneNumber;
$row3 = $data[$i]->PhoneType;
$row4 = $data[$i]->FirstReportedDate;
dblink();
mysql_query(“insert into Telephone values(‘$getid’, ‘$row1$row2’, ‘$row3, ‘$row4’)”)or die(mysql_error());;
}

$data = $xml->Employers->Employer;
for($i=0;$i<count($data);$i++){
$row1 = $data[$i]->Name;
$row2 = $data[$i]->Occupation;
dblink();
mysql_query(“insert into Employer values(‘$getid’, ‘$row1’, ‘$row2’)”)or die(mysql_error());;
}

}
}
closedir($handle);
}

?>