/PHP/CodeIgniter/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 vote136 views3 answers
Base url dinamis codeigniter
PHP CodeIgniter
0 vote138 views1 answer
Codeigniter set db prefix
PHP CodeIgniter
0 vote148 views1 answer
Insert array values in database using codeigniter
PHP CodeIgniter
0 vote133 views1 answer
Codeigniter update or create
PHP CodeIgniter
0 vote132 views1 answer
Converting php to codeigniter
PHP CodeIgniter
-1 vote125 views1 answer
Codeigniter 4 query builder select
PHP CodeIgniter
0 vote136 views1 answer
How to free session variable in php codeigniter
PHP CodeIgniter
0 vote146 views1 answer
Group by codeigniter 3
PHP CodeIgniter
4 votes224 views2 answers
Redirect back in codeigniter
PHP CodeIgniter
0 vote130 views1 answer
Time zone set in codeigniter
PHP CodeIgniter