/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 vote325 views1 answer
Protocals supported by php
PHP
1 vote352 views1 answer
Php get all elements of array except last
PHP
2 votes347 views2 answers
Link to another page php
PHP
0 vote340 views1 answer
Wp functions ajax get
PHP
0 vote309 views1 answer
Laravel get all tables
PHP
-1 vote370 views2 answers
Restart php windows
PHP
0 vote353 views7 answers
Laravel eloquent tricks
PHP
12 votes336 views6 answers
Php array remove empty values
PHP
0 vote333 views1 answer
Laravel get relation camelcase api
PHP
0 vote337 views2 answers
How to get just the first row from a table in laravel
PHP