public function get_all()
{
//ARRAY OBJECT HARU PASS GARNA
$user_list = array();
//DATABASE CONNECTION
$this->db->connect();
//SELECT ALL QUERY
$sql = "SELECT user_id,user_name,first_name,last_name,contact_number,user_type,user_status,gen_id,age FROM user INNER JOIN generaluser ON user_id = u_id";
//fetchquery
$result = $this->db->fetchquery($sql);
//STORE IN OBJECT AND SEND TO VIEW
while ($row = $result->fetch_assoc()) {
$user_model = new User_Model();
$user_model->set_user_id($row['user_id']);
$user_model->set_user_name($row['user_name']);
$user_model->set_first_name($row['first_name']);
$user_model->set_last_name($row['last_name']);
$user_model->set_contact_number($row['contact_number']);
$user_model->set_user_type($row['user_type']);
$user_model->set_user_status($row['user_status']);
array_push($user_list, $user_model);
}
$this->db->close();
return $user_list;
}
public function get_by_id($id)
{
$user_model = null;
//DATABASE CONNECTION
$this->db->connect();
//SELECT BY ID
$sql = "SELECT * FROM user WHERE user_id=?";
//PREPARE
$stmt = $this->db->initialize($sql);
//BIND
$stmt->bind_param("i", $id);
//EXECUTE
$stmt->execute();
//BIND RESULT
$stmt->bind_result($user_id, $user_name, $first_name, $last_name, $contact_number, $user_type, $user_status, $user_hash);
while ($stmt->fetch()) {
//instantiate object
$user_model = new User_Model();
$user_model->set_user_id($user_id);
$user_model->set_user_name($user_name);
$user_model->set_first_name($first_name);
$user_model->set_last_name($last_name);
$user_model->set_contact_number($contact_number);
$user_model->set_user_type($user_type);
$user_model->set_user_status($user_status);
$user_model->set_user_hash($user_hash);
}
$this->db->close();
return $user_model;
}
public function get_all()
{
//ARRAY OBJECT HARU PASS GARNA
$user_list = array();
//DATABASE CONNECTION
$this->db->connect();
//SELECT ALL QUERY
$sql = "SELECT user_id,user_name,first_name,last_name,contact_number,user_type,user_status,name,doe,img,address,service,objective FROM user INNER JOIN welfare ON user_id = u_id";
//fetchquery
$result = $this->db->fetchquery($sql);
//STORE IN OBJECT AND SEND TO VIEW
while ($row = $result->fetch_assoc()) {
$user_model = new User_Model();
$user_model->set_user_id($row['user_id']);
$user_model->set_user_name($row['user_name']);
$user_model->set_first_name($row['first_name']);
$user_model->set_last_name($row['last_name']);
$user_model->set_contact_number($row['contact_number']);
$user_model->set_user_type($row['user_type']);
$user_model->set_user_status($row['user_status']);
$user_model->set_welf_name($row['name']);
$user_model->set_welf_doe($row['doe']);
$user_model->set_welf_img($row['img']);
$user_model->set_welf_address($row['address']);
$user_model->set_welf_objective($row['objective']);
$user_model->set_welf_service($row['service']);
array_push($user_list, $user_model);
}
$this->db->close();
return $user_list;
}
