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: (view raw, whole thread or download thread mbox)
Lists: pgsql-general

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.



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-2017 The PostgreSQL Global Development Group