/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 votes312 views3 answers
Php request uri
PHP
0 vote332 views1 answer
Laravel storage goes to 404 page. (Symlink not working)
PHP Laravel
0 vote292 views1 answer
Laravel whereHas undefined variable
PHP
4 votes371 views2 answers
Pass parameter to view laravel
PHP Laravel
0 vote326 views1 answer
Laravel value eloquent
PHP Laravel
2 votes284 views1 answer
Laravel's collection pagination
PHP
0 vote279 views1 answer
Laravel collection forPage
PHP
0 vote287 views2 answers
Php cut after first sentence
PHP
2 votes228 views1 answer
Laravel serve host
PHP
2 votes377 views1 answer
Laravel get list of columns in a table
PHP