public function update($data) { $result = false; $pdo = DbUtil::connect(); $dao = new M05LessonDao($pdo); // create new category object $obj = new M05LessonBO(); // get id from request if (property_exists($data, 'id')) { $obj->setM05Lessonid($data->id); } // get the persistance obj from db $obj = $dao->getById($obj); $obj->import($data); $result = $dao->update($obj); DbUtil::disconnect(); return $result; }
public function getById(M05LessonBO $obj) { $stmt = $this->db->prepare(self::$selectByIdSQL); $id = intval($obj->getM05lessonid()); $stmt->execute(array($id)); $row = $stmt->fetch(PDO::FETCH_ASSOC); if ($row != null) { $obj = new M05LessonBO(); $obj->setM05lessonid($row['M05LESSONID']); $obj->setTitle($row['TITLE']); $obj->setLongdesc($row['LONGDESC']); $obj->setShortdesc($row['SHORTDESC']); $obj->setAdditionalinfo($row['ADDITIONALINFO']); $obj->setCreatedon($row['CREATEDON']); $obj->setCreatedby($row['CREATEDBY']); $obj->setModifiedon($row['MODIFIEDON']); $obj->setModifiedby($row['MODIFIEDBY']); $obj->setM11statusid($row['M11STATUSID']); } return $obj; }