/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 votes393 views6 answers
Print last query in codeigniter
PHP CodeIgniter
0 vote315 views1 answer
Current date in codeigniter
PHP CodeIgniter
0 vote294 views1 answer
Time zone set in codeigniter
PHP CodeIgniter
-1 vote307 views1 answer
Codeigniter 4 query builder select
PHP CodeIgniter
0 vote304 views1 answer
Codeigniter 4 radio button isset
PHP CodeIgniter
0 vote310 views1 answer
Access config variable in codeigniter controller
PHP CodeIgniter
0 vote301 views1 answer
Encryp with codeigniter 3
PHP CodeIgniter
3 votes364 views2 answers
Codeigniter validation text length
PHP CodeIgniter
8 votes393 views4 answers
Codeigniter redirect
PHP CodeIgniter
3 votes376 views4 answers
Codeigniter apache remove index.php
PHP CodeIgniter