Hi everyone,
Wonder if anyone has an idea about this error msg
Fatal error: Maximum execution time of 30 seconds exceeded
I am trying to store large XML document to mysql. I think i missed around with Fopen setting which is the main cause of this problem. Can you look at the code and advise or suggest any soultions please. Your help will be extermly appreciated.
Source Code:
// initialize parser
$xml_parser = xml_parser_create();
// turn off whitespace processing
xml_parser_set_option($xml_parser,XML_OPTION_SKIP_WHITE, TRUE);
// turn on case folding
xml_parser_set_option($xml_parser, XML_OPTION_CASE_FOLDING, FALSE);
// set callback functions
xml_set_element_handler($xml_parser, "startElementHandler", "endElementHandler");
xml_set_character_data_handler($xml_parser, "characterDataHandler");
// open connection to database
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!");
// read XML file
if (!($fp = fopen($xml_file, "r")))
{
die("File I/O error: $xml_file");
}
// parse XML
while ($data = fread($fp, 1024*2000))
{
// error handler
if (!xml_parse($xml_parser, $data, feof($fp)))
{
$error_code = xml_get_error_code($xml_parser);
die("XML parser error (error code " . $error_code . "): " . xml_error_string($error_code) . "<br>Error occurred
at line " . xml_get_current_line_number($xml_parser));
}
}
// all done, clean up!
//xml_parser_free($xml_parser);
//mysql_close($connection);
Fellas looking forward to hear from you.
Mo