/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 vote285 views1 answer
Install php 5.5.9 ubuntu 18.04
PHP
0 vote326 views1 answer
* * * * * cd /path-to-your-project && php artisan schedule:run >> /dev/null 2>&1
PHP
0 vote325 views1 answer
Pegar parte da string php
PHP
0 vote369 views1 answer
What is type-hinting in php
PHP
0 vote324 views1 answer
Php unix socket client
PHP
0 vote397 views1 answer
Comment supprimer les éléments liés à WordPress oEmbed
PHP
13 votes314 views5 answers
Remove empty array elements php
PHP
1 vote318 views2 answers
Laravel 8 seeding
PHP
0 vote301 views3 answers
Not Found The requested URL was not found on this server. Apache/2.4.48 (Win64) OpenSSL/1.1.1k PHP/8.0.8 Server at localhost Port 80
PHP
0 vote359 views1 answer
Php disable buutton
PHP