从mysql表中获取行到php数组

Get rows from mysql table to php array

本文关键字：php 数组获取 mysql | 更新日期: 2023-09-27

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

|active|
1
1
0
1

我有这样的表，需要得到的行到一个数组。有可能得到这样一个简单的数组吗?:

$array = (1,1,0,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);

$sql = "SELECT active FROM table_name";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()) {
        $arr[]= $row['active'];
    }
print_r($arr);