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…
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.
This code will list all of the files within a directory and give the user the option to delete the file.
This code will display all of the files within a specified directory with a filetype restriction.
Add the following code to the top of your page: And add this code to the bottom of your page: