I'm new to PHP-MySQL array functions. So I need help for the following:
I need to select phone numbers of all users from the MySQL table "users" in PHP and then need to store the phone numbers in a variable. All the numbers should be separated by "," (comma).
What I have tried:
$stmt = $mysqli->prepare("SELECT phone FROM users WHERE status = ?");
$stmt->bind_param('i',$status);
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($phone);
while ($stmt->fetch())
{
$allphones = "$phone,"; //need help here.
}
$stmt->close();
What I need:
$allphones = "9999999990,9999999991,9999999992,9999999993";
all the phone numbers should be separated by comma (,) and stored in a variable like above.
Any help will be appreciated! Thanks!