Call Specific Column In Array

Question

I have some array like this
When I use code like this :

I got this error : Notice: Undefined index: users_id in D:\xampp\htdocs\home\database\index.php on line 21

I want to call specific columns like : users_id , users_username ,etc.

If I use :

var_dump ($rowset);

I got :

Array ( [0] => Array ( [users_id] => 1 [users_username] => admin [users_password] => admin

My Code :

$rowset = array();
    while ($row = $sql->fetch(PDO::FETCH_ASSOC)){  `enter code here`
        $rowset[] = $row;
    }
        echo $rowset["users_id"];// Line 21

Thanks

Possible duplicate of [PHP: "Notice: Undefined variable", "Notice: Undefined index", and "Notice: Undefined offset"](http://stackoverflow.com/questions/4261133/php-notice-undefined-variable-notice-undefined-index-and-notice-undef) — u_mulder, Mar 05 '17 at 08:55

Rahul · Accepted Answer · 2017-03-05T08:57:34.583

1

Once try like this,

foreach($rowset as $k => $v){
 echo $rowset[$k]["users_id"];
}

edited Mar 05 '17 at 08:57

answered Mar 05 '17 at 08:54

Rahul

18,271
7
41
60

Then i got just one users_id – Joel Mar 05 '17 at 08:55
then use foreach, check answer again – Rahul Mar 05 '17 at 08:57
:D This message is for you, :p DO it after six minutes. – Rahul Mar 05 '17 at 09:01

score 0 · Answer 2 · answered Mar 05 '17 at 09:22

0

you may make use of the pretty array_column :

$user_ids = array_column($rowset, 'users_id');

answered Mar 05 '17 at 09:22

hassan

7,812
2
25
36

Call Specific Column In Array

2 Answers2