/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 vote107 views1 answer
Logout from all the devices in the jwt api laravel
PHP
0 vote117 views1 answer
How to wirte laravel dd function in php
PHP Laravel
0 vote97 views3 answers
Laravel 7 pagination with search filter
PHP
-1 vote57 views1 answer
Strcasecmp in php
PHP
0 vote93 views1 answer
Get chmod of directory php
PHP
0 vote133 views1 answer
Wordpress user enumeration
PHP Wordpress
0 vote104 views1 answer
Laravel latest from relationship
PHP
0 vote104 views2 answers
Get post title by post id wordpress
PHP Wordpress
34 votes91 views6 answers
Json to array php
PHP
0 vote101 views1 answer
Php get highest key value
PHP