/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 votes328 views3 answers
Get result count codeigniter
PHP CodeIgniter
8 votes317 views6 answers
Codeigniter 4 get last query
PHP CodeIgniter
-1 vote215 views1 answer
Codeigniter 4 query builder select
PHP CodeIgniter
2 votes238 views2 answers
Route codeigniter
PHP CodeIgniter
0 vote222 views1 answer
Codeigniter 4 radio button isset
PHP CodeIgniter
0 vote218 views1 answer
Codeigniter remote queries very slow
PHP CodeIgniter
0 vote252 views1 answer
Upload image with watermark in codeigniter
PHP CodeIgniter
4 votes319 views4 answers
Nginx codeigniter remove index.php
PHP CodeIgniter
0 vote282 views1 answer
Codeigniter abort 404
PHP CodeIgniter
1 vote245 views1 answer
Codeigniter 3 Configured database connection has cache enabled
PHP CodeIgniter