/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

4 votes235 views5 answers
Removing index.php in codeigniter
PHP CodeIgniter
0 vote153 views1 answer
How to save snap in webcap in php codeigniter
PHP CodeIgniter
0 vote165 views1 answer
Database interaction in codeigniter
PHP CodeIgniter
7 votes226 views5 answers
Codeigniter count rows
PHP CodeIgniter
0 vote160 views1 answer
Get upload error codeigniter
PHP CodeIgniter
2 votes106 views1 answer
Order by in codeigniter
PHP CodeIgniter
1 vote151 views1 answer
Codeigniter distinct
PHP CodeIgniter
0 vote167 views1 answer
Codeigniter form validation datetime
PHP CodeIgniter
0 vote158 views1 answer
How to free session variable in php codeigniter
PHP CodeIgniter
0 vote148 views1 answer
Destroy session codeigniter 3
PHP CodeIgniter