Meta Title Tag and SEO

This is post is now quite old and the the information it contains may be out of date or innacurate. If you find any errors or have any suggestions to update the information please let us know or create a pull request on GitHub There are some very complicated aspects to a successful on page search engine optimisation strategy. However there are also some incredibly simple ones. At the very top of the list of simple things you can do to improve your SEO is to make sure that your <title> tag contains a unique and descriptive page title for each and every page of your web site. Read On →

MySQL DB Admin GUI for Windows / XAMPP

This is post is now quite old and the the information it contains may be out of date or innacurate. If you find any errors or have any suggestions to update the information please let us know or create a pull request on GitHub If you are using windows (with XAMPP) to develop your MySQL applications, you might currently be using phpMyAdmin for your DBA tasks. The phpMyAdmin package is an awesome tool and is a must have, however due to the fact that it runs under Apache and PHP - it can be tricky to use when dealing with big database dumps or other heavy processing. Read On →

Advanced PHP Debug Function

This is post is now quite old and the the information it contains may be out of date or innacurate. If you find any errors or have any suggestions to update the information please let us know or create a pull request on GitHub I have taken the debug function about as far as I can think of. This function will now take a variable and display it all in a nice easy to read format. Read On →

PHP Save Images Using cURL

This is post is now quite old and the the information it contains may be out of date or innacurate. If you find any errors or have any suggestions to update the information please let us know or create a pull request on GitHub Some hosts disabled the ini setting allow_url_fopen. This also means that the ability to easily grab images by calling imagecreatefromjpeg($img) where $img is a url for an external image does not work. Read On →

Debugging PHP Scripts

This is post is now quite old and the the information it contains may be out of date or innacurate. If you find any errors or have any suggestions to update the information please let us know or create a pull request on GitHub When coding PHP, or more frequently when trying to customise or fix someone elses code, it can sometimes be tricky to figure out exactly what is going wrong. Read On →

MySQL Add Column if Not Exists - PHP Function

This is post is now quite old and the the information it contains may be out of date or innacurate. If you find any errors or have any suggestions to update the information please let us know or create a pull request on GitHub This is a nice little function which I struggled to find elsewhere on the web. As discussed elsewhere this is not the kind of thing that should be included in a public facing script, but for administration tools etc its pretty handy: function add_column_if_not_exist($db, $column, $column_attr = "VARCHAR( 255 ) NULL" ){ $exists = false; $columns = mysql_query("show columns from $db"); while($c = mysql_fetch_assoc($columns)){ if($c['Field'] == $column){ $exists = true; break; } } if(!$exists){ mysql_query("ALTER TABLE `$db` ADD `$column` $column_attr"); } } This function grabs the column information for the table, then it loops through the info looking for the column. Read On →