Make your life about 1% easier by creating a convenience substring search method on the JavaScript String prototype.
MySQL Sales Reporting by Holiday
Not all real-world reporting requirements align well with how your data is organized. In my case, I had to produce sales reports tied to a US Holiday (which varies year-to-year).
Installing ImageMagick on CentOS for use with PHP
It’s not brain science, but it did take me a reasonable amount of time to figure out how to properly configure my CentOS server for using ImageMagick with PHP.
Combining multiple SQL queries for listing pages into one
With a little extra effort, you can construct a single query that returns multiple rows using the SQL IN operator.
From there, you can convert the query results into a language construct that is easy to work with.
Usability and end-of-document padding
Just an hour ago I had a client email me to let me know that they couldn’t see the text at the bottom of a…
Amazon RDS with MySQL – My Experience
Migrating a database over to Amazon RDS isn’t an all day event, but you will run into a couple snags. This post points out two issues that I ran into and quick solutions.
Slightly better fragment id scrolling
Don’t bother reading this post. It satisfies a personal itch and will appeal to maybe 1% of the webdev crowd. I’ll do better next time!
ColdFusion / PayPal Payflow REST API Integration
It was a bit of struggle using ColdFusion to integrate with PayPal’s Payflow REST API, but I worked it out and provide complete code in this post.
Are you backing up your cron table?
Most of us have some kind of secondary or off-site backup of our files & data, but may not have considered backing up the “heartbeat” of our server – the cron table.
Linux – Change file ownership from one user to another
Changing file and group ownership from one user or group to another is a common requirement in the server admin world, here are two quick tips on how to go about it.