$this->db->select('*'); // Select field $this->db->from('package'); // from Table1 $this->db->join('pcategory', 'package.pcategory = pcategory.id', 'INNER'); // Join table1 with table2 based on the foreign key $data['Package'] = $this->db->get(); $this->load->view('Admin/viewpackage.php', $data);
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter