/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

0 vote191 views6 answers
Update codeigniter
PHP CodeIgniter
2 votes222 views3 answers
Codeigniter last insert id
PHP CodeIgniter
3 votes236 views1 answer
Codeigniter form_validation email
PHP CodeIgniter
8 votes294 views5 answers
Redirect in codeigniter
PHP CodeIgniter
1 vote158 views3 answers
Codeigniter 4 builder last query
PHP CodeIgniter
0 vote239 views1 answer
Access config variable in codeigniter controller
PHP CodeIgniter
8 votes275 views5 answers
Codeigniter 4 redirect with data
PHP CodeIgniter
0 vote200 views1 answer
Converting php to codeigniter
PHP CodeIgniter
0 vote194 views1 answer
How to create routes in the codeigniter
PHP CodeIgniter
4 votes290 views5 answers
Removing index.php in codeigniter
PHP CodeIgniter