/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

1 vote144 views2 answers
Laravel observer get old value
PHP
1 vote159 views1 answer
Laravel api form request validation 404
PHP Laravel
0 vote118 views1 answer
Where date laravel
PHP
0 vote149 views2 answers
Laravel collection keys
PHP Laravel
0 vote125 views3 answers
Passing data from controller to blade view laravel
PHP Laravel
16 votes120 views5 answers
Php compare two dates
PHP
1 vote129 views1 answer
Boolean value switch/invert
PHP
2 votes123 views3 answers
Laravel check if field has changed
PHP
1 vote108 views2 answers
Get current term id
PHP
2 votes105 views1 answer
Ext-dom * -> it is missing from your system
PHP