Guest User

Untitled

a guest
May 24th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.47 KB | None | 0 0
  1. public function searchjobs2()
  2. {
  3. //$id=$_SESSION['id'];
  4. $lan = $_POST["picke"]; //var_dump($id);die();
  5. $value['list']=$this->Free_model->get_jobs($lan);//var_dump($value);die();
  6. $this->load->view('free/header');
  7. $this->load->view('free/searchjobs2',$value);
  8. }
  9.  
  10. public function get_jobs($lan)
  11. {
  12. $this->db->select('*');
  13. $this->db->from("tbl_work_stats");
  14. $this->db->join("tbl_work", "tbl_work.login_id = tbl_work_stats.login_id",'inner');
  15. $this->db->where("language LIKE '%$lan%'");
  16. // $this->db->where('tbl_work_stats.login_id',$id);
  17. $this->db->order_by('insertdate','asc');
  18.  
  19. $query=$this->db->get()->result_array();//var_dump($query);die();
  20. return $query;
  21. }
  22.  
  23. foreach ($list as $row){
  24. ...
  25. }
  26.  
  27. public function get_jobs($lan)
  28. {
  29. $this->db->select('*');
  30. $this->db->from("tbl_work_stats");
  31. $this->db->join("tbl_work", "tbl_work.login_id = tbl_work_stats.login_id",'inner');
  32.  
  33. $this->db->like('language', $lan);
  34. /* if not works prepend the table name before language field*/
  35.  
  36. //$this->db->where("language LIKE '%$lan%'");
  37.  
  38. $this->db->order_by('insertdate','ASC');
  39.  
  40. $result = $this->db->get()->result_array();
  41.  
  42. return $result;
  43. }
  44.  
  45. $this->db->distinct();
  46.  
  47. public function get_jobs(string $lan):array
  48. {
  49. return $this->db->select()
  50. ->from('tbl_work_stats')
  51. ->join('tbl_work','tbl_work.id = tbl_work_stats.work_id')
  52. ->like('language',$lan)
  53. ->order_by('insertdate')
  54. ->get()
  55. ->result_array();
  56. }
Add Comment
Please, Sign In to add comment