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
---------+-----------+------------------------------------------------
     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

Hi,

I would serialize to JSON instead of XML.
http://www.aurore.net/projects/php-json/

A simple json_encode($_POST) might do the trick. You could either use json_decode() to make a PHP struct of it or send it more or less as it is to Javascript.

I usually find XML horrible to work with in a web context.

Best regards,
Marcus


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to