/PHP/CodeIgniter/How to use join query in codeigniter

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();

	}

Source: wlearnsmart.com

Similar codes

4 votes332 views5 answers
Codeigniter 4 base_url
PHP CodeIgniter
3 votes335 views1 answer
Codeigniter check affected rows
PHP CodeIgniter
0 vote231 views1 answer
Search query codeigniter
PHP CodeIgniter
0 vote239 views1 answer
Codeigniter 3 Pass anything in query string
PHP CodeIgniter
0 vote236 views2 answers
Codeigniter4 route optional parameter
PHP CodeIgniter
3 votes238 views1 answer
Codeigniter check insert
PHP CodeIgniter
0 vote225 views2 answers
Codeigniter 4 db seed
PHP CodeIgniter
0 vote300 views1 answer
Login with email or username codeigniter 4
PHP CodeIgniter
2 votes263 views3 answers
Codeigniter last insert id
PHP CodeIgniter
0 vote226 views1 answer
Time zone set in codeigniter
PHP CodeIgniter