All posts by

rubik
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.

wordpress-logo
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.

wp_plugin_security
Coding - PHP - Wordpress

WordPress Plugin Development, Lesson 4: Basic Security

This is part of an ongoing series for programmers interested in developing WordPress plugins with PHP. If you are just starting out with WordPress, and want some more basic tips, check out the previous lessons:

using-php-and-curl-to-scrape-web-pages
Coding - PHP

Using PHP and cURL to Scrape Web Pages

This is part of a continuing series on PHP programming. If you are brand new to PHP and want a more basic tutorial, check out our Introduction to PHP, then come back and complete this one. If you feel like you have the basics down, let’s jump right in. Today, we’re going to use cURL and PHP to scrape a website for data, specifically the list of most often downloaded ebooks at Project Gutenberg.

refactoring-php-code
Coding - PHP

Refactoring PHP Code

This tutorial is meant to introduce PHP programmers to the technique known as code refactoring, and explain why it should be part of any programmer’s development plan. If you are brand new to PHP and need a more basic tutorial first, check out our Introduction to PHP lesson, then come back to this one to build on that foundation.

wordpress-plugin-development-email-functions
CMS - Wordpress - Coding - PHP

WordPress Plugin Development, Lesson 3: Email Functions

This is the third in a series of tutorials meant to introduce programmers to WordPress plugin development. If you haven’t yet, I recommend you go through Lesson 1: Introduction to WP Plugin Development and Lesson 2: The Admin Page. Each one will only take you 10-20 minutes to complete, and then you’ll be ready for this tutorial. In today’s lesson, we’re going to move on from the basic string capabilities we used in our first plugin to something a little more complex: email functions.

plugin_icon
CMS - Wordpress - Coding - PHP

WordPress Plugin Development, Lesson 2: The Admin Page

WordPress is an incredibly popular and widespread content management system, used by over 60 million websites and blogs. It has its downsides, like any software package, but one of its strengths is its use of plugins, pieces of additional code that add to the core code of WordPress without altering it. This is an intermediate lesson in WP plugin development.

php_wp_plugins_logo
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.

php-and-mysql-working-with-google-maps
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.

php-basics-forms
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 Syntaxxx.com covering the basics of PHP programming.

Subscribe To Our Newsletter