Create a custom object from DB result()?

[eluser]Andy Ingham[/eluser]
Hi All,

An interesting question (hopefully!)...

If I process through query results using the following code:

Code:

foreach ($query->result() as $row) {
    ...
}

then each '$row' is an object (of type stdClass?).

However, if I want to create my own 'custom' object for each row, so that I can wrap methods around the data, then what's the best way of doing it?

I notice in the 'mysqli_result::fetch_object' php.net documentation that you have the option of specifying a class_name when retrieving a row as an object:

class_name

The name of the class to instantiate, set the properties of and return. If not specified, a stdClass object is returned.

...so maybe this gives a clue as to an approach (although the CI result() function doesn't seem to accept any arguments).

Another approach is presumably to retrieve the row into a stdClass object, as described earlier, but then to copy the attributes from the stdClass object to my own class. If so, anyone know how best way to do this?

Any help on this greatly appreciated.

Thanks,

Andy