public function get_by_id($id)
 {
     //connect
     $this->db->connect();
     //query
     $sql = "SELECT * FROM courses WHERE id=?";
     //prepare
     $stmt = $this->db->initialize($sql);
     //bind
     $stmt->bind_param("i", $id);
     //execute
     $stmt->execute();
     //bind result
     $stmt->bind_result($id, $course_name, $added_date, $status);
     while ($row = $stmt->fetch()) {
         $course = new courses();
         $course->set_id($id);
         $course->set_course_name($course_name);
         $course->set_added_date($added_date);
         $course->set_status($status);
     }
     $this->db->close();
     return $course;
 }
 public function init()
 {
     $this->registerAssets();
     parent::init();
 }
Esempio n. 3
0
 /**
  * Response when updating role succeed.
  *
  * @param  \Orchestra\Model\Role  $role
  *
  * @return mixed
  */
 public function destroySucceed(courses $courses)
 {
     $message = trans('orchestra/control::response.roles.delete', ['name' => $courses->getAttribute('name')]);
     return $this->redirectWithMessage(handles('orchestra::courses'), $message);
 }