This is a fairly common case I think. You have a table that has a datetime field that gets updated when a row is updated – you need to determine if a row has been updated recently.
Continue reading “Determine if a row has recently been updated using MySQL”
Find large files on a Mac using Terminal
Every few days, I had an issue where my startup disk was full and emptying the trash just wasn’t doing enough.
I found the following command online that searches a file system for files over 500MB and prints the file path. It identified files I had totally forgotten about as well as some huge files generated by apps I no longer used.
sudo find / -size +500000 -print
I then used the rm command to delete files. When deleting entire directories I used the recursive flag (be careful!)
rm -rf <directory path>
Kudos to davidcraddock.net
How to set revision number to svn external
SVN externals allow to include (nest) a remote SVN repository into another SVN repository. They are a great way to keep the latest code from another repository without having to do much.
One thing you will need to do is tell svn what revision of this remote SVN repository to load. To do that, do the following.
Continue reading “How to set revision number to svn external”
Loop through dates with strtotime() function
This simple method allows you to start at a date and iterate by either days or months until you reach the end date using my favourite PHP function, strtotime().
Continue reading “Loop through dates with strtotime() function”
Php Unserialize string after non UTF8 characters stripped out
This may be a pretty rare problem but I’ll post it regardless.
Continue reading “Php Unserialize string after non UTF8 characters stripped out”
WordPress Debug Log without Deprecated Notices
You turn on WordPress debugging only to find the log full of deprecated notices that make the log difficult to parse. Bummer.
You could spend time going through each deprecated notice and updating the offending piece of code. Or you could ask WordPress to ignore these deprecated notices (at least in the short term) by doing the following;
Continue reading “WordPress Debug Log without Deprecated Notices”
String replace in multiple files using a recursive file search
Here is a command line method to replace a string in multiple files in the current and sub directories.
Continue reading “String replace in multiple files using a recursive file search”
Get list of modified files in directory
Here is a command to get a list of modified files in a directory and subdirectories;
Continue reading “Get list of modified files in directory”
Get last line of file in PHP
Here is a simple way to get the last line of a file without reading the entire file into memory.
Continue reading “Get last line of file in PHP”
Php Sleep function in javascript
Here is a tidy javascript function that I found on stack overflow to mimic PHP’s usleep function which has been useful when testing javascript.
Continue reading “Php Sleep function in javascript”
magp.ie 