Colton.Wagner Posted October 8, 2009 Share Posted October 8, 2009 Here is my problem i am trying to update the quanity of an item every 5 minutes by checking the part number then adding it here is what i have so far. <?php session_start(); $_SESSION['parts'] = array(); error_reporting(E_ALL); ?> <html> <head> <link rel="shortcut icon" href="/favicon.ico" /> <title> TItle =p </title> </head> <body> <?php mysql_connect('', '', ''); mysql_select_db('products'); $parser = xml_parser_create(); $quantity = ($_SESSION['parts']['QTY']); $part = ($_SESSION['parts']['PART']); function start($parser, $element_name, $element_attrs) { switch($element_name) { case "SKU": // this is the start of a set of data $_SESSION['parts'] = array(); // create an empty set break; case "TIME": $query = sprintf("UPDATE products SET products_quantity = $quantity WHERE products_model = $part"); mysql_query($query); break; default: } } function stop($parser, $element_name) { } function char($parser,$data) { $data = trim($data); if($data != ''){ if(!isset($_SESSION['parts']['SKU'])){ $_SESSION['parts']['SKU'] = $data; } elseif (!isset($_SESSION['parts']['QTY'])){ $_SESSION['parts']['QTY'] = $data; } elseif (!isset($_SESSION['parts']['PART'])){ $_SESSION['parts']['PART'] = $data; } } } xml_set_element_handler($parser, "start", "stop"); xml_set_character_data_handler($parser, "char"); $fp=fopen("http://morris.morriscostumes.com/out/available_batchnynyy_001.xml","r"); while ($data=fread($fp,4096)) { xml_parse($parser,$data,feof($fp)) or die (sprintf("XML Error: %s at line %d", xml_error_string(xml_get_error_code($parser)), xml_get_current_line_number($parser))); } xml_parser_free($parser); ?> </body> </html> Thanks in advanced for the help =p Link to comment https://forums.phpfreaks.com/topic/176913-solved-_session-array-update-into-a-server/ Share on other sites More sharing options...
Colton.Wagner Posted October 8, 2009 Author Share Posted October 8, 2009 bump Link to comment https://forums.phpfreaks.com/topic/176913-solved-_session-array-update-into-a-server/#findComment-932788 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.