/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 vote353 views1 answer
Codeigniter order by random
PHP CodeIgniter
8 votes396 views5 answers
Codeigniter 4 redirect with data
PHP CodeIgniter
0 vote336 views1 answer
Codeigniter select where
PHP CodeIgniter
7 votes368 views5 answers
Codeigniter count rows
PHP CodeIgniter
0 vote324 views1 answer
Codeigniter get parameter from url
PHP CodeIgniter
0 vote406 views1 answer
Group by codeigniter 3
PHP CodeIgniter
0 vote347 views1 answer
Update Query in Codeigniter Using Multiple Where Condition
PHP CodeIgniter
4 votes393 views4 answers
Nginx codeigniter remove index.php
PHP CodeIgniter
0 vote352 views1 answer
How to free session variable in php codeigniter
PHP CodeIgniter
0 vote346 views1 answer
Codeigniter form validation datetime
PHP CodeIgniter