..check it out the Foldi blog for updates on work, clients, etc...

Archive for November, 2009


Queries across multiple databases with CakePHP

Friday, November 27th, 2009

Most CakePHP documentation assumes you’ll be working with tables in the same database. However, how do you query related data when your tables are spread across multiple databases? Fortunately, CakePHP makes this a breeze with the CakePHP model’s ‘useDbConfig’ variable and a little table prefix manipulation I picked up from this post in the CakePHP Google group.

Before the detailed explanation, you can view a working demo. Please note, this demo assumes you have basic knowledge of Cake models and associations.

(more…)

Sticky pixels installation #2

Saturday, November 21st, 2009

My Post-it interpretation of Shepard Fairey’s Obama campaign poster poster was such fun that I undertook another Post-it piece. This one is 10 feet high by 7.5 feet wide and used 12 different colors from 6 different stacks of Post-its for a total of 828 sheets. The black pixels are of course using the wall color. It took around 10 hours to put together. Click the photos below for more detail.

This time I won’t give away who it is. Can you guess? If so, please leave a comment below. Hint: The image is based on a GQ cover.

Pixel art Post-its 1 of 5


Pixel art Post-its 2 of 5

(more…)