Re: [phplib] default authentication, anyone using it? From: Richard Archer (rha <email protected>)
Date: 08/06/01

At 9:16 PM +0000 6/8/01, Kristian Koehntopp wrote:

>Wrap this additional table design overhead into code, and
>creating additional columns for additional data items is as
>simple as $user->register("age") - but at much better
>performance than XML BLOBs could ever hope to have.

I've got a customer that posts online surveys. The survey results all
get inserted into a database.

I got sick of adding new columns to the table every time they added a
new question to their survey, so I changed the script to convert the
form field name into a column name, check to see if that column exists,
if not create it on the fly (blob type), then insert the data.

It's susceptible to DoS attacks if a malicious user decides to write a
script to post submissions with hundreds of new column names, but has
worked well so far.

And having all the data in columns makes data analysis a dream (even if
the blobs do slow things down... still better than having to unpack a
composite of the whole form).

 ...R. 

-- 
Abbestellen mit Mail an:   phplib-unsubscribe <email protected>
Kommandoliste mit Mail an: phplib-help <email protected>