/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

2 votes185 views2 answers
Get relationship data from soft delete laravel
PHP Laravel
0 vote208 views1 answer
How can get attribute without getter in laravel
PHP Laravel
-1 vote158 views1 answer
Pdf to image php
PHP
11 votes170 views6 answers
Laravel route
PHP
0 vote177 views1 answer
Blocking youtube adds in php
PHP
26 votes174 views6 answers
$session php
PHP
0 vote190 views1 answer
Laravel create project with auth 2021
PHP Laravel
0 vote186 views1 answer
Exclude row from clooection laravel
PHP Laravel
23 votes183 views6 answers
Laravel validation messages
PHP Laravel
5 votes178 views6 answers
Laravel 8 auth
PHP Laravel