Read a stdclassObject to get the key and values

Question

Below is the resultset of a Query. How can I print out the column names User,UserID and place?

print_r($report_results);

$report_results is the object shown below

Array (
        [0] => stdClass Object ( [User] => Helton, Joshua [UserID] => 31 [place] => Dallas) 
        [1] => stdClass Object ( [User] => Miller, Jona [UserID] => 95 [place] => Cupertino)
        [2] => stdClass Object ( [User] => Sarah, Thomson [UserID] => 32 [place] => Las Vegas)
    )

Please please learn just the basics how to access an array and a object! — Rizier123
– Rizier123, Commented Apr 2, 2015 at 18:44

Explosion Pills · Accepted Answer · 2015-04-02 18:44:47Z

1

Use object access notation, -> as in

var_dump($stdObj->User, $stdObj->UserID, $stdObj->place);

What you have dumped is an array, though, so you'll have to access elements within the array:

var_dump($array[0]->User);

You probably just want to iterate over the array.

foreach ($user as $array) {
    var_dump($user->User, $user->UserID, $user->place);
}

answered Apr 2, 2015 at 18:44

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

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

9 Comments

Learner2011 Over a year ago

I don't want their values..I am trying to get the column names from resultset since I am working in creating a table for displaying data which would have dynamic column names as per the query..

Rizier123 Over a year ago

@Learner2011 Have you tried something to get the names?

Explosion Pills Over a year ago

@Learner2011 in that case it would be better for your query response to return an array with keys of the column names rather than a stdClass object

Learner2011 Over a year ago

@ExplosionPills Could you please give an example as how?

Explosion Pills Over a year ago

@Learner2011 I would have to see the code that generates the array of objects in your question.

|

Collectives™ on Stack Overflow

Read a stdclassObject to get the key and values

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related