public function getById(M04ChapterBO $obj) { $stmt = $this->db->prepare(self::$selectByIdSQL); $id = intval($obj->getM04chapterid()); $stmt->execute(array($id)); $row = $stmt->fetch(PDO::FETCH_ASSOC); if ($row != null) { $obj = new M04ChapterBO(); $obj->setM04chapterid($row['M04CHAPTERID']); $obj->setChaptername($row['CHAPTERNAME']); $obj->setChapternumber($row['CHAPTERNUMBER']); $obj->setM11statusid($row['M11STATUSID']); $obj->setDescription($row['DESCRIPTION']); $obj->setShortdesc($row['SHORTDESC']); $obj->setCreatedon($row['CREATEDON']); $obj->setCreatedby($row['CREATEDBY']); $obj->setModifiedon($row['MODIFIEDON']); $obj->setModifiedby($row['MODIFIEDBY']); } return $obj; }