Getting Acquainted with phpMyAdmin
Duration: 15:57 |
Price: FREE!
Introducing Scriptaculous
Duration: 11:03 |
Price: $2.00
Creating Your First PHP Script
Duration: 5:11 |
Price: $1.00
Have some developer news you'd like us to post here? E-mail blog@wjgilmore.com with all of the details!
Although several great GUI-based MySQL clients exist, among them phpMyAdmin and SQLYog, I’ve always preferred to use the native mysql command-line client. It does take some time to get acquainted with using a command-line interface (CLI), particularly if you don’t regularly work with an operating system offering a robust CLI environment. However, after some practice you’ll be able to manage users, navigate your databases, and perform other tasks with incredible ease.
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.
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.
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.
MySQL stored procedures and views can not only go a long way towards separating the logic and domain model, but they also can easily be integrated into PHP. This article introduces stored procedures and views, and shows you how to use them within your PHP code.
In this article I’ll show you how to implement both of these authentication approaches using nothing more than the Apache Web Server’s native capabilities. The first approach can be implemented in mere minutes using a text file and a few command-line calls. The second approach is a tad more involved, requiring a bit of additional server configuration and a MySQL database, although you’ll gain some additional flexibility along the way.
This occasional series introducing various facets of the powerful Google Maps API has examined quite a few different features that are likely to appear in an enterprise web-based mapping implementation, ranging from calculating user-defined route distances to using the Google Maps API Geocoder to convert mailing addresses to their respective coordinates. In this installment, I discuss yet another feature that has become standard, particularly on the web sites of large retail chains: the “Store Locator.”
The Store Locator feature provides web site visitors with an easy way to determine the location of nearby stores, typically done by first asking the visitor to provide his or her zip code. The site then consults a database containing all of the chain locations, somehow determining which stores reside in or around the visitor’s zip code. The locator feature is also often enhanced by providing the user with an option to view stores residing within a specified radius of the provided zip code, such as 10 miles, 20 miles, or 100 miles. In this tutorial, I’ll show you one way to create this feature using the Google Maps API, JavaScript, PHP, and a MySQL database.
