/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 vote218 views1 answer
Php fix array keys
PHP
1 vote208 views1 answer
HTML Snippets not working in .php files
PHP
16 votes196 views6 answers
How to get array key in php
PHP
0 vote234 views1 answer
Laravel permission spatie cache clear
PHP Laravel
0 vote235 views1 answer
Wordpress get post body
PHP Wordpress
4 votes205 views2 answers
Redirect back in codeigniter
PHP
1 vote204 views1 answer
Php for each schleife
PHP
1 vote234 views1 answer
Laravel test cases
PHP Laravel
27 votes210 views4 answers
Php key exists
PHP
0 vote221 views1 answer
Laravel validation on gropu route
PHP Laravel