/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

0 vote160 views1 answer
Woocommerce product hooks
PHP
0 vote158 views1 answer
Wampserver does not use, modify or require the PATH environment variable.
PHP
0 vote189 views2 answers
Str lower laravel
PHP Laravel
13 votes162 views6 answers
Named route with parameter laravel
PHP
0 vote241 views1 answer
Artisan laravel require bootstrap
PHP
0 vote161 views1 answer
File could not be downloaded: Unable to find the wrap per "https" - did you forget to enable it when you configured PHP? failed to open stream: No such file or directory
PHP
2 votes194 views2 answers
Echo query in laravel
PHP Laravel
16 votes211 views3 answers
Laravel make model along with its controller and migration file
PHP Laravel
0 vote181 views1 answer
\r in php
PHP
1 vote221 views1 answer
Definir una constante para llamar archivos en puglins de WordPress
PHP