/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

3 votes250 views3 answers
How to get last id in database codeigniter 4
PHP CodeIgniter
51 votes239 views2 answers
Display errors in codeigniter
PHP CodeIgniter
0 vote173 views1 answer
Execute sql query codeigniter
PHP CodeIgniter
0 vote167 views1 answer
Converting php to codeigniter
PHP CodeIgniter
0 vote155 views1 answer
$this meaning in codeigniter
PHP CodeIgniter
0 vote155 views1 answer
Pagination in codeigniter with example
PHP CodeIgniter
0 vote158 views1 answer
Gd2 image resizing library in codeigniter
PHP CodeIgniter
0 vote200 views1 answer
Group by codeigniter 3
PHP CodeIgniter
4 votes266 views2 answers
Redirect back in codeigniter
PHP CodeIgniter
0 vote162 views1 answer
Codeigniter get user ip
PHP CodeIgniter