/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

0 vote131 views1 answer
Php artisan spark not working in codeigniter
PHP CodeIgniter
1 vote82 views3 answers
Codeigniter 4 builder last query
PHP CodeIgniter
0 vote131 views1 answer
Codeigniter crud generator
PHP CodeIgniter
2 votes86 views1 answer
Order by in codeigniter
PHP CodeIgniter
2 votes144 views2 answers
Last insert id model codeigniter
PHP CodeIgniter
4 votes159 views6 answers
How to remove index.php in codeigniter
PHP CodeIgniter
0 vote137 views1 answer
Rand in codeigniter
PHP CodeIgniter
0 vote137 views1 answer
Codeigniter set db prefix
PHP CodeIgniter
0 vote135 views1 answer
Codeigniter update or create
PHP CodeIgniter
2 votes128 views1 answer
How to use multiple where condition in codeigniter
PHP CodeIgniter