Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function searchjobs2()
- {
- //$id=$_SESSION['id'];
- $lan = $_POST["picke"]; //var_dump($id);die();
- $value['list']=$this->Free_model->get_jobs($lan);//var_dump($value);die();
- $this->load->view('free/header');
- $this->load->view('free/searchjobs2',$value);
- }
- public function get_jobs($lan)
- {
- $this->db->select('*');
- $this->db->from("tbl_work_stats");
- $this->db->join("tbl_work", "tbl_work.login_id = tbl_work_stats.login_id",'inner');
- $this->db->where("language LIKE '%$lan%'");
- // $this->db->where('tbl_work_stats.login_id',$id);
- $this->db->order_by('insertdate','asc');
- $query=$this->db->get()->result_array();//var_dump($query);die();
- return $query;
- }
- foreach ($list as $row){
- ...
- }
- public function get_jobs($lan)
- {
- $this->db->select('*');
- $this->db->from("tbl_work_stats");
- $this->db->join("tbl_work", "tbl_work.login_id = tbl_work_stats.login_id",'inner');
- $this->db->like('language', $lan);
- /* if not works prepend the table name before language field*/
- //$this->db->where("language LIKE '%$lan%'");
- $this->db->order_by('insertdate','ASC');
- $result = $this->db->get()->result_array();
- return $result;
- }
- $this->db->distinct();
- public function get_jobs(string $lan):array
- {
- return $this->db->select()
- ->from('tbl_work_stats')
- ->join('tbl_work','tbl_work.id = tbl_work_stats.work_id')
- ->like('language',$lan)
- ->order_by('insertdate')
- ->get()
- ->result_array();
- }
Add Comment
Please, Sign In to add comment