Latest Posts

NodeJS : Most Used Packages

Hi Friends, Here is the list for most commonly used NodeJS packages list those are frequently used: Express: A fast, unopinionated, minimalist web framework for Node. Express aims to provide small, robust tooling for HTTP servers, making it a great solution for single page applications, web sites, hybrids, or public HTTP APIs. Lodash: Lodash is a “toolbelt” utility library with methods for performing lots of common JavaScript tasks. It can…
Read more

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.

Post Views: 480

Linking to CSS, JS and Images in Laravel

For linking to the CSS, Javascript and images files, we need to install a package and package name is LavavelCollective. Open your system terminal and browse to the laravel project folder.

Package will be installed using the composer and we need to run below command on the terminal.

After run above command the package will be install into our laravel project. For verify that the package is installed…
Read more

MySQL Table Cache

MySQL Table Cache The table cache is used to stores objects that represent tables.Each object in the cache holds associated table’s parsed .frm Each object in the cache contains the associated table’s parsed .frm file, plus other data.Exactly what else is in the object depends on the table’s storage engine. For MyISAM, it holds the table data and/or index file descriptors.The table cache can help you reuse resources.For instance, when…
Read more

Install PHPUnit and run unit test cases

Hello Guys, Today we will discuss the PHPUnit and try to make a program to perform unit testing using PHP Language. PHPUnit is complete unit testing framework written in the PHP Programming Language and was written by Sebastian Bergmann. It allows to PHP programmers to perform unit testing and practice test driven Development(TDD). For installation of the PHPUnit on Linux based system like on Ubuntu, I used following steps

Read more

Linux Shell Scripting for Virtual hosting

Hello Guys, Today we will discuss the shell script code for Apache Virtual Hosting. Actually, I was working on the different multiple applications to install on my local server and every time I need to execute all the commands and sometimes I forgot to execute some commands or forgot the process So I plan to create a shell script for this and I had written this code.

Now We…
Read more

What are PSR Standards ?

Hi Guys, The PHP Standard Recommendation (PSR) is a PHP specification published by the PHP Framework Interop Group.The aim is to enable interoperability of components and to provide a common technical basis for an implementation of proven concepts for optimal programming and testing practices. The PHP-FIG is formed by several PHP frameworks founders. Number Name Description Status PSR-0 Basic Coding Standard It describes the mandatory requirements that must be adhered…
Read more

MySQL Slow Query Logging

Hello Guys, Today we will discuss on monitoring slow MySQL queries logging that is the important point comes under database design. Here are the following steps Step 1: First of all, we need to open the Linux terminal and then log in on the MySQL prompt using the following command:

After hit Enter, It will ask for the root user password. After entering the correct password it will open…
Read more

Optimization WordPress Plugins & Solutions by W3 EDGE