/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

2 votes193 views4 answers
Require_once php
PHP
0 vote221 views3 answers
Laravel 7 upload file s3
PHP Laravel
1 vote219 views1 answer
Clear cache using laravel controller
PHP Laravel
39 votes196 views6 answers
Create table laravel
PHP Laravel
20 votes202 views6 answers
Array random php
PHP
6 votes220 views4 answers
Get featured image id wordpress
PHP Wordpress
0 vote248 views1 answer
2 days left format in laravel
PHP Laravel
5 votes199 views1 answer
Php get age from dob
PHP
7 votes187 views2 answers
Laravel ui
PHP Laravel
0 vote178 views1 answer
Payment gateway webhook returning 302 laravel
PHP