Author Archives: Phil LaNasa

A shorthand substring search function for JavaScript

string-search-js

Make your life about 1% easier by creating a convenience substring search method on the JavaScript String prototype. more …

MySQL Sales Reporting by Holiday

holiday reporting

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). more …

Installing ImageMagick on CentOS for use with PHP

imagemagick 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. more …

Combining multiple SQL queries for listing pages into one

combining queries

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. more …

Usability and end-of-document padding

usability 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 quick report I created for them. Reason: The task bar at the bottom of Windows … more …

JavaScript for Kids

javascript-for-kids

Twenty-two years ago I was introduced to programming by a friend in middle school. I was working on a video project and my friend thought it would be cool to display scrolling credits at the end of the video. I … more …

Amazon RDS with MySQL – My Experience

Capture

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. more …

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! more …

ColdFusion / PayPal Payflow REST API Integration

coldfusion paypal payflow

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. more …

Are you backing up your cron table?

backup 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. more …