/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 vote279 views1 answer
Convert post name to id
PHP
0 vote200 views1 answer
Laravel get week dates
PHP
0 vote205 views1 answer
Set null on foreign key deletion in laravel
PHP
1 vote210 views1 answer
Get age with carbon in laravel
PHP
17 votes288 views3 answers
Laravel make model controller and migration one time
PHP Laravel
0 vote258 views1 answer
Take and skip in laravel
PHP Laravel
2 votes204 views1 answer
Append new line php
PHP
4 votes215 views1 answer
Remove index.php
PHP
0 vote181 views1 answer
Delete previous image from folder when updated by new image in laravel
PHP
1 vote237 views1 answer
Php subtract mins to datetime
PHP