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” →
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
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” →
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” →
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” →
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” →
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” →
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” →