/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

1 vote145 views1 answer
Php install xdebug mac
PHP
0 vote212 views1 answer
Raw query in laravel with parameters
PHP
0 vote140 views1 answer
Session_regenerate_id
PHP
0 vote158 views1 answer
Nginx phpmyadmin subdirectory
PHP
0 vote131 views1 answer
How to loop array in laravel
PHP
0 vote186 views1 answer
Laravel compare request domain and app domain and request original domain
PHP
95 votes105 views9 answers
String to int php
PHP
0 vote146 views1 answer
Query builder laravel getmedia undefined method
PHP
0 vote154 views3 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table many to many in laravel
PHP Laravel
0 vote132 views1 answer
Laravel request protected prop
PHP