/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

0 vote335 views1 answer
Codeigniter abort 404
PHP CodeIgniter
0 vote304 views1 answer
Destroy session codeigniter 3
PHP CodeIgniter
0 vote314 views6 answers
Update codeigniter
PHP CodeIgniter
1 vote379 views4 answers
Dynamic base url codeigniter
PHP CodeIgniter
8 votes410 views4 answers
Codeigniter redirect
PHP CodeIgniter
0 vote343 views1 answer
Codeigniter email print debugger
PHP CodeIgniter
2 votes357 views1 answer
Merubah judul menjadi slug codeigniter
PHP CodeIgniter
2 votes295 views1 answer
Order by in codeigniter
PHP CodeIgniter
-1 vote308 views1 answer
Codeigniter get num_rows
PHP CodeIgniter
0 vote358 views2 answers
How to set optional third parameter in routes of codeigniter
PHP CodeIgniter