/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 vote307 views1 answer
Gd2 image resizing library in codeigniter
PHP CodeIgniter
0 vote297 views1 answer
Access config variable in codeigniter controller
PHP CodeIgniter
4 votes357 views4 answers
Nginx codeigniter remove index.php
PHP CodeIgniter
2 votes302 views2 answers
Route codeigniter
PHP CodeIgniter
0 vote301 views1 answer
Insert array values in database using codeigniter
PHP CodeIgniter
0 vote325 views1 answer
Codeigniter 3 session not working after some time
PHP CodeIgniter
0 vote295 views1 answer
How to save snap in webcap in php codeigniter
PHP CodeIgniter
0 vote307 views1 answer
Codeigniter select where
PHP CodeIgniter
0 vote292 views1 answer
Codeigniter get user ip
PHP CodeIgniter
0 vote314 views1 answer
How to free session variable in php codeigniter
PHP CodeIgniter