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