Compare array value with string

toadstool · #1 June 14th, 2009, 05:15 AM

I have an array containing the various products

Expand|Select|Wrap|Line Numbers

 
$inventory = array();

$inventory[0] = "whatever1";

etc
I have an array containing various values

Expand|Select|Wrap|Line Numbers

$quantity = array(100,200,300);

I call in a value from a form $_POST[itemname]; say
I assign a variable

Expand|Select|Wrap|Line Numbers

$var1="$_POST[itemname]";

I want to compare the input value with the array value e.g.

Expand|Select|Wrap|Line Numbers

 
for($i = 0;$i<$inventory_total;$i++) {

   if($inventory[$i] == $item) { code }

}

However, this is always negative as I believe I cannot compare an array item with a string.
The only thing I've found so far is the "mplode" statement
But I want to compare individual array items not a string composed of all of them.
Can anyone suggest a simple conversion so that I can compare values?

Nepomuk · #2 June 15th, 2009, 02:31 PM

Hi toadstool!

First of all, just pasting the code here without telling us, which language it is isn't a good idea. If there is a specific forum for the language you're using, please use that, otherwise please state which language it is.

So, if you'd tell us, which language you're using, I'm sure one of the mods here will change that for you.

The other criticism is, that you didn't use [code]...[/code] tags. Wrap them around your code and it will look much nicer and can be read much more easily.

Greetings,
Nepomuk

toadstool · #3 June 15th, 2009, 08:52 PM

I am not familiar with the code tags referred to in one message. Do Ijust add them as such

Expand|Select|Wrap|Line Numbers

 ...

if (IN PHP) I call $cart->insert_Pcart($item1, $item2);
 
class Cart 

{

:

function insert_Pcart($item_name,$p_qty)

      {

$insert = "INSERT INTO Cart (pname, qty) 

VALUES ($_POST[$item_name]','$_POST[$p_qty]')"; 
 Line69=>     if (mysql_query($insert, $conn)) { $cartID = mysql_insert_id($conn);
 
} else          { die ("Error inserting CART FORM data: " .mysql_error()); };
 
//$p_name=($_REQUEST["p_name"]);

}

I get an error with this
I get the error
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:\phpdev\www\project_shopping_cart.php on line 69
Error inserting CART FORM data:

Can anyone explain what this error means, even better suggest a solution.

toadstool · #4 June 15th, 2009, 08:54 PM

I added the tags - some improvement - thanks for the suggestion.

Frinavale · #5 June 16th, 2009, 05:39 PM

I could be wrong here but it looks like your missing an apostrophe (') in the VALUES portion of your SQL query.

I think you should change this:

Expand|Select|Wrap|Line Numbers

 "INSERT INTO Cart (pname, qty) 

VALUES ($_POST[$item_name]','$_POST[$p_qty]')";

To this:

Expand|Select|Wrap|Line Numbers

 
"INSERT INTO Cart (pname, qty) 

VALUES ('$_POST[$item_name]','$_POST[$p_qty]')";

-Frinny

Compare array value with string

re: Compare array value with string

re: Compare array value with string

re: Compare array value with string

re: Compare array value with string

/bytes/development

/bytes/it

/bytes/about