WJGilmore.com Blog

Have some developer news you'd like us to post here? E-mail blog@wjgilmore.com with all of the details!

Disabling Foreign Key Constraints When Loading MySQL Data

Published: September 20, 2010

MySQL’s InnoDB storage engine supports the use of foreign key constraints, which are very useful but require you to manage your data in a much more rigorous manner than might otherwise be employed when not taking advantage of this feature. For instance, when migrating data from a database which does not use foreign keys to one which does, you’ll often encounter an error in which MySQL complains about a foreign key constraint not being met. This is easily resolved by temporarily disabling foreign key checks before beginning the import, and then re-enabling them when the import is complete. Read on to learn how.

Checking a User’s Login Status Using a Zend Framework Action Helper

Published: September 16, 2010

Although it’s easy to use Zend_Auth’s hasIdentity() method to determine whether a user is logged into a website, I’d rather keep my code DRY when the need arises to selectively restrict certain controller actions to logged-in users. This dilemma is easily solved using a custom action helper.

My Developer.com Google Maps API Tutorial Series Summary

Published: September 16, 2010

As I sit here this morning penning the latest installment of my ongoing Google Maps series for Developer.com, it’s difficult to believe that the first tutorial in this growing collection was written over five years ago!

Although some of this material is now slightly outdated due to API changes made in the version 3 release, it’s still serves as pretty useful material if you’re looking to ramp up your knowledge in a hurry. To help you get started, I’ve aggregated a list of all 12 articles here.

Validating Identical Passwords with the Zend Framework

Published: September 06, 2010

When creating user registration and password-related models you’ll likely need an easy way to compare the user’s chosen and confirmed passwords. Yet despite the Zend Framework having long supported over two dozen input validation features, it wasn’t particularly easy to compare input associated with two different form fields without breaking tier separation best practices. That all changed with the Zend Framework 1.10.5 release, which finally added support for this useful feature.

Zend Framework Tip - Getting Controller and Action Names

Published: August 23, 2010

Ever wanted to programmatically know the names of the currently executing Zend Framework controller and action? Read this short-and-sweet blog entry to find out how.

New PHPBuilder.com Tutorial: Introducing ExpressionEngine 2

Published: August 03, 2010

In the latest installment of my ongoing PHPBuilder.com series, I review some of ExpressionEngine 2’s new and interesting features.

New Developer.com Tutorial: Building a URL Shortener with jQuery, PHP, and MySQL

Published: August 03, 2010

In the latest installment of my ongoing Developer.com series, you’ll learn how to create a URL shortening service similar to Bit.ly using jQuery, PHP, and MySQL.

New Internet.com Video: Processing Form Input with PHP

Published: August 03, 2010

In my latest Internet.com video installment, you’ll learn how to properly and securely process HTML form input using PHP.

Video Tutorial: Connecting to Twitter Using the Zend_Service_Twitter Component

Published: August 03, 2010

In my latest Internet.com video installment, you’ll learn how to use the Zend Framewrk’s Zend_Service_Twitter component to both post entries to the service as well as receive a list of the your Twittersphere’s latest updates.

E-Commerce Made Easy with FoxyCart

Published: July 21, 2010

In a recent PHPBuilder article I mentioned the challenges I had been facing in regards to finding a capable content management system which was extensible enough to manage multimedia content in ways which stretched beyond the features typically bundled into such systems. As that article documents, the solution I chose was ExpressionEngine, and three months after the article’s publication and a recent very successful website relaunch I’m pleased to report that this decision remains decisively without regrets.

Page 2 of 10 pages  <  1 2 3 4 >  Last »