/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 vote341 views1 answer
Str_replace smarty template
PHP
4 votes323 views4 answers
Laravel 8 carbon if date is today
PHP Laravel
50 votes266 views6 answers
Left join laravel
PHP
0 vote322 views1 answer
How to display the taxonomy image in wordpress
PHP Wordpress
0 vote274 views1 answer
Mac brew install php redis
PHP
0 vote315 views1 answer
Tinyinteger laravel +size
PHP Laravel
2 votes259 views1 answer
Php modules list ubuntu
PHP
2 votes288 views2 answers
Php store log in a text file
PHP
0 vote308 views1 answer
Diffforhumans laravel
PHP Laravel
100 votes358 views6 answers
Php substr_replace
PHP