If you have large JSON files with application settings in, you need to be sure that the settings only appear…

Simple function for using in_array() with case insensitive querying. function i_in_array($needle, $haystack) { return in_array(strtolower($needle), array_map("strtolower", $haystack)); }

If you need to backup your SVN repositories, then you can use this bash script to do so: #!/bin/bash DATE=`date…

In most MySQL GUI’s that offer the ability to alter the table definitions of a schema, if you add a…

I recently had to create a site for an education facility, and they turn on Compatibility mode for all their networked…

I wrote a site for my local pub and it involved a restaurant booking section. The user could select a…

I have had to create a few PHP sites that connect to a MSSQL server. Not being down with setting…

If you ever wanted to prevent certain IP addresses from accessing your site, you can easily acheive this in the…

This is a “script” to convert your latin1 myisam database to utf8 innodb Dump the database mysqldump -u root -p database_to_convert > db.latin1.sql…

Quite often I have to convert datasets from one source to another target. Sometimes I can only export them as…