All posts in Databases

Coding - Databases

Moving from Simple to Complex MySQL Queries

SQL (Structured Query Language) is the standard database management language across the web. Though there are several different database packages, MySQL being the most common, all of them use SQL as their foundation. Basically, if you want to access relational data from your application, regardless of package or scripting language, you are going to need to understand SQL.

CMS - Wordpress - Coding - Databases - PHP

Using $wpdb and the WordPress Database Functions

As I talked about previously in our Introduction to WordPress Plugin Development tutorial, one of the great things about working in WordPress is the ability to piggy-back on WP’s database connection. It not only saves you code and time, but also makes your plugin or theme run faster and more securely. Today, I’d like to get into more detail about exactly what database functions are available to you inside of WordPress.

CMS - Wordpress - Coding - Databases - PHP

Introduction to WordPress Plugin Development with PHP

WordPress is the most popular content management system on the web. Over 60 million websites use WordPress, from your neighbor’s blog about goldfish to premium enterprise sites like CNN and Time. Like PHP, the scripting language that it is built upon, WordPress isn’t perfect, but if you work in PHP long enough, you’re going to need to know how to work in WP.

Coding - Databases - PHP

PHP and MySQL: Working with Google Maps

Maps are perfect examples of modern web philosophy, visually representing data and also taking advantage of the mobile web by allowing sites and apps to be customized by location. Not every web application needs maps, but they can enhance many of them. Just as it has with search, Google has all but cornered the market in online mapping.

Coding - Databases - HTML - PHP

PHP Basics: Forms

Even today, in the age of apps and streaming video, HTML remains the backbone of the browsable web. But unless you want a static, brochure-type website, you’ll need at least one scripting language to add dynamic content and functionality on top of your HTML. This is the latest in a series of tutorials here on covering the basics of PHP programming.

Coding - Databases - PHP

PHP Basics: Connecting and Working with a MySQL Database

PHP is a powerful and flexible language on its own, but one of its real strengths is its integration with MySQL, an open-source database package. Like PHP, MySQL is used in some of the most popular content software on the web, including WordPress, Drupal, and Joomla. By connecting your PHP script with a MySQL database, you’ll be able to create truly dynamic data-driven websites and apps.

Subscribe To Our Newsletter