Monthly Archive: July 2017

How to create model in CodeIgnitor?

Hello Friends, Today we will discuss model creation in CodeIgnitor. First of all, we will create a model file in \ci\application\models\ folder. Suppose model file will be named as User_model.php and the class name will be User_model and after that create the constructor of the class who will be call the parent class constructor. Now We will create a method for deletion of the system user from the system_users table…
Read more

Frequently Asked MySQL Query based Interview Questions[Updated]

Question 1: How to find the second highest salary of an Employee? Answer:

Question 2: How to find duplicate records in the Employee Table? Answer:

Question 3: How to reverse the gender of each employee in a table? Answer: Suppose there is the table named users and its has columns id, first_name, last_name, gender So the SQL will be:

Question 4: How to count duplicate records in…
Read more

Command line tool(CLT) in Node.Js

Hello Friends, Today we will discuss how to create the command line tool using the Node.Js.

Optimization WordPress Plugins & Solutions by W3 EDGE