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" — u_mulder
– u_mulder, Commented Mar 5, 2017 at 8:55

Rahul · Accepted Answer · 2017-03-05 08:57:34Z

1

Once try like this,

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

edited Mar 5, 2017 at 8:57

answered Mar 5, 2017 at 8:54

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

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

3 Comments

Joel Over a year ago

Then i got just one users_id

Rahul Over a year ago

then use foreach, check answer again

Rahul Over a year ago

:D This message is for you, :p DO it after six minutes.

hassan · Accepted Answer · 2017-03-05 09:22:37Z

0

you may make use of the pretty array_column :

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

answered Mar 5, 2017 at 9:22

hassan

8,3282 gold badges28 silver badges40 bronze badges

Collectives™ on Stack Overflow

Call Specific Column In Array

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related