/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

7 votes273 views5 answers
Wordpress get post by id
PHP Wordpress
0 vote248 views1 answer
Git pull using php
PHP
8 votes235 views6 answers
Trim php
PHP
0 vote264 views1 answer
Wordpress 404 page after migration
PHP Wordpress
0 vote243 views1 answer
How to see with page reuested in laravel
PHP
1 vote301 views3 answers
Import faker in laravel
PHP Laravel
4 votes216 views2 answers
Php die
PHP
1 vote243 views1 answer
Remove all post in wordpress by query
PHP
3 votes237 views1 answer
Execute function php
PHP
2 votes277 views2 answers
Php unique id
PHP