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 →Technical Articles
In-depth guides, insights, and best practices for modern software engineering
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. Here’s a quick function that takes two time strings and returns the difference: …
Read Article →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
Coming from SQL Server or MS Access? You might be looking for LEN() to get the length of a string. In MySQL, it’s called LENGTH() instead.
You …
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.
This comes up a lot during data cleanup — maybe …
Read Article →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 →Adobe drops flash for mobiles!
..and it’s official – so says Adobe’s blog (read it here). Adobe will be dropping support for Flash on future devices due to performance …
Read Article →jQuery Colorbox not showing but background shows
I was using Colorbox for some lightbox type effects to show larger images when clicking on thumbnails, but for some reason the background was showing …
Read Article →Get Value of Checkbox using jQuery
This one is quite an easy one, but a good one to mention non-the-less as it does definitely come in really handy.
If you would like to get a …
Read Article →Everybody’s a web host
To cut straight to the point, “we’re living in the age where everybody’s a web host”. Whether it be small and quite pathetic …
Read Article →CSS Background Default
If you need to override an already attached class containing a background — for example, removing a background image or colour that’s being …
Read Article →Restrict PHPMyAdmin to IP Address
Would you like to restrict PHPMyAdmin from being accessible to the whole world?
Firstly you need to SSH into your box if you are not on the local …
Read Article →2014 – Commands out of sync; you can’t run this command now
#2014 – Commands out of sync; you can’t run this command now
Now that can be a really annoying error!
It happens when querying stored procedures …
Read Article →Image corrupt or truncated: “unknown”
What is “Image corrupt or truncated:
This can often be seen while using Firebug in Firefox, but it actually has …
Read Article →WordPress wp-admin use different language for user
I needed to do some work on a WordPress site a little while ago and all the admins were French – and I cannot speak French other than the popular …
Read Article →Replace all spaces in HTML with except in HTML tags using PHP
If you would like to replace all the spaces in an HTML string with so that you can render it out to the browser but you also want to retain current …
Read Article →Using PHP to validate an IP address
You can use the PHP code below to check if an IP address is valid or not.
I needed this when building a form that accepted IP addresses as input for a …
Read Article →What is the difference between is_home() and is_front_page()
Call me ignorant, or call me an ignorant geek, but I used to think is_home() and is_front_page() was the same thing, until I experimented with them …
Read Article →..near 'option o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.o' at line 1
So you’ve just installed Opencart 1.5.0 and when attempting to edit a product or category or etc you get the following error:
Error: You have an …
Read Article →