Find users with a status
function getUsersByStatus($desiredStatus) {
$matchingUsers = [];
$conn = new mysqli("localhost", "db_user", "db_password", "users_database");
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$result = $conn->query("SELECT * FROM users");
while ($row = $result->fetch_assoc()) {
if ($row['status'] == $desiredStatus) {
$matchingUsers[] = $row;
}
}
$conn->close();
return $matchingUsers;
}
// example of using it
$registeredUsers = getUsersByStatus("registered");
Comments
0 B
|👍
/👎
0 B
|👍
/👎