/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 vote406 views1 answer
Example code codeigniter seeders
PHP CodeIgniter
8 votes490 views5 answers
Redirect in codeigniter
PHP CodeIgniter
0 vote395 views1 answer
Pagination in codeigniter with example
PHP CodeIgniter
0 vote384 views1 answer
Creating thumbnail in codeigniter
PHP CodeIgniter
0 vote381 views1 answer
Codeigniter get parameter from url
PHP CodeIgniter
1 vote383 views2 answers
Codeigniter query result
PHP CodeIgniter
0 vote420 views1 answer
Codeigniter update or create
PHP CodeIgniter
4 votes470 views5 answers
Removing index.php in codeigniter
PHP CodeIgniter
0 vote370 views1 answer
Codeigniter 4 query builder get inserted id
PHP CodeIgniter
0 vote403 views2 answers
Codeigniter 4 get method deprecated
PHP CodeIgniter