Dianne Yumul wrote:
Hello,
I have some html forms that I save the settings into the database,
things like which item was selected in the menu and if a checkbox was
checked. The table looks like this:
user_id | report_id | info
First, I want to thank you for your help. You have made great points
and I just want to respond to some of your questions.
My first thought is that if you use a combined info field, you'll
lose the ability to easily do any kind of meaningful data analysis
based on which boxes are checked. If
which webserver does your client want to implement?
Apache, sorry I forgot to mention.
If JSLibrary = Dojo I would look at JSON (JavaScript Object
Notation language)
I would serialize to JSON instead of XML.
http://www.aurore.net/projects/php-json/
A simple json_encode($_POST) might do
intended recipient. Sender does
not necessarily endorse content contained within this transmission.
From: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Stroring html form settings
Date: Fri, 26 Sep 2008 09:23:21 -0700
To: pgsql-general@postgresql.org
First, I want to thank you for your help. You have
On Fri, 2008-09-26 at 09:23 -0700, Dianne Yumul wrote:
If the structure of each report did not differ this would work great
but unfortunately it does.
Diane-
Would an EAV model work? I'm thinking something like form,field,value.
For example:
formA,ckbox1,true
formA,input1,initial value
Would an EAV model work? I'm thinking something like
form,field,value. For example:
formA,ckbox1,true
formA,input1,initial value
formB,textarea1,enter your long comment here
You could easily extend this to user,form,field,value, or
normalize it as you see fit.
This would work great too. If
Hello,
I have some html forms that I save the settings into the database,
things like which item was selected in the menu and if a checkbox was
checked. The table looks like this:
user_id | report_id | info
On Thu, Sep 25, 2008 at 5:38 PM, Dianne Yumul [EMAIL PROTECTED] wrote:
Hello,
I have some html forms that I save the settings into the database, things
like which item was selected in the menu and if a checkbox was checked. The
table looks like this:
user_id | report_id |
.
To: pgsql-general@postgresql.org
From: [EMAIL PROTECTED]
Subject: [GENERAL] Stroring html form settings
Date: Thu, 25 Sep 2008 14:38:20 -0700
Hello,
I have some html forms that I save the settings into the database,
things like which item was selected in the menu and if a checkbox