/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

12 votes270 views4 answers
Laravel auth setup
PHP Laravel
0 vote263 views1 answer
Unlink(p1): No such file or directory
PHP
-1 vote251 views1 answer
Laravel 7 generator
PHP Laravel
0 vote269 views4 answers
Laravel 8: bootstrap
PHP
1 vote295 views1 answer
None of the supported PHP extensions (PgSQL, PDO_PgSQL) are available.
PHP
1 vote315 views1 answer
How can get url from $request in laravel
PHP Laravel
0 vote371 views1 answer
100 snippets wordpress
PHP Wordpress
1 vote228 views1 answer
Laravel find or skip
PHP
3 votes324 views5 answers
How to create slug in laravel
PHP Laravel
0 vote335 views1 answer
Laravel collection prepend
PHP Laravel