/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

6 votes121 views3 answers
Install php7.4 in linux server
PHP
4 votes136 views1 answer
Composer is operating significantly slower than normal because you do not have the PHP curl extension enabled
PHP
3 votes142 views4 answers
Get base url in wordpress
PHP Wordpress
0 vote130 views1 answer
String put inside tag string php
PHP
0 vote112 views1 answer
Php get current url without filename
PHP
0 vote122 views2 answers
Laravel download file from s3
PHP
3 votes170 views2 answers
Laravel validate telephone number
PHP
0 vote142 views1 answer
Laravel session has message
PHP Laravel
0 vote149 views1 answer
Laravel migration type to store html
PHP Laravel
1 vote127 views3 answers
Unique check two clolumn in laravel validation
PHP