So, trying to use a Linux Mint laptop and Plex for a lower power consumption server seemed a good idea,…

So, quick and simple MySQL backup in a CRON. #!/bin/bash _hour=`date '+%H'`; _user="root"; _pass="thepassword"; _dest="/srv/backups/daily/"; mysqldump -u $_user -p$_pass --all-databases…

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…