/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 vote142 views1 answer
Update session laravel
PHP
0 vote152 views1 answer
Laravel validation unique if this field is changed
PHP
0 vote141 views1 answer
Php bin/console debug events
PHP
0 vote138 views1 answer
Php refresh_ttl
PHP
-1 vote137 views1 answer
Laravel seo
PHP
0 vote173 views1 answer
Laravel get previous route without domain
PHP
7 votes177 views3 answers
Carbon get today's month
PHP
2 votes152 views3 answers
Laravel get input from request
PHP
0 vote158 views1 answer
Setup phpmyadmin to show create statement query
PHP
1 vote141 views1 answer
None of the supported PHP extensions (PgSQL, PDO_PgSQL) are available.
PHP