Answers for "join codeigniter 3"

1

how to use join query in codeigniter

public function getdata(){	

	$this->db->select('*');
	$this->db->from('table1'); // this is first table name
	$this->db->join('table2', 'table2.id = table1.id'); // this is second table name with both table ids
	$query = $this->db->get();
	return $query->result();

	}
Posted by: Guest on July-11-2020
0

left join codeigniter

$this->db->join('user_email', 'user_email.user_id = emails.id', 'left');
Posted by: Guest on January-10-2021
0

cideigniter orLike()

$this->db->like('title', 'match'); $this->db->or_like('body', $match);
// WHERE `title` LIKE '%match%' ESCAPE '!' OR  `body` LIKE '%match%' ESCAPE '!'
Posted by: Guest on October-20-2020

Browse Popular Code Answers by Language