Ever had to check if a record exists using SELECT then perform an INSERT or UPDATE based on the result? Why not combine both the INSERT and UPDATE into one command and remove the SELECT query checking with one easy MySQL feature. Instead of performing two or three queries we can perform just one which
Continue reading...

There are multiple ways to redirect a domain to another domain but in this post we will be using mod_rewrite rules which are normally specified in the .htaccess file (you can learn about this file in this post). There are other redirect methods but these are past the scope of this post and will be
Continue reading...

I’ve had issues when designing websites with the website appearing to shift this is a common issue and caused due to the vertical scroll bar (used to move up and down a page) automatically appearing if the page content requires scrolling and disappears when it is not needed. This is not an issue on all
Continue reading...

All operating systems have some kind of scheduling ability on Windows we have task scheduler on Linux we have cron both of these accomplish the same task which is allowing us to run scripts or programs automatically based on different events, times and days. From my experience people tend to call the task scheduling system
Continue reading...

Gone are the days of hundreds of CD’s and photo albums most of us now have thousands of valuable irreplaceable photos and videos but why do thousands of us never create backup procedures or recovery plans…remember this data is irreplaceable your literally throwing away memories and all the hundreds of pounds you have spent building
Continue reading...

Shared web hosting is common and relatively cheap these days pay a small monthly fee from £1 all the way up to £35+ and you can easily setup a website with FTP, database and mail support. The features provided with most shared web hosting these days are varied to some providing hardly any to others
Continue reading...

Website compression is an important feature which can help increase a websites loading speed, before you dive straight in you need to understand how it works as it will increase CPU usage which could lead to a web server (especially busy ones) becoming slow resulting in slow website speeds (which could leave you with a
Continue reading...

A very common issue on most websites is oversized images, most people tend to just leave it as their website appears to load fast but they never think about other potential visitors they are alienating who don’t have fast internet or mobile internet devices which can take a long time to load depending on signal.
Continue reading...

When making a request with fsockopen the response you receive may not be exactly what you expected, let’s say you make a request to a simple HTML page which has one world which simply says “hi”, what you would expect from the fsockopen response data was the word “hi”, this is true we do receive
Continue reading...

This is a simple function I have used numerous times to simplify the process of stripping the header data which is normally found at the top of most web server requests and responses. I normally use this function if I am working with fsockopen and need to remove the response header before processing the response.
Continue reading...