/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

3 votes357 views3 answers
How to get last id in database codeigniter 4
PHP CodeIgniter
0 vote302 views1 answer
Execute sql query codeigniter
PHP CodeIgniter
8 votes402 views4 answers
Codeigniter redirect
PHP CodeIgniter
0 vote336 views1 answer
Codeigniter crud generator
PHP CodeIgniter
1 vote317 views1 answer
Codeigniter distinct
PHP CodeIgniter
0 vote331 views1 answer
Update Query in Codeigniter Using Multiple Where Condition
PHP CodeIgniter
2 votes340 views1 answer
How to use multiple where condition in codeigniter
PHP CodeIgniter
0 vote336 views2 answers
Load session in codeigniter
PHP CodeIgniter
0 vote332 views2 answers
Php codeigniter unit testing
PHP CodeIgniter
0 vote318 views1 answer
Access config variable in codeigniter controller
PHP CodeIgniter