What is the difference between $wpdb and WP_Query?
$wpdb is a PHP global variable that holds the WordPress database object, which is actually an instantiation of the wpdb class. WP_Query actually uses wpdb to query the database. Use…
What is $wpdb in WordPress and How to Use it for Database Security
$wpdb is a PHP global variable that holds the WordPress database object, which is actually an instantiation of the wpdb class. $wpdb is used to manipulate custom database tables with…
How To Store MySQL Result To Array From Bash
Every programming language offers drivers or extensions to query MySQL and fetch the result. In other words to store MySQL result to array. Sometimes you need to do the same…
Update Postgres Major Version in Debian Jessie
Postgresql update is not a trivial task. According to PostgreSQL Versioning policy: A major release is numbered by increasing either the first or second part of the version number, e.g.…
How to Install PostgreSQL 9.3 on Debian 7 Wheezy
While MySQL considered as "The world's most popular open source database", PostgreSQL rightly considered as "the world's most advanced open source database". PostgreSQL architecture is based on CLUSTERS (a group…