File: /home/barbeatleanalyti/public_html/public_html/application/models/Front_model.php
<?php
class Front_model extends CI_Model
{
public function newregistration($insertArr)
{
$this->load->database();
//print_r($insertArr);
return $this->db->insert('bb_user',$insertArr);
}
public function fetchuserinfo($fld,$value){
$this->load->database();
$query = $this->db->get_where('bb_user' , array($fld=>$value));
$result = $query->result();
return $result;
}
public function userloginvalidate($email,$pass,$utype){
$this->load->database();
$query = $this->db->get_where('bb_user' , array('emailid'=>$email,'password'=>$pass,'utype'=>$utype));
$result = $query->result();
return $result;
}
public function fetchprofileuserinfo(){
$this->load->database();
$this->db->select("*");
$this->db->from("bb_user");
$this->db->join("bb_user_profile","bb_user_profile.bbuid = bb_user.bbuid","LEFT");
$this->db->where("bb_user.bbuid" , $_SESSION['loginid']);
$query = $this->db->get();
return $result = $query->result();
}
public function fetch_profile_data_only(){
$this->load->database();
$query = $this->db->get_where('bb_user_profile' , array('bbuid'=>$_SESSION['loginid']));
$result = $query->result();
return $result;
}
public function insertprofiledata($insertArr)
{
$this->load->database();
//print_r($insertArr);
return $this->db->insert('bb_user_profile',$insertArr);
$result = $query->result();
return $result;
}
public function update_profile_data($insertArr)
{
$this->load->database();
$this->db->where('bbuid',$_SESSION['loginid'])->update('bb_user_profile',$insertArr);
//$result = $query->result();
return $result;
}
}
?>