/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 vote159 views3 answers
Delete a migration laravel
PHP Laravel
0 vote135 views1 answer
Phph call functions from other .php file
PHP
3 votes139 views1 answer
You may need an appropriate loader to handle this file type, currently no loaders are configured to process this file laravel
PHP
3 votes123 views1 answer
Wordpress base theme child url
PHP
12 votes131 views4 answers
Give custom field name in laravel form validation error message
PHP
2 votes131 views2 answers
Array_chunk in php
PHP
0 vote172 views1 answer
Laravel old value not working in textarea
PHP Laravel
24 votes129 views4 answers
Php typeof
PHP
0 vote123 views1 answer
How to change laravel logo image
PHP
0 vote140 views2 answers
Loop foreach laravel with number
PHP