/PHP/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 vote170 views1 answer
Php xdebug docker
PHP
0 vote154 views1 answer
Php inline if condition date time
PHP
1 vote180 views1 answer
Laravel routing controller get and post method
PHP
0 vote168 views1 answer
Optimistic Locking Laravel
PHP
9 votes136 views3 answers
Laravel validation image or file
PHP
1 vote138 views1 answer
Calculate person age by birthdate php
PHP
2 votes142 views1 answer
Php routing
PHP
0 vote136 views6 answers
Php email
PHP
9 votes203 views3 answers
Laravel enum migration
PHP
1 vote160 views1 answer
Fluid inline if
PHP