mysql select multiple values from array match

Question

I have an array lets say: Array ( [0] => 9 [1] => 7 [2] => 8 )

I want to SELECT from a table (users) all phone numbers where userID matches one from the array (if there is a phone number listed).

I want to do this without selecting all of the users from the database and only those that match that of the array and with actual phone numbers, should I do this in a loop?

Typically when I am doing an UPDATE, I do them within a foreach loop. Like so:

foreach($userArr as $user) {
            $pid = $user;
            if(!$statement->execute()) {
                    throw new Exception($statement->error, $statement->errno);
            }
    }
$statement->close();

Can we do SELECT like that as well?

Thanks in advance for any advice.

Hilder Vitor Lima Pereira · Accepted Answer · 2015-03-19 23:05:17Z

5

If you want to select all these users, just do the follow:

$idList = implode(',', $yourArray);
$sql = "SELECT * FROM users WHERE id IN($idList)";
// execute this $sql query

answered Mar 19, 2015 at 23:05

Hilder Vitor Lima Pereira

1,69013 silver badges23 bronze badges

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

Comments

Adrian Cid Almaguer · Accepted Answer · 2015-03-19 23:04:18Z

2

Try this:

    <?php

    $array = array(9, 7, 8);

    $query = "SELECT * FROM mytable WHERE id = ";

    $condition = implode(' OR id = ', $array);

    $query .= $condition;

    echo $query;
?>

Output:

SELECT * FROM mytable WHERE id = 9 OR id = 7 OR id = 8

answered Mar 19, 2015 at 23:04

Adrian Cid Almaguer

7,79113 gold badges44 silver badges66 bronze badges

Comments

Orel Eraki · Accepted Answer · 2015-03-19 23:03:04Z

0

You should do the following:

Build a string to express the userid seperated by comma. - Loop will be needed. i.e id1, id2, id3
Build the query string to search for them.

Example:

SELECT * FROM `Users` WHERE id IN (id1, id2, id3)

answered Mar 19, 2015 at 23:03

Orel Eraki

12.2k4 gold badges31 silver badges38 bronze badges

Collectives™ on Stack Overflow

mysql select multiple values from array match

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related