How to embed HTML5 video with fallback
A common question with the rise of HTML5 becoming more and more common and the whole iGeneration (iPhones/iPads/iEtc) is “how can I embed a …
Read Article →Technical Articles
In-depth guides, insights, and best practices for modern software engineering
How to backup all mysql databases
In order to backup all mysql databases, you can run the following command in your linux command line:
The example below is configured with username …
Read Article →Invalid command 'RewriteEngine'
If you receive the following error message if means that mod_rewrite is not enabled in Apache:
Invalid command ‘RewriteEngine’, perhaps …
Read Article →How to get the Hours Difference (in HH:MM format) in PHP
It’s very simple to get the difference in hours using PHP
function timeDiff($firstTime,$lastTime) {
$firstTime=strtotime($firstTime); …Warning: Invalid argument supplied for foreach()
A common error which occurs with foreach loops is the standard “Invalid argument supplied for foreach()” whch gets thrown up as a warning. …
Read Article →Unable to connect to any of the specified MySQL hosts.
If you get the following error while trying to connect to a MySQL database using a third party client such as TOAD or SQL Workbench, then you need to …
Read Article →PHP nl2br on one line
I usually store data from a textarea directly to the database as is, then once I retrieve it back into HTML I use that lovely PHP function nl2br() to …
Read Article →LEN in MySQL
In MySQL 5.1 LEN is called LENGTH, you use it exactly the same and pass in the link, so: LENGTH(link).
Read Article →Remove all linebreaks in PHP
If you are having problems with a string that keeps adding a line break when output from PHP to HTML then the following code will work wonders for …
Read Article →IE9 adding empty table cells in large table
Well as usual, we are once again fighting the woes of the beloved Internet Explorer, and it appears that Microsoft’s latest greatest new and …
Read Article →SELECT Duplicate Items Using SQL
If you have a table which has duplicate items in then you can use the below statement to select them.
SELECT * FROM tableName
GROUP BY columnName …MySQL Error: Can’t get hostname for your address
This error is thrown by MySQL because it tries to do a DNS lookup on the address connecting to the server and it fails due to the IP not being able to …
Read Article →