MySQLi with OR condition array

Question

Say an array variable $i which contains the serial numbers. Example: $i=array("1", "15", "20", "23"); This variable is set by $_POST.

And the MySQLi query is such to delete the rows which serial numbers exists in the array. i.e. If serial number = 1 or 15 or 20 or 23, delete the row. How to write it as a single MySQLi prepared statement?

I tried with foreach, but the that logic will do query for n number of times, where n is the size of the array.

foreach($i as $sno)// Only the logic I use
{
    DELETE FROM `table` WHERE `sno`=?
    bind_param("i", $sno);
    execute();
}

How can this simplified so the query can be re-written as sno=[1] or [2] or [3] or ... [n]

possible duplicate of [mysqli bind\_param for array of strings](http://stackoverflow.com/questions/17226762/mysqli-bind-param-for-array-of-strings) — Tim Burch, Mar 10 '14 at 14:31

score 0 · Accepted Answer · answered Mar 10 '14 at 14:35

0

You can use the IN

Here is the logic,

DELETE FROM table WHERE sno IN ($i)

answered Mar 10 '14 at 14:35

Sarvap Praharanayuthan

4,212
7
47
72

Out of all possible answers this one is fabulous. – Your Common Sense Mar 10 '14 at 14:36
@YourCommonSense: Is tht a satire or recommendation? – Mr Cathode Mar 10 '14 at 14:52
It doesn't matter actually. Nobody cares either way. – Your Common Sense Mar 10 '14 at 14:53

MySQLi with OR condition array

1 Answers1