I want to delete a record in my sql with array as inputs with two where statement

Question

I want to delete a record in my sql with array as inputs with two where statement. I cant find a statement like this one...

"DELETE FROM perpetualinventory WHERE productID= ".implode(',',$productID)" && expiryDate=".implode(',',$expiryDate);

for the suggested answer

 "DELETE FROM perpetualinventory WHERE productID IN (".implode(',',$productID)") AND expiryDate IN (".implode(',',$expiryDate).")";

syntax error, unexpected '") AND expiryDate IN ("' (T_CONSTANT_ENCAPSED_STRING)

You are missing a dot `(".implode(',',$productID)")` should be `(".implode(',',$productID).")` exactly what the error says `syntax error, unexpected '")` — ArtisticPhoenix, Jul 31 '16 at 20:44

teliaz · Answer 1 · 2016-07-31T20:39:34.427

0

Even it is not suggested you could do this

"DELETE FROM perpetualinventory WHERE productID IN (".implode(',',$productID).") AND  expiryDate IN (".implode(',',$expiryDate).")";

edited Jul 31 '16 at 20:39

answered Jul 31 '16 at 20:35

teliaz

97
3

`syntax error, unexpected '") AND expiryDate IN ("' (T_CONSTANT_ENCAPSED_STRING)` returns this error – Gina Co Jul 31 '16 at 20:38
this should work now – teliaz Jul 31 '16 at 20:40

w3spi · Accepted Answer · 2016-07-31T20:49:52.240

0

This code should work :

DELETE FROM perpetualinventory WHERE productID IN ('".implode($productID,"', '")."') AND expiryDate IN ('".implode($expiryDate,"', '")."')";

Explanation :

DELETE FROM table
WHERE column IN ('".
    implode($array, "'separator'") // separator = ', ' for arrays. Be careful for space after the comma.
."')
AND ...

edited Jul 31 '16 at 20:49

answered Jul 31 '16 at 20:40

w3spi

4,380
9
47
80

But, why does it work? Answers should explain the reason at the least, and not be just do this. – ArtisticPhoenix Jul 31 '16 at 20:45

I want to delete a record in my sql with array as inputs with two where statement

2 Answers2