/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 vote187 views1 answer
How to update a table based on three columns laravel
PHP Laravel
1 vote185 views1 answer
DB::connection('local')->create() laravel
PHP Laravel
1 vote215 views2 answers
Redirect::route('profile') and with() in laravel
PHP Laravel
0 vote176 views1 answer
Wordrpess debugg is off but still showing
PHP
1 vote170 views1 answer
Create customer by stripe in php
PHP
10 votes206 views6 answers
Format time laravel
PHP Laravel
0 vote183 views1 answer
Acf get user form field
PHP
0 vote168 views1 answer
Gate::before not working laravel 8
PHP
1 vote167 views2 answers
How to remove duplicate values from a multidimensional array in php
PHP
0 vote161 views1 answer
Hide all updates from WordPress
PHP