/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 vote114 views1 answer
Ipv6 pregmatch
PHP
2 votes170 views1 answer
Cookies php syntax
PHP
0 vote147 views1 answer
Import separate graphql file laravel
PHP
2 votes190 views2 answers
Php unique id
PHP
-2 votes175 views4 answers
Codeigniter 3 update
PHP CodeIgniter
12 votes151 views3 answers
Carbon in laravel documentation
PHP Laravel
15 votes200 views6 answers
Transaction laravel
PHP
0 vote165 views2 answers
Laravel rename file ftp
PHP Laravel
1 vote144 views1 answer
Convert php array to javascript json laravel
PHP
1 vote174 views1 answer
Laravel group by created_at date only
PHP Laravel