db->exec() to custom object

[Lou Simard]

Hi,

Is there a way to fetch MySQL object trough db->exec() and mapping it to a custom object like i would do with PDO ie: $stmt->fetch(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'classname') ?

I'm not using Mappers, i write the sql myself...

Thanks,

Lou

[xfra35]

It's not possible to directly manipulate the PDO statement, but you could easily create a class or trait for that, something like:

abstract class Mapper {

  function __construct($row) {
    foreach ($row as $k=>$v)
      if (property_exists($this,$k))
        $this->$k=$v;
  }

}


class Person extends Mapper {

  protected $name, $age;

}


foreach ($db->exec($sql) as $row) {
  $person=new Person($row);
}

[Lou Simard]

Thanks for the quick answer xfra35!

Lou