Stroring html form settings

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

Responses

Browse pgsql-general by date

  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)