/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

6 votes159 views3 answers
Limit laravel
PHP Laravel
0 vote195 views2 answers
Php get last digit of number
PHP
1 vote115 views1 answer
Autoload file in laravel
PHP
0 vote117 views1 answer
Php throw fatal error
PHP
1 vote124 views1 answer
Create and download text file in php
PHP
0 vote144 views2 answers
Upload video in laravel
PHP Laravel
0 vote171 views1 answer
Laravel migrate patth
PHP
1 vote127 views1 answer
Php begin tag
PHP
1 vote254 views1 answer
DB::connection('local')->create() laravel
PHP
0 vote191 views1 answer
Laravel change string to text
PHP