/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 vote173 views1 answer
WithCount laravel assign generic name
PHP
0 vote211 views1 answer
Laravel exclude field
PHP Laravel
1 vote184 views3 answers
Laravel 6 orderby
PHP
1 vote231 views1 answer
Boot method laravel life cycle
PHP Laravel
6 votes190 views2 answers
Php server function
PHP
1 vote169 views1 answer
Deprcation problem phpmyadmin ubuntu
PHP
3 votes184 views2 answers
Php foreach json object
PHP
1 vote208 views1 answer
Print value in laravel console
PHP Laravel
0 vote224 views2 answers
Loop variable in laravel
PHP Laravel
0 vote252 views1 answer
Laravel A row must be an array or a TableSeparator instance.
PHP Laravel