JavaScript

Join without foreign key constraint in Sequelize

Published on August 10, 2019 in JavaScript

Sequelize is a great ORM for Express which supports not just MySQL but also PostgreSQL and SQLite. Just like any other ORM, to perform JOIN queries using models you need to first define an association between the two tables (models). This association can be hasOne, hasMany, belongsTo and so on. Now this becomes tricky if […]

Sagilo - Free Online Project Management tool for software developers

Still using Excel and Word to manage your projects? Switch to Sagilo; a free online app that will allow your team to collaborate, plan and deliver efficiently. Register for free. No credit cards required.

Visit Now

WordPress on localhost asking Ftp details while downloading plugins from Dashboard

Published on December 22, 2014 in Wordpress

Many times while on your local server you may have faced this issue. You try downloading and installing a plugin through the Dashboard. Then all of a sudden a screen comes that asks for FTP credentials. If you usually manually extract the plugins zip file in the plugins folder then probably you must have never […]

Read Now

Login with Google Account using PHP

Published on April 11, 2019 in Php

In this article we’ll learn how you can let your app users login with Google Account into your PHP web application using Google PHP Client version 2. It’s assumed that you have already installed composer and are using a version of PHP greater than 5.4. To view the entire code please visit this gist. Create […]

Read Now

Enable virtual hosts with self signed SSL on WAMP

Published on November 10, 2017 in Apache, Windows

Let’s say you have a website on you wamp server by name project. So there’s a directory project in your C:\wamp\www directory. Also visiting http://localhost/project on the browser takes us to your project website. Now we want to set up a virtual host with self signed SSL certificate so that we can visit our website […]

Read Now

Using wpdb in core PHP non WordPress Projects

Published on July 19, 2014 in Php, Wordpress

If you are a WordPress developer you would definitely be aware of the $wpdb variable. $wpdb makes it easy to query any table in your database and handle the result data as an array with column names as keys or as an object with properties as column names. $wpdb also provides the prepared statement for […]

Read Now