a long overdue geeking out
Mar. 7th, 2004 01:39 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
acroyear100 lines of php.
that's it.
nothing more.
100 lines of php.
and i've got a completely database driven web site for the MS Fantasy Ball.
in 100 lines
and a f'in' ton of SQL.
the funky part is that i'm storing SQL inside SQL tables, combined with a little recursion and a template system inspired by the %%WHATEVER%% syntax of the LJ themes. there's quite a bit of "logic" (concat and if functions, not often used in "normal" sql) embedded into the database, and a couple of early decisions had serendipitous advantages later on. After a while, I'd realized I hadn't added a single line of php in over an hour; all the work was done playing around with SQL to get the query and results just right; the php framework was really already done.
this is, probably, among the most elegant pieces of work I've ever produced.
Meanwhile, Steve Hogarth would like to thank Scotland, and banish all the smart-assed one-liners that ran through his mind. (well, 15 months ago anyways)
and i'm only on my 4th drink since 6pm...and still have to create a page (yeah, more php than sql this time) to allow others of the MSFB staff to update pages. That *might* wait 'til tomorrow (crap, it is 1:45am), though it puts more of a hassle on coming up with the CSS page during the week when time is scarce...
I don't do the all-nighter thing that often anymore.
that's it.
nothing more.
100 lines of php.
and i've got a completely database driven web site for the MS Fantasy Ball.
in 100 lines
and a f'in' ton of SQL.
the funky part is that i'm storing SQL inside SQL tables, combined with a little recursion and a template system inspired by the %%WHATEVER%% syntax of the LJ themes. there's quite a bit of "logic" (concat and if functions, not often used in "normal" sql) embedded into the database, and a couple of early decisions had serendipitous advantages later on. After a while, I'd realized I hadn't added a single line of php in over an hour; all the work was done playing around with SQL to get the query and results just right; the php framework was really already done.
this is, probably, among the most elegant pieces of work I've ever produced.
Meanwhile, Steve Hogarth would like to thank Scotland, and banish all the smart-assed one-liners that ran through his mind. (well, 15 months ago anyways)
and i'm only on my 4th drink since 6pm...and still have to create a page (yeah, more php than sql this time) to allow others of the MSFB staff to update pages. That *might* wait 'til tomorrow (crap, it is 1:45am), though it puts more of a hassle on coming up with the CSS page during the week when time is scarce...
I don't do the all-nighter thing that often anymore.
