- 0
Sign in to follow this
Followers
0
Importing data from XML file to database using php
Asked by
seb86
-
Recently Browsing 0 members
No registered users viewing this page.
I am attempting to import an xml file that gets updated every few hours with new content.
I have most of it working well until i get to a little problem.
This is an example of the XML file I have been given by a client.
I am required to import the information into a database. This is what I have written and works.
<?php $file = "http://www.domain.com/example.xml"; // Fetch content from xml file. $content = get_content($file); // Break it into an array.... ! $content_x = explode("<annonce>", $content); reset($content_x); // Iterate through each item in the array. It's everything between <annonce> and </annonce>! foreach($content_x as $item){ /* Reference Number */ $p1 = strpos($item, '<reference>'); $p2 = strpos($item, '</reference>'); $l1 = $p2 - $p1; $reference = substr($item, $p1, $l1); // pulls out everything between <reference>and</reference> $reference = str_replace("<reference>", "", $reference); // removes the remaining tag... // and so on with each item between <annonce> and </annonce> // Find Username $p1 = strpos($item, '<username>'); $p2 = strpos($item, '</username>'); $m1 = $p2 - $p1; $userID = substr($item, $p1, $m1); $userID = str_replace("<username>", "", $userID); /* Address */ $p1 = strpos($item, '<address>'); $p2 = strpos($item, '</address>'); $m1 = $p2 - $p1; $address = substr($item, $p1, $m1); $address = str_replace("<address>", "", $address); // Village $p1 = strpos($item, '<village>'); $p2 = strpos($item, '</village>'); $m1 = $p2 - $p1; $village = substr($item, $p1, $m1); $village = str_replace("<village>", "", $village); // Area $p1 = strpos($item, '<area>'); $p2 = strpos($item, '</area>'); $m1 = $p2 - $p1; $department = substr($item, $p1, $m1); $department = str_replace("<area>", "", $department); // Postcode $p1 = strpos($item, '<postcode>'); $p2 = strpos($item, '</postcode>'); $m1 = $p2 - $p1; $postcode = substr($item, $p1, $m1); $postcode = str_replace("<postcode>", "", $postcode); $checkQuery = mysql_query("SELECT * FROM `property` WHERE `username`='{$username}' AND `reference_number`='{$reference}'"); /* Check to see if property already exists in the database under the user in control of the property. */ $countProps = mysql_num_rows($checkQuery); /* If property is new then data will be properly formatted and inserted into the database. */ if($countProps < 1){ $id = mysql_insert_id(); // Generate new id for property. $dateentered = date("Y-m-d H:i:s"); // Inserts date of entry. $address = ucwords(strtolower($address)); // Puts the string all lowercase then capitalizes the first letter of each word. $village = ucwords(strtolower($village)); // Puts the string all lowercase then capitalizes the first letter of each word. $department = ucwords(strtolower($department)); // Puts the string all lowercase then capitalizes the first letter of each word. /* Add Property from Feed. */ $addProperty = "INSERT INTO properties (`property_id`, `username`, `reference_number`, `date_entered`, `address`, `village`, `department`, `postcode`) VALUES ('$id', '$username', '$reference', '$dateentered', '$address', '$village', '$department', '$postcode');"; mysql_query($addProperty) or die("ERROR INSERTING PROPERTY DETAILS: ".mysql_error()); $photos = get_content($file); $content_photos = explode("<liste_photos>", $photos); reset($content_photos); // Reset list of photos /* Fetch each photo. */ foreach($content_photos as $key => $item){ $p1 = strpos($item, '<photo>'); $p2 = strpos($item, '</photo>'); $m1 = $p2 - $p1; $photoFile = substr($item, $p1, $m1); $photoFile = str_replace("<photo>", "", $photoFile); // Fetch photo file size. $ch = curl_init($photoFile); curl_setopt($ch, CURLOPT_NOBODY, true); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HEADER, true); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true); $data = curl_exec($ch); curl_close($ch); if(preg_match('/Content-Length: (\d+)/', $data, $matches)){ $contentLength = (int)$matches[1]; } $photoSize = $contentLength; // Collects the filesize of the image. // Fetch photo width and height. $photoDetails = @getimagesize($photoFile); // Gets details about the photo. $width = $photoDetails[0]; $height = $photoDetails[1]; // Clean the photo file name. $photoFile = str_replace('http://photos.domain.com/', '', $photoFile); $photoFile = str_replace($userID.'/', '', $photoFile); // Removes the username directory. $photoFile = stripslashes($photoFile); /* Removes any back slashes in the file name */ $photoFile = preg_replace('[^a-zA-Z0-9.]', '', $photoFile); /* Allows characters and numbers only. */ $photoFile = strtolower($photoFile); /* Puts the file name all in lowercase. */ // Add a new photo id number. $photoID = mysql_insert_id(); /* Add Photos of the Property. */ if($key > '1'){ $addphoto = "INSERT INTO photos (`property_id`, `photo_id`, `username`, `filename`, `filesize`, `width`, `height`, `position`) VALUES ('$id', '$photoID', '$username', '$photoFile', '$photoSize', '$width', '$height', '$key')"; $sqlphoto = mysql_query($addphoto) or die("ERROR INSERTING PROPERTY PHOTO: ".mysql_error()); } } } } // Close the foreach loop mysql_close(); // and close the database connection. ?>The problem is when it comes to inserting each photo, it only does the first one and not the other 9.
I need the other 9 to insert as well. How do i achieve this?
The xml file export can not be changed according to the client.
Can any one help me with this problem.
Any help would be most appreciated thank you.
Share this post
Link to post
Share on other sites