/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 vote429 views1 answer
Codeigniter order by random
PHP CodeIgniter
0 vote422 views1 answer
Codeigniter crud generator
PHP CodeIgniter
0 vote411 views2 answers
Php codeigniter unit testing
PHP CodeIgniter
0 vote409 views1 answer
Codeigniter abort 404
PHP CodeIgniter
0 vote444 views1 answer
Codeigniter form validation datetime
PHP CodeIgniter
-1 vote412 views3 answers
Codeigniter pagination example
PHP CodeIgniter
0 vote377 views1 answer
Codeigniter get user ip
PHP CodeIgniter
1 vote412 views1 answer
Example code codeigniter seeders
PHP CodeIgniter
0 vote393 views1 answer
Current date in codeigniter
PHP CodeIgniter
4 votes462 views5 answers
Codeigniter base_url
PHP CodeIgniter