login
coding coding coding posted: Thu 2012-09-27 19:42:51 tags: tech
Uncovered a bug in Phosphoros (missing $ variable identifier in the delete module). Not earth-shattering, as the point of that little bit of code was just to prevent running a DELETE query against a nonexistent record - which shouldn't even happen if people are using the UI instead of hand-editing URL parameters. Sometime when I have time (and inclination, that's admittedly a resource in shortage when it comes to Phosphoros), I'd like to comb through the code, and rethink the wisdom of passing control data around in URL parms.

So if I'm disinclined to comb through the code for Phosphoros's sake, then why was I digging through Phosphoros? Because it was my first shot at an actually useful CRUD application, and I needed to review how I accomplished a certain database-querying task in PHP, for use in a client's intranet application. Specifically, the one where I'm porting a 14-year-old MS Access application to an XAMP platform. In retrospect, while this would have been possible without JQuery, it would have ended up a lot more clunky. A lot of skills came together and blossomed at the right time to make this not merely possible, but manageable.

Back to Phosphoros for a moment though... it's still rather a mess of commingled HTML, PHP and MySQL, and I wouldn't release it on SourceForge or whatever with another round of serious refactoring effort.