/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

-2 votes259 views1 answer
Codeigniter select for update
PHP CodeIgniter
0 vote226 views1 answer
CODEIGNITER codeigniter 4 auth
PHP CodeIgniter
51 votes260 views2 answers
Display errors in codeigniter
PHP CodeIgniter
0 vote233 views1 answer
Php artisan spark not working in codeigniter
PHP CodeIgniter
0 vote232 views1 answer
Codeigniter abort 404
PHP CodeIgniter
3 votes270 views2 answers
Index.php in codeigniter
PHP CodeIgniter
0 vote227 views5 answers
Codeigniter.com cart
PHP CodeIgniter
0 vote227 views1 answer
How to save snap in webcap in php codeigniter
PHP CodeIgniter
0 vote226 views1 answer
Codeigniter 4 query builder get inserted id
PHP CodeIgniter
0 vote247 views1 answer
Codeigniter crud generator
PHP CodeIgniter