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

user5189304 · Accepted Answer · 2016-09-14 14:27:37Z

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);

answered Sep 14, 2016 at 14:27

user5189304

Sign up to request clarification or add additional context in comments.

4 Comments

Nini Vanini Over a year ago

Thanks @Shoyeb. But when I use your code it writes: Notice: Trying to get property of non-object in website.php on line [[ array_push($arr,$res->active); ]] please dont you know what is wrong?

momouu Over a year ago

Change $res->active to $res['active']. because it is an array, not an object.

user5189304 Over a year ago

Hi @momouu, If I am not wrong an array is object as well

momouu Over a year ago

Hey @ShoyebSheikh, I'm not really familiar with objects but I think an object can only contain 1 value and array can contain multiple objects. I'm not really sure. I just distinguish them by the ->, [] and the result from print_r() or var_dump().

momouu · Accepted Answer · 2016-09-14 14:40:04Z

0

$sql = "SELECT active FROM table_name";

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

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

print_r($arr);

answered Sep 14, 2016 at 14:40

momouu

7114 silver badges14 bronze badges

1 Comment

momouu Over a year ago

Glad that I can help :)

Collectives™ on Stack Overflow

Get rows from mysql table to php array

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related