my dad says i'm clever
November 26, 2002, 10:19 pmI have a bunch of other stuff to talk about, but I don't feel like it right now so I'll keep it short.
I did some fancy stuff at work today. I figured out the solution for making stuff that one would put in a .htaccess file with Apache work on IIS: php supports these values in a per directory basis through the use of the Windows Registry. For example, if I have a directory C:Inetpubnickelwound that has a webapplication and I want to set php's include_path, auto_prepend_file, & auto_append_file directives, I simply add the following keys to the registry:
- HKEY_LOCAL_MACHINE\SOFTWARE\PHP\
- Per Directory Values\C\Inetpub\nickelwound\
- include_path - C:\Inetpub\nickelwound\includes
- auto_prepend_file - C:\Inetpub\nickelwound\includes\header.php
- auto_append_file - C:\Inetpub\nickelwound\includes\footer.php
- Per Directory Values\C\Inetpub\nickelwound\
If you view the source of this entry, you can see some really ridiculous unordered lists going on!
If that weren't enough, JB and I took our php framework which uses PEAR and MySQL that was developed on a linux box, and installed it on a Win2K box with a MS SQL Server backend. After I got the stuff in the .htaccess file taken care of in the Registry, we ported over the database and, for the most part, it works! PHP is a great thing... making webapplications so easily portable is awesome!
And as if that weren't fancy enough, when I got home from school, I got around to compiling and installing mod_log_sql: an Apache module used for writing access logs to a SQL database. It's now running my diary application and I'm going to update the Diary User Stats page to use the new table soon. I'd like to build in some graphing and some drill-down/roll-up functionality. If I make it fancy enough, I could GPL it...