/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

0 vote290 views1 answer
Laravel schedule run
PHP Laravel
0 vote369 views2 answers
Create curl api request php with para
PHP
16 votes291 views4 answers
Get user ip in php
PHP
0 vote305 views4 answers
Join table laravel count
PHP
1 vote281 views1 answer
Php function exists
PHP
9 votes309 views5 answers
Sleep php
PHP
2 votes292 views2 answers
Wordpress show notice
PHP
0 vote272 views1 answer
Php mask credit card number
PHP
3 votes301 views1 answer
How to change add to cart button in wordpress
PHP
4 votes433 views5 answers
Removing index.php in codeigniter
PHP CodeIgniter