/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 vote254 views1 answer
Search query codeigniter
PHP CodeIgniter
0 vote290 views1 answer
Upload image with watermark in codeigniter
PHP CodeIgniter
0 vote268 views1 answer
Codeigniter update query return value
PHP CodeIgniter
0 vote273 views1 answer
CODEIGNITER codeigniter 4 auth
PHP CodeIgniter
0 vote265 views5 answers
Codeigniter.com cart
PHP CodeIgniter
1 vote265 views2 answers
Codeigniter query result
PHP CodeIgniter
4 votes302 views2 answers
Redirect back in codeigniter
PHP CodeIgniter
1 vote270 views2 answers
Print all session in codeigniter
PHP CodeIgniter
1 vote287 views1 answer
Codeigniter where date interval
PHP CodeIgniter
0 vote251 views1 answer
Execute sql query codeigniter
PHP CodeIgniter