/PHP/CodeIgniter/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 vote223 views1 answer
How to free session variable in php codeigniter
PHP CodeIgniter
1 vote210 views2 answers
Codeigniter query result
PHP CodeIgniter
0 vote227 views2 answers
How to set optional third parameter in routes of codeigniter
PHP CodeIgniter
0 vote223 views1 answer
Codeigniter 3 session not working after some time
PHP CodeIgniter
1 vote235 views1 answer
Check if input file is set codeigniter
PHP CodeIgniter
0 vote239 views1 answer
Date between query in codeigniter
PHP CodeIgniter
0 vote232 views1 answer
Codeigniter 3 Get future date recocords - upcoming records from database
PHP CodeIgniter
1 vote221 views4 answers
Codeigniter where_not_in
PHP CodeIgniter
0 vote211 views1 answer
Codeigniter order by random
PHP CodeIgniter
1 vote213 views2 answers
Print all session in codeigniter
PHP CodeIgniter