Geoffrey Garbers Thoughts on everything from PHP to photography

Easy way to generate CakePHP HABTM joins for use in pagination.

Posted 3 weeks ago.

Most CakePHP developers have come across the pagination of HABTM relationships, and trying to get those relationships to persist through the pagination. In this post, I've managed to wrap a solution to this problem into a single, easy-to-use method that will hopefully helpful other developers in a similar situation to me.

Calculating the distance between two GPS points in MySQL

Posted 1 month ago.

There have been many tutorials floating around the ‘net for a while, detailing how to calculate the distance between an entry in your database, and a set of arbitrary GPS points. Not many of these tutorials will allow you to find the distance between two random points you might have.

You want funky disco? I give you funky disco!

Posted 2 months ago.

I came across a great bit of Javascript that turns a web page into a disco. I thought I’d package it as a bookmarklet, so you can try it out on any site you come across (it seems to work much better in Chrome than it does in Firefox). Warning: If you are epileptic, it [...]

CakePHP 1.3 – An internal error has occurred.

Posted 2 months ago.

When you see the following problem on cake: An Internal Error Has Occurred Error: An Internal Error Has Occurred. This is CakePHP’s new way of telling you something went wrong. You should switch on debugging in app/config/core.php Change it from: Configure::write('debug', 0); to: Configure::write('debug', 2); If you don’t want to switch debugging on, check your [...]

Connecting quickly to an Apache Derby database

Posted 4 months ago.

Find yourself needing to connect to an Apache Derby database? I found a rather basic (but useful) quickie on how to connect and get yourself up and running with connecting to an Apache Derby database. http://www.phpin24.co.za/command-line-shell-scripting/connecting-to-derby-db-from-command-line/

Recovering recently deleted files from an EXT3/EXT4 (with journaling) partition

Posted 7 months from now.

If you're running Linux, have you ever had that feeling of dread after deleting a whole chunk of code accidentally? Code that hasn't been checked into a repository, or backed up. A lot of websites will foretell of long hours of recovery if you're running an EXT3 or EXT4 partition with journaling. This post details how I managed to find and use a nifty little utility that recovered almost all of my files for me, in very little time too.

Sending mail through a remote SMTP server in Linux

Posted 7 months from now.

Sending mail through the Linux command line can sometimes be a tricky issue. If you don't know how to set up your own mail server, but have a readily accessible SMTP residing elsewhere, I'll show you how to use a readily-available Debian/Ubuntu package to send your mail through this SMTP server quickly and easily.

Password-protect a directory for a range of IP addresses

Posted 6 months from now.

I've often come across instances where it is very useful to password protect a directory for external visitors, and allow internal visitors to view the directory without authentication. In this post, I'll show you how to easily set this up for multiple ranges of IP addresses.