CCleaner… loved by many, avoided by me (with good reason)

I have always been of the mindset, the more you add to a system to automate mundane tasks, the more you open yourself to exploits. I have had to deal with many workstations, servers, and personal computers that were previously maintained by other (less experienced) administrators that swear by the use of CCleaner, Defraggler, and Speccy (not linking intentionally, use Google if you want links to their software). I have always immediately removed them as one of my first clean-up tasks. Continue reading CCleaner… loved by many, avoided by me (with good reason)

Toggle Password Display in HTML5 with jQuery

Do you have  a password field that the user wants to be able to view at the click of a button? Here is the solution I came up with to handle that need…

The field…

<div class="input-group">
  <input type="password" name="password" value="P@$$w0rD" placeholder="Password" id="input-password" class="form-control" required>
  <span id="view-password" class="input-group-addon"><i class="fa fa-eye" aria-hidden="true"></i></span>
</div>

The javascript… Continue reading Toggle Password Display in HTML5 with jQuery

How to Move a Domain Between BlueHost Accounts

Save yourself the trouble and don’t bother asking BlueHost support when you run into a problem trying to assign a domain from one BlueHost account to another. They misinformed us about more than a few aspects and the notices displayed on the page when the assignment encounters a problem is not very intuitive.

First things first: If you are using BlueHost for email and have your email program configured for IMAP, you have a bit of work ahead of you.

Continue reading How to Move a Domain Between BlueHost Accounts

How to Uninstall a Program on Windows 7 (with pictures)

Most applications for Windows 7 use an installation program such as Windows Installer to install the application in the system.

Windows Installer ensures that installed programs can be easily removed from the system. Under no circumstances should you simply delete the program folder of the application. Doing so would leave numerous files and registry entries in the system, which could compromise operating system stability. Continue reading How to Uninstall a Program on Windows 7 (with pictures)

Stop Annoying favicon.ico 404 errors

If you’re like me, you don’t like cluttering your main folder with unnecessary files. This is why I hate that some browsers are still looking for ‘favicon.ico’ in the main folder even when you indicate in <head> that’s not where the agent should be looking…

Here is a way to eliminate those PITA 404’s from your error logs… Continue reading Stop Annoying favicon.ico 404 errors

Split fields by characters in MySQL

I have a project where the geographical coordinates for records are stored in a single field separated by a comma. While this may suit general display purposes, it eliminates the capability to search by distance.

Sample data: 34.7451738,-86.5941693

My solution was to add two new FLOAT(10, 6) fields named “lat” and “lng” to the database table. Then I ran this query to populate the two new fields with the existing “coordinates” data.

UPDATE `locations` SET `lat` = SUBSTRING_INDEX(SUBSTRING_INDEX(`coordinates`, ',', 1) , ',', -1), `lng` = SUBSTRING_INDEX(SUBSTRING_INDEX(`coordinates`, ',', 2), ',', -1);

Who doesn’t love one-liners for mass-updates in a table 😉

Modules and extensions developed for all versions of OpenCart

Module & Extension Development

Whether you need a new payment gateway, changes to existing modules or extensions, or a new extension developed from scratch… rest assured it will be developed for your version of Open Cart and guaranteed¹ to be free of programming errors.

Check out our list of commercial (and free) extensions developed for Open Cart 1.4.x, 1.5.x and 2.x. Some were created for clients upon request, while others were added simply because we noticed the need in the Open Cart community. Continue reading Modules and extensions developed for all versions of OpenCart

OpenCart Option Value Limits (imposed by server)

If you’re like me you have an OpenCart site with thousands of possible option values for individual product options. Mine resulted from a large import of data. After which, I was no longer able to remove or add more option values (eg: too many fields in the form).

Many people think this is a limitation of OpenCart, which is not the case… the issue resides in your server’s PHP configuration. Specifically with PHP’s max_input_vars and post_max_size directives. Continue reading OpenCart Option Value Limits (imposed by server)

Freelance LAMP (Linux, Apache, MySQL, PHP) Developer for Hire