PHP Array Elements as Arguments to SQL IN Operator

Question

$option_meno = ["Lukas", "Ivka"];
$sql = "SELECT * 
        FROM uctovnictvo 
        WHERE meno IN ('$option_meno[1]', '$option_meno[0]')
          AND datum BETWEEN '$date_start' AND '$date_end'
        ORDER BY $order ";

For sure there has to be a better way how to select user based on name (meno). There can be more or fewer names in the $option_meno array.

I would like to make especially this more simple than listing out each index in the option array ('$option_meno[1]','$option_meno[0]').

faintsignal · Accepted Answer · 2014-07-01 22:22:14Z

2

You could use some array functions to auto generate the correct IN statement

$option_meno = ["Lukas","Ivka"];
$in = implode(',', array_map(function($item) use ($pdo) {
    return '"' . $pdo->quote($item) . '"';
}, $option_meno);

$sql = "SELECT * FROM uctovnictvo WHERE meno IN ($in)...";

instead of PDO::quote you could use also mysqli_real_escape_string, etc. (depends on your connection).

edited Jul 1, 2014 at 22:22

faintsignal

1,8363 gold badges22 silver badges30 bronze badges

answered Jul 1, 2014 at 21:24

Philipp

15.7k4 gold badges38 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

souslov · Accepted Answer · 2014-07-01 21:19:55Z

1

You can use implode() :

$sql = " SELECT * 
         FROM uctovnictvo 
         WHERE meno IN ('" . implode('\', \'', $option_meno) . "') 
           AND datum BETWEEN '$date_start' AND '$date_end'  
         ORDER BY $order ";

answered Jul 1, 2014 at 21:19

souslov

44.7k11 gold badges92 silver badges113 bronze badges

Collectives™ on Stack Overflow

PHP Array Elements as Arguments to SQL IN Operator

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related