Are you receiving the dreaded “Connection Information” permission issue on your local Mac OS X environment? You’re not alone – and thankfully there is a simple solution to this issue….
Login to SSH Type: /scripts/pkgacct username (where username is the username of the account you wish to duplicate) In WHM -> Account Functions -> Modify Account, change the domain name…
Today I ran into an interesting problem and solution while creating an e-newsletter. Even though I had an inline color style set for a link, Outlook was changing the visited…
The Authorize.Net Server Integration Method (SIM) provides a secure payment form to make integration easy for WordPress merchants that do not have an SSL certificate. Important Information: You must have…
This code will convert (pivot) your MySQL database table from rows to columns. Here is an example of what this code will do: Original Table ID Name Color 1 James…
$_SERVER[‘REQUEST_URI_PATH’] = parse_url($_SERVER[‘REQUEST_URI’], PHP_URL_PATH); $segments = explode(‘/’, substr($_SERVER[‘REQUEST_URI_PATH’], 1)); Example: If I wanted a different sidebar for the blog directory in this URL: https://jamesnorthard.com/blog/page/2/ I would use the following code:…
The following code will convert the string into a datetime datatype. STR_TO_DATE(datestring, ‘%m/%d/%Y’) To change the format of the date displayed, use DATE_FORMAT. DATE_FORMAT(STR_TO_DATE(datestring, ‘%m/%d/%Y’), ‘%Y-%m-%d’)
This code will pull the latitude and longitude points of an address that has been submitted.