loop through PHP array and apply SQL

Question

I have an array I wish to loop through and apply some SQL if the record exists. I have something Like this:

$discontinuedProducts = ["MTUC7000AWS","MTUC7000AWB"];
$updateDiscontinuedProductsToInactive = mysql_query("UPDATE 'table_name' SET 'available_for_order' = 0 WHERE 'product_id' = $discontinuedProducts  ");

but I think my code isn't even executing, they're just being declared.

Just answered here: http://stackoverflow.com/questions/23478825/pass-php-variable-value-into-sql-in-clause — AbraCadaver, May 05 '14 at 18:18

score 0 · Answer 1 · answered May 05 '14 at 20:22

Your sql statement can not possibly work because the variable $discontinuedProducts that you are concatenating is not a string but an array. You will need to modify your code like this

// make string from the array
foreach($discontinuedProducts as $discontinuedProduct)
{
      // put single quotes around productname, comma at end and add to string
      $whereinstring .= "'$discontinuedProduct',";
}

// remove trailing comma
$whereinstring = trim($whereinstring,',');

// the sql
$sql = "UPDATE 'table_name' 
        SET 'available_for_order' = 0 
        WHERE 'product_id' IN ( $whereinstring ) ";

// and use this sql string in the mysqlfunction of your choice ....

loop through PHP array and apply SQL

1 Answers1