|
Server IP : 172.26.0.195 / Your IP : 3.142.54.136 Web Server : Apache System : Linux 43-205-77-33.cprapid.com 3.10.0-1160.119.1.el7.tuxcare.els2.x86_64 #1 SMP Mon Jul 15 12:09:18 UTC 2024 x86_64 User : jnclnmuac ( 1026) PHP Version : 8.0.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/jnclnmuac/public_html/web/../jnclnmu/../alumni/application/models/user/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
/**
* Description of User
*
* @author Softpro India Pvt. Ltd.
*/
class UserManagement extends CI_Model {
//put your code here
function getUser($userid, $password = '') {
$this->db->select("*");
$this->db->from("tbl_stu_alu");
$this->db->where("userid", $userid);
if ($password != '')
$this->db->where("password", $password);
return $this->db->get();
}
function updateUser($userDetails) {
$this->db->where("userid", $userDetails["userid"]);
return $this->db->update("tbl_stu_alu", $userDetails);
}
function getUserProfileDetails($userid) {
$this->db->select("*");
$this->db->from("tbl_profile");
$this->db->where("user_id", $userid);
return $this->db->get();
}
function updatePrimaryInfoData($primaryInfoArray, $userid) {
$this->db->where("userid", $userid);
return $this->db->update("tbl_stu_alu", $primaryInfoArray);
}
function getUsersNumRows($searchKeyword = '') {
$this->db->select("*");
$this->db->from("tbl_stu_alu sa");
$this->db->join("tbl_profile p", "sa.userid=p.user_id");
$this->db->where("sa.name LIKE '%$searchKeyword%' OR sa.email LIKE '%$searchKeyword%' OR sa.mobile LIKE '%$searchKeyword%' OR sa.college_loc LIKE '%$searchKeyword%' OR sa.session LIKE '%$searchKeyword%'");
return $this->db->get();
}
function getUsers($searchKeyword = '', $per_page, $offset) {
$this->db->select("*");
$this->db->from("tbl_stu_alu sa");
$this->db->join("tbl_profile p", "sa.userid=p.user_id");
$this->db->join("tbl_course co", "sa.c_id=co.c_id");
$this->db->where("sa.name LIKE '%$searchKeyword%' OR sa.email LIKE '%$searchKeyword%' OR sa.user_type LIKE '%$searchKeyword%' OR sa.mobile LIKE '%$searchKeyword%' OR sa.college_loc LIKE '%$searchKeyword%' OR sa.session LIKE '%$searchKeyword%' OR sa.gender LIKE '%$searchKeyword%' OR co.c_name LIKE '%$searchKeyword%'");
if ($per_page > 0 || $offset != null || $offset != "") {
$this->db->limit($per_page, $offset);
}
return $this->db->get();
}
function getUserPersoanlAndProfileDetails($userid) {
$this->db->select("*");
$this->db->from("tbl_stu_alu sa");
$this->db->join("tbl_profile p", "sa.userid = p.user_id");
$this->db->join("tbl_course co", "sa.c_id = co.c_id");
$this->db->where("sa.userid", $userid);
return $this->db->get();
}
}