Grep duplicate JSON keys
If you have large JSON files with application settings in, you need to be sure that the settings only appear…
A bunch of ramblings about PHP programming, JQuery, MySQL and other 'stuff'
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…