Jump to content

[SOLVED] Updating a quantity by checking the product_model


Colton.Wagner

Recommended Posts

I have made an xml quantity uploading script here it doesnt seem to update the quantity can you tell me what im doing wrong?

 

<?php
session_start(); 
$_SESSION['parts'] = array();
error_reporting(E_ALL);
?>
<html>
   <head>
      <link rel="shortcut icon" href="/favicon.ico" />
      <title>
         TItle of the website
      </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("xml  filename","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>

 

The error is as follows:

 

Notice: Undefined index: QTY in  on line 22

Notice: Undefined index: PART in  on line 23

Notice: Undefined variable: quantity in  on line 34

Notice: Undefined variable: part in  on line 34

Notice: Undefined variable: quantity in on line 34

Notice: Undefined variable: part in on line 34

 

That goes on for days

Link to comment
Share on other sites

that means that you are using variables that you haven't defined yet. Either you misstyped the variable names, or you need to define them..

 

They are for sure not miss typed they have been defined but they are not being parsed in correctly because I don't know how to correctly process the syntax to do it.

Link to comment
Share on other sites

that means that you are using variables that you haven't defined yet. Either you misstyped the variable names, or you need to define them..

 

They are for sure not miss typed they have been defined but they are not being parsed in correctly because I don't know how to correctly process the syntax to do it.

 

The way i have that set up is it parse's the xml into the $_SESSION['parts']['wty'] then it sets that equal to the variable $quanitity then updates that into the database im not so sure that i am using the correct syntax for that.

Link to comment
Share on other sites

its very simple - you have $_SESSION['parts'] = array();

 

this sets that session variable to an empty array. Between that line and the first attempt to access the QTY element of a non existent array there is no code to populate the parts array.

 

Toon is right,

<?php
session_start(); 
$_SESSION['parts'] = array();
error_reporting(E_ALL);
?>
... html here....
<?php

mysql_connect('');
mysql_select_db('products');

$parser = xml_parser_create();

// The following are causing problems:
$quantity = ($_SESSION['parts']['QTY']);
$part = ($_SESSION['parts']['PART']);

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.