Blog Archive - Software Dev

Bambora process_transaction.asp error: "Declined: Entered Information Cannot Be Authenticated"
April 1, 2019
If you are using Bambora's (formerly Beanstream) process_transaction.asp and receive the error "Declined: Entered Information Cannot Be Authenticated", you may find this frustrating, because although this error appears in their documentation, there's no information about what it means or how to solve it, which is basically useless.Read more...
Automatically print WooCommerce orders
December 27, 2018
Disclaimer: this doesn't have an easy solution, and the solutions that do exist are printer-specific, so we're not releasing this as a plugin. It will almost certainly need to be modified to fit your specifications.Read more...
WooCommerce event ticket sales report
December 14, 2016
For several years we've been using WooCommerce for general admission event tickets. For this we've been using an open source ticketing system. It works, sort of. The number of bugs we have to find and fix increases at every show. The most critical one we found this year was a bug that displays show times incorrectly. This is problematic for obvious reasons. When we reported this to the company's developers, their suggestion was to stop selling tickets until after Daylight Saving's Time. This plus many other annoyances led us to decide to reinvent the wheel.Read more...
Maximum Image Size - WordPress Plugin
September 24, 2015
Sometimes, it's not necessary to keep copies of full resolution images on your web server. But, when you solicit images from many sources, you may not be able to rely on users to size images to your specifications. Here's a very simple plugin that removes the full resolution image and replaces it with an image resized to your preference.Read more...
Run a script on every column of every table in your MySQL database
June 23, 2012
Have you ever needed to recursively run a script in a loop on every single column in your MySQL database? This PHP code can help.Read more...
Password prompt for PHP CLI
January 28, 2012
Do you use PHP from the command line and need a password prompt? This is how you do.Read more...
Which Email Providers are the Most Popular?
February 9, 2010
At Mango's day job, he operates a mailing list for his customers. Approximately 2,000 customers have subscribed to it. He wanted to set up test email accounts with various webmail providers to be sure his emails arrived as intended. But which webmail providers should he choose? The most popular email providers were easily found with this MySQL query:Read more...
Easily Check HTTP Headers with this tool
December 28, 2009
We were trying to solve an annoying bug in our mod_rewrite code today and couldn't quite figure out why our server was acting the way it was. Fortunately we discovered a nifty tool (Thanks pkhach!) that allows you to view the HTTP request and response headers for any URL you like. You can even choose between HTTP/1.1 and HTTP/1.0, with and without the Host header.Read more...
Replacing smart quotes, em-dashes, and ellipses with MySQL or PHP
March 5, 2009
Alternate title: "Help! My Quotes Appear as Question Marks or Other Strange Characters!"Read more...
Some nifty PHP date/time functions
March 8, 2008
I wrote two date/time functions in PHP that I was really pleased with so thought I'd post them.Read more...
My htmlspecialchars() functions for Javascript
December 22, 2007

I thought I'd post my htmlspecialchars() functions for Javascript. This should mimic the PHP version of htmlspecialchars(). I also include rhtmlspecialchars() in case you need to do the reverse.

Read more...