Codeigniter (CI) Table Join

 

 

$this->db->select('users.usrID, users_profiles.usrpID')
         ->from('users')
         ->join('users_profiles', 'users.usrID = users_profiles.usrpID');
$result = $this->db->get();

Comments

Post a Comment

Popular posts from this blog

Frequently asked: Vue.JS Interview Questions and Answers

Image
  Q1. What is Vue.js? What are the advantages of it? Vue is a progressive framework used to building user interfaces.The core library is focused on the view layer only, and is easy to pick up and integrate with other libraries or existing projects. Following are the advantages of using Vue.js. Small in size — The size of this framework is 18 to 21KB and it takes no time for the user to download and use it. Easy to Understand — One of the reasons for the popularity of this framework is that it is quite easy to understand. The user can easily add Vue.js to his web project because of its simple structure. Simple Integration — Vue.js can be integrated with the existing applications easily. Flexibility — This flexibility also makes it easy to understand for the developers of React.js, Angular.js, and any other new JavaScript framework. Virtual DOM — It uses virtual DOM similar to other existing frameworks such as ReactJS, Ember etc. Virtual DOM is a light-weight in-memory tre...
Read more

Base URL Setting in Codeigniter

Copy below code and paste inside the config.php file in Codeigniter . You will get this file in Application/Config/config.php  $config['base_url'] = $config['base_url'] = ((isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == "on") ?  "https" : "http")."://".$_SERVER['HTTP_HOST'].str_replace(basename($_SERVER['SCRIPT_NAME']),"",$_SERVER['SCRIPT_NAME']);
Read more

How To Secure Apache with Let's Encrypt on Ubuntu (Digital Ocean)

Image
  Introduction This tutorial will show you how to set up a TLS/SSL certificate from Let’s Encrypt on an Ubuntu 16.04 server running Apache as a web server. SSL certificates are used within web servers to encrypt the traffic between the server and client, providing extra security for users accessing your application. Let’s Encrypt provides an easy way to obtain and install trusted certificates for free. Prerequisites In order to complete this guide, you will need: An Ubuntu 16.04 server with a non-root sudo-enabled user, which you can set up by following our Initial Server Setup guide The Apache web server installed with one or more domain names properly configured through Virtual Hosts that specify ServerName . When you are ready to move on, log into your server using your sudo-enabled account. Step 1 — Install the Let’s Encrypt Client Let’s Encrypt certificates are fetched via client software running on your server. The official client is called Certbot, and i...
Read more