How to iterate over stdClass?

[oikram]

Thanks you all. Well the main goal is to build a xls file from mysql data.
I’ve followed several examples, and I only see examples using mysql_num_rows, and mysql_num_fields, however, I’d like to do that using PDO, and if it makes more sense, to use the FETCH_OBJ for the effect.

@oddz

The method returns an array of objects not a single object.

foreach ($this->_daoh->listar() as $intIndex => $objRecord) {
     print "$intIndex => {$objRecord->name}\
";
}

Thanks. I’m not actually sure if I understand the concept of an array of objects. When I var_dump $objRecord it seems more that I’m inside an object, that object contains an array, and each key of that array that the object contains, corresponds to a column name that we have fetched.
Am I thinking wrong?

Since I want to grab the property names, to serve as columns on a xls file, maybe then, the foreach may be of no use in this case?

@Fax

You are converting $property (an instance of stdClass), to a string;

    print "$property => $property_value\
";

Should just be;

    printf('$property => %s' . PHP_EOL, $property->property_value);

So, if I’ve properly understood, that will output $property as a string, and then return his value as well… however, something like this:
inside the foreach,
foreach ($objRecord as $property => $property_value)
{
printf(‘$property => %s’ . PHP_EOL, $property->name);
}

Doesn’t seem to work: “Trying to get property of non-object” and it’s right, because, $property is no longer an object right? It was been converted into a string…?

Anyway, I’m getting away from the point.

The main point is, grab rows and columns form our database and put then on a xls, using PDO and fetch_obj for the effect. The question that rises is:
what ways do we have, to look into the object returned, and grab values and properties names and output that?

Regards,
Márcio