Home page Home | Table of contents Table of Contents | Download the code Download the Code | Book translations Translations | About Jason About the Author
Beginning PHP and MySQL, Third Edition - the book

PHP and MySQL Made Painless.

Vital Statistics: 38 chapters, 1,044 pages and 500+ examples!!

Learning Resources

This page is intended as a directory of development-related articles I've written over the last decade; as many are pertinent to PHP and MySQL hopefully they'll be of assistance. However please note the dates that accompany many of the links, as some of these articles are more than seven years old and accordingly the data is quite dated.

SearchEnterpriseLinux.com (TechTarget)

Ajax Everywhere: Which Framework to Choose?
October 17, 2006 | TechTarget

Open Source Vet Looks Inside Microsoft's Sourceforge Knockoff
September 25, 2006 | TechTarget

Microsoft's IIS 7 Will Aid PHP Developer's Windows Deployments
Published: September 25, 2006 | TechTarget

Open Source Vet Looks Inside Microsoft's SourceForge Knockoff
Published: September 25, 2006 | TechTarget

LinuxWorld Product Review: The Nokia 770 Internet Tablet
Published: August 23, 2006 | TechTarget

Automating Amazon Research with the Zend Framework
Published: July 19, 2006 | TechTarget

PostgreSQL -vs- SQL Server
Published: May 15, 2006 | TechTarget

Five Reasons You Should Never Use PostgreSQL - Ever
Published: March 14, 2006 | TechTarget
This article apparently rankled the IT community a tad, as it was Slashdotted and Dugg to the front page within 24 hours of its publication.

Using Excel to Analyze MySQL Data
Published: March 1, 2006 | TechTarget

Developer.com

Creating a Code Search Engine with PHP and MySQL
April, 2007 | Developer.com

Four Ways to Optimize Your MySQL Database
April, 2007 | Developer.com

Integrating MP3 Audio Messages Into Your Website
March, 2007 | Developer.com

Developing and Ajax-Driven Shopping Cart with PHP and Prototype
January, 2007 | Developer.com

Forms Validation with Symfony and Prototype
January, 2007 | Developer.com

Forms Validation with CakePHP
December, 2006 | Developer.com

Scaffolding with CakePHP: Managing Your Fantasy Football Team
October 13, 2006 | Developer.com

Integrating Google Maps into Your Web Applications: The Basics

Integrating Google Maps into Your Web Applications: Retrieving Map Location Coordinates

Integrating Google Maps into Your Web Applications: Building a Geocoding Web Service

Integrating Google Maps into Your Web Applications: Building a Geocoding Web Service with Geo::Coder::US

Integrating Active Directory with PHP

Searching Active Directory with Perl

Taking Advantage of PEAR

Should Ruby Be Added to Your Programming Repertoire?

This Year's Buzz in Web Services
March, 2005

The Sun Outshines the Rest
March, 2005

Linux World Boston 2005 Recap
March, 2005

Automating Web-Based Data Retrieval with Perl
October, 2004

Patterns and PHP
2004

Creating a Custom RSS Feed Aggregator
2004

International PHP Magazine

Good Things Come in Small Packages: Introducing SQLite
This is an adaptation of the SQLite chapter found in "Beginning PHP and MySQL 5, Second Edition".
May, 2006 | International PHP Magazine

O'Reillynet

PHP's Encryption Functionality
July 26, 2001 | O'Reillynet ONLamp.com

Getting Flashy With PHP
June 28, 2001 | O'Reillynet ONLamp.com

PHP and Java
June 14, 2001 | O'Reillynet ONLamp.com

Session Tracking with PHP Part II
May 10, 2001 | O'Reillynet ONLamp.com

Session Tracking with PHP Part I
April 26, 2001 | O'Reillynet ONLamp.com

Networking with PHP
April 5, 2001 | O'Reillynet ONLamp.com

PHP and the Sablotron Processor
March 16, 2001 | O'Reillynet ONLamp.com

Are PHP and MySQL the Perfect Couple?
June 16, 2000 | O'Reillynet ONLamp.com

Linux Magazine

PHP 5 Pushes Forward
September 25, 2005 | Linux Magazine

On the Open Source Front: Slim Devices
August 15, 2004 | Linux Magazine

On the Open Source Front: Magellan Navigates RFID
July 15, 2004 | Linux Magazine

On the Open Source Front: CORESense
June 15, 2004 | Linux Magazine

On the Open Source Front: Checking Out 2Checkout.com
May 15, 2004 | Linux Magazine

InfoWorld

How I Work: Jason Gilmore, Open Source Editorial Director, Apress
May 16, 2006 | InfoWorld

Dr. Dobb's

NOTE: I'd actually written all of the articles filed under the section in the late 1990's for a now defunct Web developer's 'zine called Web Review, which was subsequently integrated into Dr. Dobb's Portal. For some reason they dated all of the articles January 1, 2002, however keep in mind these articles are actually much more dated than that.

Clean Up Those URLs with Apache
January 1, 2002 | Dr. Dobb's

Template-Based Web Sites as Easy as P-H-P
January 1, 2002 | Dr. Dobb's

One Wicked Site Admin Combo
January 1, 2002 | Dr. Dobb's

Object-Oriented Programming with PHP
January 1, 2002 | Dr. Dobb's

The Sablotron XSL Processor
January 1, 2002 | Dr. Dobb's

Installing PHP/Apache on Your Win98/NT Machine
January 1, 2002 | Dr. Dobb's

What You Should Know About PHP
January 1, 2002 | Dr. Dobb's

Down for the Count?
January 1, 2002 | Dr. Dobb's

Interviews

LinuxWorld Interview (video)
Published: April 17, 2006

Why PostgreSQL Can Best SQLServer, Oracle
Published: April 4, 2006
Interview with Robert Treat and I regarding the advantages of choosing PostgreSQL over proprietary solutions. This interview prompted a huge community response, and amazingly some rather positive feedback which culminated in a follow-up article, which you can read here.

Hands On: How Not to Program in PHP
Published: November 13, 2003

Buy the book from Amazon.com!

Buy the book direct from the author!

Hire Jason for your next project!

Useful Articles and Tutorials

Creating a Code Search Engine with PHP and MySQL
April, 2007 | Developer.com

Four Ways to Optimize Your MySQL Database
April, 2007 | Developer.com

Integrating MP3 Audio Messages Into Your Website
March, 2007 | Developer.com

Developing and Ajax-Driven Shopping Cart with PHP and Prototype
January, 2007 | Developer.com

More Articles and Tutorials...

Tip of the Week

Did you know you can quickly look up a PHP function simply by appending it's name onto the end of www.php.net? For example, to learn more about the explode() function, just navigate to www.php.net/explode.

Bulk Purchases

Interested in using the book within the classroom, or want to make several copies available to your development team? A 10% discount will be applied to purchases of more than 10 copies! Contact Jason at jasonATwjgilmore.com to make arrangements.

Copyright © 2000-2008 W. Jason Gilmore