Foreach和while循环打印相同的值

Question

I'm trying to get the info from each user, this is what I am trying:

$db_conexion = mysqli_connect("localhost", "foo", "bar", "users");
if(mysqli_connect_errno()){
    printf("Ocurrio un error en la conexion de la base de datos: %s
", mysqli_connect_error()); exit();
}

// I got $evUsers from previous MySQL query
// It looks like: 1,2,4,6,10,25;
// Each number = userID
$cleanUsers = preg_replace('/\;$/', '', $evUsers);
$members = explode(',', $cleanUsers);

foreach($members as $member){
    $result = mysqli_query($db_conexion, "SELECT * FROM users WHERE userID=$member");
    while($row = mysqli_fetch_array($result)){
        $memberID = $row['userID'];
        $memberName = $row['userName'];
        $memberAddress = $row['userAddress'];

        echo "ID: ".$memberID." - Name: ".$memberName." - Address: ".$memberAddress.PHP_EOL;
    }
}

mysqli_free_result($result);
mysqli_close($db_conexion);

This code prints the info from the first user over and over again.

What am i doing wrong?

Answer 1

Try this out

$members = preg_replace('/\;$/', '', $evUsers);
//$members = explode(',', $cleanUsers); <--- take this off

//foreach($members as $member){ <--- take this off as well
    $result = mysqli_query("SELECT * FROM users WHERE userID IN ($members)");
    while($row = mysqli_fetch_array($result)){
        $memberID = $row['userID'];
        $memberName = $row['userName'];
        $memberAddress = $row['userAddress'];

        echo "ID: ".$memberID." - Name: ".$memberName." - Address: ".$memberAddress.PHP_EOL;
    }
//}