/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 vote183 views1 answer
Codeigniter 4 query builder get inserted id
PHP CodeIgniter
0 vote178 views1 answer
Confirm password in codeigniter
PHP CodeIgniter
0 vote187 views1 answer
Codeigniter order by random
PHP CodeIgniter
0 vote172 views1 answer
Destroy session codeigniter 3
PHP CodeIgniter
0 vote200 views1 answer
Codeigniter 3 session not working after some time
PHP CodeIgniter
8 votes228 views4 answers
Codeigniter redirect
PHP CodeIgniter
0 vote193 views1 answer
Update Query in Codeigniter Using Multiple Where Condition
PHP CodeIgniter
0 vote180 views1 answer
Delete Query with Where Condition in Codeigniter
PHP CodeIgniter
2 votes180 views1 answer
Merubah judul menjadi slug codeigniter
PHP CodeIgniter
-1 vote180 views1 answer
Codeigniter get num_rows
PHP CodeIgniter