Miscellany

<?php include("dbconnect.php");$file = "prnews/sample.xml"; // Location of the file where the company uploads using ftp...////////////////////////////////////////////////////////////////////////////// A global variable used so that not all elements would be printed since you've asked for only: // Head Line, Distributor, Location, Date, Abstract, Texte$flag = 0;//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////   Initialized the following which will be used to as inputs for MySQL   //$hea = 1;$headline = '';$dis = 1;$distributor = '';$loc = 1;$location = '';$dat = 1;$date = '';$abs = 1;$abstract = '';$tex = 1;$text = '';///////////////////////////////////////////////////////////////////////////$xml_parser = xml_parser_create(); xml_set_element_handler($xml_parser, "startTag", "endTag"); xml_set_character_data_handler($xml_parser, "contents"); $fp = fopen($file, "r"); $data = fread($fp, 80000); if(!(xml_parse($xml_parser, $data, feof($fp)))){     die("Error on line " . xml_get_current_line_number($xml_parser)); } xml_parser_free($xml_parser); fclose($fp); ////////////////////////////////////////////////////////////////   Functions for parsing   //function contents($parser, $data){ 		if ( $GLOBALS['flag'] == 1 )	{		if ( $GLOBALS['hea'] == 1 )		{			echo $data;			$GLOBALS['headline'] .= $data; 		}		else if ( $GLOBALS['dis'] == 1 )		{			echo $data;			$GLOBALS['distributor'] .= $data; 		}		else if ( $GLOBALS['loc'] == 1 )		{			echo $data;			$GLOBALS['location'] .= $data; 		}		else if ( $GLOBALS['dat'] == 1 )		{			echo $data;			$GLOBALS['date'] .= $data; 		}			else if ( $GLOBALS['abs'] == 1 )		{			echo $data;			$GLOBALS['abstract'] .= $data; 		}		else if ( $GLOBALS['tex'] == 1 )		{			echo $data;			$GLOBALS['text'] .= $data; 		}									}}function startTag($parser, $data){     switch($data)	{		case 'HEDLINE':			echo "HEAD LINE: <br />";			$GLOBALS['flag'] = 1;			$GLOBALS['hea'] = 1;		break;		case 'DISTRIBUTOR':			echo "<br /><br />DISTRIBUTOR: <br />";			$GLOBALS['flag'] = 1;			$GLOBALS['dis'] = 1;					break;				case 'LOCATION':			echo "<br /><br />LOCATION: <br />";			$GLOBALS['flag'] = 1;			$GLOBALS['loc'] = 1;					break;			case 'STORY.DATE':			echo "<br /><br />DATE: <br />";			$GLOBALS['flag'] = 1;			$GLOBALS['dat'] = 1;		break;		case 'ABSTRACT':			echo "<br /><br />ABSTRACT: <br />";					$GLOBALS['flag'] = 1;			$GLOBALS['abs'] = 1;					break;		case 'BLOCK':			echo "<br /><br />BLOCK: <br />";					$GLOBALS['flag'] = 1;			$GLOBALS['tex'] = 1;					break;		case 'BLOCK':			echo "<br /><br />BLOCK: <br />";					$GLOBALS['flag'] = 1;			$GLOBALS['tex'] = 1;					break;			} } function endTag($parser, $data){ 	$GLOBALS['flag'] = 0;	    switch($data)	{		case 'HEDLINE':			$GLOBALS['hea'] = 0;		break;		case 'DISTRIBUTOR':			$GLOBALS['dis'] = 0;					break;				case 'LOCATION':			$GLOBALS['loc'] = 0;					break;			case 'STORY.DATE':			$GLOBALS['dat'] = 0;		break;		case 'ABSTRACT':			$GLOBALS['abs'] = 0;					break;		case 'BLOCK':			$GLOBALS['tex'] = 0;					break;	} } mysql_query("INSERT INTO parse  ( inc, headline, distributor, location, dat, abstract, texte )			 			 VALUES ( '', '".$GLOBALS['headline']."', '".$GLOBALS['distributor']."', '".$GLOBALS['location']."', '".$GLOBALS['date']."', '".$GLOBALS['abstract']."', '".$GLOBALS['text']."' ) ") or die(mysql_error());//////////////////////////////////////////////////////////////?>