public function get_by_id($requirement_id) { $this->database->connect(); $sql = "SELECT * FROM welfrequirement WHERE welfreq_id=?"; //prepare the statement $statement = $this->database->initialize($sql); //Bind the parameters $statement->bind_param("i", $requirement_id); //Execute the above statement $statement->execute(); //Bind the result $statement->bind_result($welfreq_id, $title, $description, $end_date, $status, $org_name, $welf_id); $req = NULL; while ($statement->fetch()) { $req = new Requirement(); $req->setRequirementId($welfreq_id); $req->setTitle($title); $req->setDescription($description); $req->setDate($end_date); $req->setStatus($status); $req->setOrgname($org_name); $req->setWelfId($welf_id); } //Close Connection $this->database->close(); return $req; }