MySQL views

MySQL has supported database views since version 5.x. Views are pretty useful if you want to refer to values calculated from expressions without writing the expressions each time you can retrieve them. What is a view A […]

How to filter a PHP array by key?

PHP array_intersect_key() function returns an array containing all the entries of primary array which have keys that are preset in all the arguments. This function computes the intersection of arrays using keys for comparison. […]

How to connect to MySQL from the command line

The MySQL database is one of the well know database engine, which uses a client-server architecture. The server, mysqld is the program that actually manipulate the database. In order to talk to server, we use a client […]

File uploads in express js 4

In this tutorial you will learn how to upload files on remote server using node js in your express js application. You can upload any kind of file like images, videos, ZIP files, Microsoft Office documents, PDFs, as well […]

Design pattern – Chain of Responsibility

Design patterns are very general/non specific reusable solutions or templates to solve a specific design problems in software design. Which defines how the specific classes or code blocks can interact or relate to each […]

Encrypt and Decrypt files using PHP

In my recent project I have implemented PDF file encryption and decryption. In this project, data is very sensitive so to protect files from unauthorized access and to keep them safe and secure we have used file based […]

How to Connect to MySQL Database from Node.Js

In this article you will learn how to connect to MySQL server database using Node Js MySQL driver. We gonna use a MySQL driver called “mysql”. It is written in JavaScript, does not require compiling, and is […]

Create REST API with the Laravel 5.3

This tutorial provides an example of building a complete RESTful API using Laravel 5.3.* Framework. You gonna use the different HTTP methods during the REST api development, quick introduction about each method. GET to […]

DomPDF Library using Codeigniter 3

In this tutorial we will discus about how to generate PDF using DOMPDF with Codeigniter Framework version 3 and composer(PHP dependency manager). From the authors of Dompdf – Dompdf is an HTML to PDF converter. At […]

Send Email using G-Mail SMTP in Express/Node.js

In this arti­cle, I will demon­strate a sim­ple exam­ple of send­ing emails using G-Mail SMTP in Express/ Node.js. fortunately sending emails in express/node js pretty easy, in node.js there are many open source email […]

MySQL Sub Queries

I this post I would like to write about sub queries. A Sub-query is also a query, which is defined under a main query and embedded within the WHERE clause . It always sends a value to its nearest main query. Sub-query […]

Serving static files with Node JS

During the front-end development to serve static files such as images, CSS files, and JavaScript files you require the web servers. and as of now you used Apache or Nginx etc servers to server files. Installing HTTP servers […]

JavaScript Promise API

Promises can replace the asynchronous use of callbacks, and they provide several benefits over them. Basic Promise Usage A new Promise is created with the new Promise() constructor and the promise provides resolve and […]