/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

104 votes585 views6 answers
Array_push in php
PHP
1 vote187 views1 answer
Create customer by stripe in php
PHP
0 vote172 views1 answer
Symfony session
PHP
0 vote195 views4 answers
Form::select laravel
PHP
0 vote190 views2 answers
Option value selected in laravel blade
PHP
1 vote187 views1 answer
Firebase jwt php verify
PHP
0 vote193 views1 answer
Phpunit bridge vs phpunit
PHP
16 votes284 views5 answers
Laravel one command for model table and controller
PHP
0 vote175 views1 answer
Format a number with leading zeros in php
PHP
6 votes203 views1 answer
Extract($user_input); alternative php
PHP