CREATE a Db in Mysql with this statement
CREATE TABLE tablename (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
boundary VARCHAR(9000) NOT NULL,
zipcode VARCHAR(6) NOT NULL)
Then Connect this script to your DataBase!
<html>
<body>
<?php
$db_host = ''; // hostname
$db_name = ''; // databasename
$db_user = ''; // username
$user_pw = ''; // password
//THIS CAN CONVERT CENSUS DATA
$con = new PDO('mysql:host='.$db_host.'; dbname='.$db_name, $db_user, $user_pw);
$con->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
$completeurl = "map.xml";
$xml = simplexml_load_file($completeurl);
$placemarks = $xml->Document->Folder->Placemark;
for ($i = 0; $i < count($placemarks); $i++) { $coordinates = $placemarks[$i]->ExtendedData->SchemaData->SimpleData[2][0];
$cor_d = $placemarks[$i]->Polygon->outerBoundaryIs->LinearRing->coordinates;
$cor_d = json_encode($cor_d);
$sql = "INSERT INTO tablename (zipcode, boundary) VALUES (?,?)";
$q = $con->prepare($sql);
$q->execute(array($coordinates ,$cor_d));
echo $i;
}
?>
</body>
</html>