/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 vote149 views1 answer
Php show number 4 digit
PHP
5 votes161 views3 answers
Get users of specific role laravel role spatie
PHP
8 votes182 views4 answers
Laravel set date format
PHP Laravel
0 vote141 views1 answer
Cpanel composer update kill
PHP
0 vote153 views1 answer
Php range from one
PHP
0 vote151 views1 answer
Failed to authenticate on SMTP server with username
PHP
2 votes236 views3 answers
Laravel csrf-token in view
PHP
-1 vote159 views2 answers
Remove double space php
PHP
0 vote159 views1 answer
Only get selected value from has many ralation laravel
PHP
18 votes202 views6 answers
String to datetime php
PHP