Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Chris BrowneDate: 2008-09-25 21:50:00
Subject: Re: PostgreSQL future ideas
Previous:From: Andrew SullivanDate: 2008-09-25 21:14:04
Subject: Re: Obfuscated stored procedures (was Re: Oracle andPostgresql)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group