/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 votes238 views2 answers
Php get youtube code
PHP
0 vote220 views1 answer
Docker compose php
PHP
0 vote258 views1 answer
Laravel keep old input
PHP Laravel
0 vote267 views1 answer
Find the next 7 date data in laravel eloquent
PHP Laravel
18 votes232 views6 answers
Wherein laravel
PHP
0 vote239 views1 answer
Php array_diff_assoc
PHP
3 votes255 views1 answer
Wordpress base theme child url
PHP Wordpress
12 votes234 views5 answers
Php filter array
PHP
1 vote242 views2 answers
How to remove token while logout using laravel 8
PHP Laravel
0 vote226 views1 answer
Wordpress html classes
PHP