/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 vote314 views2 answers
Get email with preg grep php
PHP
0 vote302 views1 answer
Add action hook
PHP
6 votes320 views3 answers
Current time in laravel migration
PHP
0 vote334 views1 answer
Ciclo for PHP ejemplos
PHP
0 vote329 views1 answer
Find the next 7 date data in laravel eloquent
PHP
0 vote306 views1 answer
Custom error page htaccess
PHP
101 votes375 views6 answers
Php str replace
PHP
-1 vote284 views1 answer
Ziparchive laravel not found
PHP
0 vote374 views1 answer
Wp wc php use comma separated thousands
PHP Wordpress
2 votes350 views1 answer
You can also run `php --ini` in a terminal to see which files are used by PHP in CLI mode. Alternatively, you can run Composer with `--ignore-platform-req=ext-mb
PHP