- Cheat Sheets
- Deals and Free Stuff
All posts in Databases
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.
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.
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.
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.
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 Syntaxxx.com covering the basics of PHP programming.
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.