/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 vote370 views1 answer
Codeigniter set db prefix
PHP CodeIgniter
4 votes396 views5 answers
Codeigniter 4 base_url
PHP CodeIgniter
0 vote343 views1 answer
Destroy session codeigniter 3
PHP CodeIgniter
0 vote322 views1 answer
Single row in codeigniter
PHP CodeIgniter
0 vote354 views1 answer
Creating thumbnail in codeigniter
PHP CodeIgniter
0 vote396 views1 answer
Codeigniter 3 session not working after some time
PHP CodeIgniter
0 vote363 views1 answer
Codeigniter remote queries very slow
PHP CodeIgniter
0 vote379 views1 answer
Php artisan spark not working in codeigniter
PHP CodeIgniter
1 vote360 views2 answers
Codeigniter query result
PHP CodeIgniter
1 vote420 views4 answers
Dynamic base url codeigniter
PHP CodeIgniter