/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

2 votes245 views3 answers
Laravel fortify
PHP
3 votes269 views4 answers
Laravel where has Relation
PHP Laravel
12 votes256 views6 answers
Php object
PHP
12 votes267 views6 answers
Php remove empty values from array
PHP
0 vote322 views1 answer
Agregar clases de rol al body en WordPress
PHP Wordpress
49 votes270 views6 answers
Laravel migrate seed
PHP
2 votes310 views1 answer
Laravel ever over https
PHP Laravel
3 votes261 views3 answers
Php pi() function
PHP
0 vote253 views1 answer
Check if column has value in laravel eloquent
PHP
6 votes281 views2 answers
Disable laravel debugbar
PHP Laravel