/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 vote228 views1 answer
Codeigniter sms send
PHP CodeIgniter
3 votes260 views3 answers
$this- db- where in codeigniter
PHP CodeIgniter
0 vote270 views1 answer
How to make core controller codeigniter 3 more than 1
PHP CodeIgniter
0 vote198 views1 answer
Login with email or username codeigniter 4
PHP CodeIgniter
0 vote249 views2 answers
Codeigniter 4 limit query
PHP CodeIgniter
-1 vote203 views1 answer
Codeigniter 4 query builder select
PHP CodeIgniter
8 votes265 views5 answers
Codeigniter 4 redirect with data
PHP CodeIgniter
0 vote221 views1 answer
Function id codeigniter 3
PHP CodeIgniter
0 vote222 views2 answers
How to insert last id from crud grocery codeigniter
PHP CodeIgniter
0 vote237 views2 answers
How to set optional third parameter in routes of codeigniter
PHP CodeIgniter