/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 vote120 views1 answer
Group by not working - Laravel
PHP Laravel
16 votes123 views3 answers
Laravel request validate
PHP Laravel
2 votes73 views2 answers
Php regex replace accented characters
PHP
0 vote118 views1 answer
Wordpress - php settings
PHP Wordpress
0 vote164 views1 answer
Supprimer automatiquement les mots courts des URL pour un meilleur SEO dans WordPress
PHP
24 votes183 views4 answers
Clear cache command in laravel controller
PHP Laravel
0 vote119 views1 answer
Php set timezone italy
PHP
1 vote141 views1 answer
Laravel add (s) at the end of text based on how many data
PHP
1 vote182 views1 answer
?? ' ' operator in php laravel
PHP Laravel
0 vote127 views2 answers
Php decrement variable
PHP