/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

7 votes215 views5 answers
Codeigniter get last query
PHP CodeIgniter
0 vote175 views1 answer
Upload image with watermark in codeigniter
PHP CodeIgniter
2 votes174 views3 answers
Codeigniter last insert id
PHP CodeIgniter
0 vote125 views1 answer
How to write orderby in join query with where clause in codeigniter
PHP CodeIgniter
0 vote152 views1 answer
Access config variable in codeigniter controller
PHP CodeIgniter
0 vote153 views1 answer
Codeigniter 4 radio button isset
PHP CodeIgniter
4 votes233 views4 answers
Nginx codeigniter remove index.php
PHP CodeIgniter
4 votes225 views5 answers
Removing index.php in codeigniter
PHP CodeIgniter
-2 votes144 views3 answers
Inner join codeigniter
PHP CodeIgniter
0 vote133 views1 answer
Codeigniter crud generator
PHP CodeIgniter