public function update($data) { $result = false; $pdo = DbUtil::connect(); $dao = new M11StatusDao($pdo); // create new category object $obj = new M11StatusBO(); // get id from request if (property_exists($data, 'id')) { $obj->setM11Statusid($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(M11StatusBO $obj) { $stmt = $this->db->prepare(self::$selectByIdSQL); $id = intval($obj->getM11statusid()); $stmt->execute(array($id)); $row = $stmt->fetch(PDO::FETCH_ASSOC); if ($row != null) { $obj = new M11StatusBO(); $obj->setM11statusid($row['M11STATUSID']); $obj->setCode($row['CODE']); $obj->setLabel($row['LABEL']); $obj->setCreatedon($row['CREATEDON']); $obj->setCreateby($row['CREATEBY']); $obj->setModifiedon($row['MODIFIEDON']); $obj->setModifiedby($row['MODIFIEDBY']); } return $obj; }