/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

8 votes325 views5 answers
Codeigniter 4 redirect with data
PHP CodeIgniter
0 vote277 views2 answers
Codeigniter 4 limit query
PHP CodeIgniter
0 vote219 views1 answer
Codeigniter sms send
PHP CodeIgniter
0 vote225 views1 answer
Codeigniter how to know update failed
PHP CodeIgniter
2 votes258 views2 answers
How to check php version codeigniter 3
PHP CodeIgniter
0 vote185 views1 answer
Single row in codeigniter
PHP CodeIgniter
0 vote240 views5 answers
Codeigniter.com cart
PHP CodeIgniter
0 vote304 views1 answer
Codeigniter abort 404
PHP CodeIgniter
0 vote238 views1 answer
Codeigniter 4 query builder get inserted id
PHP CodeIgniter
0 vote267 views2 answers
Multiple image upload with CodeIgniter
PHP CodeIgniter