/PHP/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

6 votes309 views1 answer
Laravel scaffolding
PHP
6 votes351 views4 answers
Laravel use url
PHP Laravel
0 vote335 views1 answer
Laravel update order field sample
PHP Laravel
0 vote334 views2 answers
Php is multiple of
PHP
1 vote319 views1 answer
How match array in laravel collection
PHP
0 vote277 views1 answer
Eloquent value
PHP
3 votes315 views2 answers
Spaceship operator
PHP
14 votes304 views2 answers
Ucfirst
PHP
1 vote350 views4 answers
Laravel assign active based on route name
PHP
23 votes341 views6 answers
Make auth in laravel 7
PHP Laravel