Help using Array data

mlmcculloch

I am trying to create a php page that shows status of inventory by using conditions within the CSS class.

I have a mysql database that will provide invID, lotnumber & status

Status data will be sold, uc or avail

when the page loads, I want to query the inventory table and put the result into an array.

Within the UI, I have a layer div tag where I want each object to decide, based on array data, which css class should be parsed (sold or avail)

My trouble is how to reach into the array, extract a specific row, check it's status and then use that status in the if, elseif statement.

I have made a prototype work with a specific lotnumber query, but I obviously don't want to code 100 different queries to account for each inventory item.

So, I want to load an array that contains invID, lotnumber & status, then use the array to extract status for a particular lotnumber, then use the status in the above condition.

I would need to replicate the extraction at each layer (inventory display) on the page.

Thanks

leatherback

Hi,

turn the problem around:

// define an array with potential classes
$classes = array(
"uc" => "sold",
"avail" => "avail");

Get the data:

$result = mysql_query($YourQueryHere);
if($result)
  {
  while($result = mysql_fetch_assoc($result))
    {
    echo "<span class=\"".$classes[$row['status']]."\">".$row['lotnumber']."</span>";
    }
  }

mlmcculloch

Maybe I don't understand the suggestion, but how would this allow me to query the database once, then use the resulting array multiple times for each display layer.

It looks like the code requires a separate query for each layer.

Plus, I only need to use status to make the decision on which ccs tag to send to the browser.

leatherback

Hi Mlm,

Maybe I understand you wrong.. WHY do you put it in an array? I thought you meant you wanted to output you data with formatting based on the status?

I am not sure what you mean with a layer, to be honest..

What this code allows you to do:

query the database
Use the array as a stored list of postential styles for each output
Display each record in the selected set, using the style-names stored in the array.

mlmcculloch

Here is what we are trying to do...

We want to display a page that has a layer for each inventory item. We want to color code each item based on it's status. (sold, uc, avail).

Mysql holds an inventory table that contains the status of inventory.

So, we could do a specific query for each item to get it's status and make the conditional decision. This I have working as a prototype.

However, this would hit the mysql server maybe seventy times per page. So, I wanted to do a simple query to get invID, lotnumber & status. Put this in an array, then at each layer, reach into the array, find the row specific to that layer(pass it the lotnumber), get the status of that lotnumber and use it to make the conditional decision.

This would be repeated at each layer. This goal is to get the data once, then use it over and over for each layer as the page is parsed.

Hope this is clearer...

leatherback

That is exactly what the code does, except for that it skips the "Put this in an array" step.
Let me walk you trhough the code, and elaborate:

// define an array with potential classes. 
// uc stands for your status value, as it would appear in the database. 
// "sold" refers to the css class identifier

$classes = array(
"uc" => "sold",
"avail" => "avail");


// Get the data: We use one query, which gets all the data (YourQueryHere is the query to do this. I will use a generic one

$YourQueryHere = "select * from TABLE";

// And query the database
$result = mysql_query($YourQueryHere);

if($result)  // If the query was succesfull
  {
  // As long as the database can return records, do so:
  while($result = mysql_fetch_assoc($result))
    {
    // For each record we spit out the lotnumber, in a <span>. 
    // The span class is derived from the class- array, 
    // by using the status colum in the database as a key.
    // You can add as muych output here as you'd like. 
    // The magic is in 'class=\"".$classes[$row['status']]."\"'

echo "<span class=\"".$classes[$row['status']]."\">".$row['lotnumber']."</span>";
}
  }

Hope this clears it a bit. If not: please try it on your data...