How to access an object inside an array

Question

I have this small code:

$user = Database::getInstance()->query("SELECT username FROM users");
if ($user->count()) {
    foreach ($user as $users) {
        echo $users->username;
    }
}
var_dump($users);die();

This gives me an error:

Notice: Trying to get property 'username' of non-object in C:\xampp\htdocs\finaltask\test.php on line 8
array(2) { [0]=> object(stdClass)#5 (1) { ["username"]=> string(10) "reinisk157" } [1]=> object(stdClass)#6 (1) { ["username"]=> string(9) "reinisk22" } }

If I understand correctly, Im trying to retrieve an object from an array, but I have no idea how else to get this data out of my DB. Please let me know if you need more details.

Can you share the object? It is saying you do not have an object called user — Jay Blanchard
– Jay Blanchard, Commented Mar 19, 2019 at 15:33
$users is probably not the one you want to loop over or echo from. You could change the db result from $user to $users and then change your echo to echo $user->username. Right now you are getting the $users out of nowhere. — Dirk Scholten
– Dirk Scholten, Commented Mar 19, 2019 at 15:37

DarkMukke · Accepted Answer · 2019-03-19 15:47:18Z

1

There are some issue of scope and naming here that may confuse you.

Scope of a foreach

foreach($list as $item) {
    // ... do something
}
echo $item;

When looping through a list/array, the last item of the loop will still be available after the loop. That's why the dump looks like it does, as you are dumping the wrong thing.

$userResult = Database::getInstance()->query("SELECT username FROM users");
if ($userResult->count()) {
    foreach ($userResult as $user) {
        echo $user->username;
    }
}
var_dump($userResult);die();

answered Mar 19, 2019 at 15:47

DarkMukke

2,4891 gold badge24 silver badges32 bronze badges

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

Comments

Satish Saini · Accepted Answer · 2019-03-19 16:13:44Z

1

Use $usersResult = $users->fetchAll(PDO::FETCH_OBJ); and then foreach as you used.

$users = Database::getInstance()->query("SELECT username FROM users");
$usersResult = $users->fetchAll(PDO::FETCH_OBJ);
if ($usersResult->count()) {
    foreach ($usersResult as $user) {
        echo $user->username;
    }
}
var_dump($usersResult);
die();

Note: I have changed $users to $user while parsing data in the loop because this makes more sense for individual user's data.

Hope this works!

edited Mar 19, 2019 at 16:13

answered Mar 19, 2019 at 15:50

Satish Saini

2,9783 gold badges27 silver badges38 bronze badges

2 Comments

dWinder Over a year ago

This is stbObject - why access like array?

DarkMukke Over a year ago

You are assuming that Database::getInstance() returns a PDO Object, at this point it could be anything

MNN · Accepted Answer · 2019-03-19 18:21:53Z

0

First, semantically, with that query you fetch users, not just one user. It's not important when it comes to the code itself, but it's important to understand it :)

$users = Database::getInstance()->query("SELECT username FROM users");
// I prefer is_null over count(), when a query returns 0 rows turns on null
if (!is_null($users)) {
    foreach($users as $user){
        //Try calling it this way
        echo $user['username'];
    }
}

answered Mar 19, 2019 at 18:21

MNN

3022 silver badges7 bronze badges

Comments

Reinis Krūkliņš · Accepted Answer · 2019-03-20 17:37:47Z

0

thamks for all the answers, i'll try them as well. The one I made it work was:

echo $users[0]->username;

answered Mar 20, 2019 at 17:37

Reinis Krūkliņš

195 bronze badges

Collectives™ on Stack Overflow

How to access an object inside an array

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related