/PHP/CodeIgniter/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

5 votes238 views3 answers
Get result count codeigniter
PHP CodeIgniter
0 vote170 views1 answer
How to make core controller codeigniter 3 more than 1
PHP CodeIgniter
0 vote164 views1 answer
Codeigniter form open
PHP CodeIgniter
0 vote174 views1 answer
Codeigniter form validation datetime
PHP CodeIgniter
0 vote184 views1 answer
Insert array values in database using codeigniter
PHP CodeIgniter
8 votes227 views4 answers
Codeigniter 4 redirect to home
PHP CodeIgniter
-2 votes153 views1 answer
Codeigniter select for update
PHP CodeIgniter
8 votes250 views5 answers
Redirect in codeigniter
PHP CodeIgniter
0 vote157 views1 answer
Codeigniter get parameter from url
PHP CodeIgniter
3 votes254 views2 answers
Index.php in codeigniter
PHP CodeIgniter