Get rows from mysql table to php array

Question

$sql = "SELECT active FROM table_name";
$result = $conn->query($sql);

DB:

|active|
1
1
0
1 

I've got table like this and need to get that rows into an array. Is it possible to get simple array like this?:

$array = (1,1,0,1);

thanks

Answer 1

$sql = "SELECT active FROM table_name";
$result = $conn->query($sql);

$arr=array();

foreach($result as $res)
{
  array_push($arr,$res->active);
}

var_dump($arr);

Answer 2

$sql = "SELECT active FROM table_name";

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {
        $arr[]= $row['active'];
    }

print_r($arr);