/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 votes173 views1 answer
Route
PHP
0 vote170 views1 answer
Laravel showing index of problem
PHP
19 votes242 views4 answers
Composer detected issues in your platform: Your Composer dependencies require a PHP version ">= 7.4.0".
PHP
150 votes554 views10 answers
Grepper
PHP
0 vote174 views1 answer
Lumen generate app key
PHP
1 vote233 views1 answer
Laravel-cors
PHP Laravel
3 votes178 views4 answers
Laravel cors enable
PHP
3 votes194 views3 answers
Laravel passport create access token
PHP Laravel
9 votes231 views4 answers
Laravel group route controller
PHP
16 votes187 views6 answers
Get first key of array php
PHP