1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / Narpavi / application / models / admin /
Filename : User_model.php
back
<?php
class User_model  extends CI_Model {
	
	
	
	
	public function login_user($username,$pass){
//echo "Select * from tbl_users where username='".$username."' and password='".md5($pass)."'";exit;
  $Qry = $this->db->query("Select * from tbl_users where username='".$username."' and password='".$pass."'");
  if($Qry->num_rows()>0)
  {
  	  $this->db->query("Update tbl_users set last_login_date='".date('Y-m-d H:i:s')."',ip_address='".$this->input->ip_address()."' where username='".$username."' and password='".$pass."'");
      return $Qry->row_array();
  }
  else{
    return false;
  }
 
 
}
	
public function create()

        {
			$insert = array(
			"user_type" =>$this->input->post('user_type'),
			"first_name" =>$this->input->post('first_name'),
			"last_name" =>$this->input->post('last_name'),
			"username" =>$this->input->post('username'),
			"email_id" =>$this->input->post('email_id'),
			"phone" =>$this->input->post("phone"),
			"password" =>md5($this->input->post("password")),
			"u_status" =>$this->input->post("u_status"),
			"modified_date" =>date("Y-m-d H:i:s"),
			);
			
			//Profile Pic
			$insert1 =  array();
			if($_FILES['profile_pic']['name']!=''){  
             $insert1 = array('profile_pic'=>$this->uploadImages($_FILES['profile_pic'],'profile_pic'));
			}
			
		     $insert_Last = array_merge($insert,$insert1);
			
			//insert record
			$final = $this->db->insert('tbl_users',$insert_Last);
			if($final) {
				 return true;
		    }else{
				return false;
			}
			exit;
		}
		
 public function edit(){
	 
	  $update = array(
	  "user_type" =>$this->input->post('user_type'),
	  "first_name" =>$this->input->post('first_name'),
	  "last_name" =>$this->input->post('last_name'),
	  "username" =>$this->input->post('username'),
	  "email_id" =>$this->input->post('email_id'),
	  "mobile" =>$this->input->post('mobile'),
	  //"password" =>md5($this->input->post("password")),
	  "modified_date" =>date("Y-m-d H:i:s"),
	  );
   $user_type=$this->input->post('user_type');
   
	  
	  //Profile Pic
		
			$update1 =  array();
			if($_FILES['profile_pic']['name']!=''){  
             $update1 = array('profile_pic'=>$this->uploadImages($_FILES['profile_pic'],'profile_pic'));
			}
			$update_Last =  array_merge($update,$update1);
			//Update record
			$pid = $this->session->userdata('u_id');
			$this->db->where('u_id', $pid);
			$final = $this->db->update('tbl_users', $update_Last);
			 if($final){
				  return true;
			  }else{
				  return false;
			  }
			exit;			 
}
		
		
	function uploadImages($images,$filename){
		    if(isset($images) && $images['name']!=''){
							$this->load->helper('inflector');
							$config = array(
								'upload_path' => FCPATH."uploads/profile/",
								'allowed_types' => "gif|jpg|png|jpeg|pdf",
								'overwrite' => TRUE,
								'max_size' => "2048000", // Can be set to particular file size , here it is 2 MB(2048 Kb)
								'max_height' => "768",
								'max_width' => "1024",
								'file_name'=> time()."_".underscore($images['name'])
								);
								$this->load->library('upload', $config);
								if (!$this->upload->do_upload($filename)){
									 $error = array('error' => $this->upload->display_errors());
									 $m_filename = NULL;
								}else{
									$m_filename =  $this->upload->data('file_name');
							}
						}
						return $m_filename;
	 }	
	

public function user_details(){
            
			if($this->input->get('pid')){
				$id = $this->input->get('pid');
			}else{
				$id = $this->session->userdata('u_id');
			}
			
			$query=$this->db->query("SELECT * FROM tbl_users WHERE u_id='$id'");
			return $query->row();
}
             	
		
}