Populating MySQL From XML

[justlukeyou]

Hi,

I have piece of code which intentionally copies an XML on my server to another folder on the server and is then designed to populate MySQL database however I am just getting the white screen of death. For the life of me I cant see why it will not populate the database, does anyone have any thoughts or suggestions please?

$xmlReader = new XMLReader();

$filename = "datafeed_98057.xml";
$url = "domain/datafeed.xml";

file_put_contents($filename, file_get_contents($url));

$xmlReader->open($filename);

while ($xmlReader->read())

{

switch ($xmlReader->name)

{

case'product':

$dom = new DOMDocument();
$domNode = $xmlReader->expand();
$element = $dom->appendChild($domNode);
$domString = utf8_encode($dom->saveXML($element));
$product = new SimpleXMLElement($domString);

$awImage = $product->awImage;

//insert query
if(strlen($awImage) > 0)
{
$query = mysql_query("REPLACE INTO productfeed
(awImage)
VALUES ('$awImage')");
echo $awImage . "has been inserted </br>";
}
break;
}
}
?>

[sneakyimp]

If you get white screen of death, you might want to make sure your syntax is valid by putting a

die('yes it works');

statement first. If you see that as output, it means you don't have a syntax error.

Once you are sure it's not a syntax error, you should probably put in something like this to make sure the script will barf up any errors you might encounter:

error_reporting(E_ALL);
if (!ini_get('display_errors')) {
    ini_set('display_errors', 1);
}

If you are still getting a white screen of death, you might consider looking in the php error log.

My guess is that there's either a syntax error OR you don't have the XML extension enabled.

[justlukeyou]

Thanks, dow do I access the error log. I found a page which sais I should just add "error_log" to the php.ini file and this one which is quite complicated.

http://php.net/manual/en/function.error-log.php

I added the following to my php.ini file but blocked all data transfer from database.

supress php errors

php_flag display_startup_errors off
php_flag display_errors off
php_flag html_errors off

[sneakyimp]

on your devmachine, you don't want to suppress errors, you want to display them.

# don't supress php errors on a dev machine, you want to see them so you can see what's breaking
php_flag display_startup_errors on
php_flag display_errors on
php_flag html_errors on

on a live site, you should probably turn them off to prevent hackers from getting extra info when they are trying to hack your site.

If you have access to your php.ini file, you should look for the error_log directive. This would specify where your PHP error log is located.

Note that the error log may or may not be accessible to you if you are connecting to your server via FTP.