Linde002::PHP

For people like me who develop on and for windows (at times) and who like to use MySQL’s stored procedures here’s a quick tip.
Some PHP versions give the following warning when you call stored procedures in PDO.

(more…)

For a project I’m working on I needed to find the distances between two points to be able to let users ask the application questions like: “How many points of type X (coworkers, jobs, gas stations, donutshops) are within a radius of point y (my home, my office, my previous donut shop). Or what is the nearest point x from point y.

I solved this problem with a stored procedure. Below the click are two stored procedures that achieve the same goal.

(more…)

I just received an email from my soon to be countryman Cal Evans with the compiled results from the ZendCon evaluations forms. The results weren’t as bad as I feared but not as good as I hoped either. In summary, Most of the people were pleasantly suprised by my presentation, liked my humor and would like to see me again. The comments did show the inherent problem with making jokes during a presentation, which is that not everybody is bound to like your kind of humor or your humor to information ration.

Detailed info below.

(more…)

For a project for the PHP expertise group at Sogeti that I’m doing I’ve started to work with jQuery and the Google Maps API, something I should’ve done way earlier but I just didn’t get around to it. First of all let me say that both jQuery and the GMaps API are excellent pieces of software*,  they are both easy to implement and use and there’s tons of documentation available (something that we can’t say for all public API’s…. Yes, I’m looking at you hyves).

(more…)