why mysqli one pulling one row with foreach loop in php ?

Question

Hi friends why mysqli one pulling one row with foreach loop in php ? Shouldn't it fetch arrays of all rows ?

 $link = new mysqli(DB_SERVER, DB_USER,DB_PASSWORD,DB_NAME) or die('error connecting');
 $mob = query("SELECT mobile FROM members_db");
    foreach ($mob as $numbers){
        $mob_numbers = $numbers['mobile'];
        print_r($mob_numbers); exit();
    }

Answer 1

remove your exit(); within the loop

Answer 2

You need to do the following

Change:

foreach ($mob as $numbers)
{
    $mob_numbers = $numbers['mobile'];
    print_r($mob_numbers); exit();
}

To

$results = array();
foreach ($mob as $numbers)
{
    $results[] = $numbers['mobile'];
}
print_r($results); exit();

Answer 3

You have to 'Fetch' the records one by one

$mob = query("SELECT mobile FROM members_db");
while($row = mysqli_fetch_array($link, $mob)){
    print_r($row['mobile'])
}

Also, not sure why you're calling exit() inside the loop. Doesn't make sense.