From: | Dianne Yumul <dianne(at)wellsgaming(dot)com> |
---|---|
To: | PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
Subject: | Stroring html form settings |
Date: | 2008-09-25 21:38:20 |
Message-ID: | B960CF34-EC49-4A5F-B151-51777EA651BB@wellsgaming.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
---------+-----------+------------------------------------------------
111 | 1 | A:::::CHECKED::::CHECKED::::CHECKED::
111 | 2 | A:::CHECKED::
111 | 3 | A::CHECKED:CHECKED::CHECKED::::CHECKED:::
The info column has the settings separated with a : and consecutive
colons mean the user didn't make a selection. Would this be the way
to store them?
I've done some searching and I could use XML (I will read some
tutorials after writing this email). But there may be other ways and
I'm just too much of a newbie to know. I'm using Postgresql 8.1.11
and PHP on CentOS 5.2.
Thanks in advance.
Dianne
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Browne | 2008-09-25 21:50:00 | Re: PostgreSQL future ideas |
Previous Message | Andrew Sullivan | 2008-09-25 21:14:04 | Re: Obfuscated stored procedures (was Re: Oracle and Postgresql) |