/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 vote181 views1 answer
Wp add_action
PHP Wordpress
0 vote186 views2 answers
Laravel create event listener
PHP Laravel
0 vote172 views1 answer
Generate unique order id in php
PHP
0 vote153 views1 answer
Laravel response download video laravel medialibrary
PHP
0 vote146 views1 answer
Get git branch by php
PHP
1 vote158 views1 answer
Query sort alphabetically wp
PHP
1 vote150 views1 answer
Laravel update method resource
PHP Laravel
25 votes144 views4 answers
ERROR 1071 (42000) at line 76: Specified key was too long; max key length is 767 bytes laravel
PHP
4 votes221 views4 answers
Nginx codeigniter remove index.php
PHP CodeIgniter
46 votes148 views6 answers
For in php
PHP