/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

7 votes311 views6 answers
Set session in laravel
PHP
3 votes315 views3 answers
Php stdclass to array
PHP
1 vote328 views1 answer
Php array in cookie
PHP
1 vote326 views1 answer
Php subtract mins to datetime
PHP
2 votes330 views2 answers
Laravel dropIndex
PHP Laravel
0 vote364 views1 answer
Change request value laravel
PHP Laravel
0 vote302 views1 answer
Wordpress add block from single.php
PHP
0 vote323 views1 answer
Prevent re submit form
PHP
7 votes365 views3 answers
Laravel random query
PHP
0 vote296 views1 answer
Php connection mysqli database
PHP