/PHP/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 vote250 views1 answer
Php decode stdclass object
PHP
0 vote257 views1 answer
Symfony\Component\HttpKernel\Exception\NotFoundHttpException: POST http://localhost/post
PHP
0 vote244 views2 answers
Format datetime ISO php
PHP
3 votes205 views1 answer
Laravel go back
PHP
12 votes255 views6 answers
Php array remove empty values
PHP
9 votes262 views1 answer
Order By Asc in laravbel
PHP
1 vote306 views1 answer
Laravel validateexception no error description
PHP Laravel
0 vote240 views1 answer
Failed to authenticate on SMTP server with username
PHP
0 vote273 views1 answer
Call to undefined function App\Models\str_slug()
PHP
0 vote275 views1 answer
__dir__ in php
PHP