Re: slightly OT - forms in database

From	Denis McMahon <denismfmcmahon@gmail.com>
Newsgroups	comp.lang.php
Subject	Re: slightly OT - forms in database
Date	2015-02-08 13:33 +0000
Organization	A noiseless patient Spider
Message-ID	<mb7oj4$10f$2@dont-email.me> (permalink)
References	<7a98b02a-f124-4fda-ad08-76852a689af3@googlegroups.com>

Show all headers | View raw

On Sun, 08 Feb 2015 01:47:42 -0800, tim wrote:

> Q1: is it OK to store this as json or seralize in a database field in a
> row? As we don't need to search and don't want to create many empty
> columns?

I would suggest not. Your requirements may change.

> Is there another option? What about storing the form design and answers
> in an XML file?

What about a table:

formid | questionid | answer

Now you have no empty columns, and one answer per record.

> The other question is - do you manually build the form design in PHP or
> has anyone used a database driven form builder before?

I generally build the form manually in html.

-- 
Denis McMahon, denismfmcmahon@gmail.com

Thread

slightly OT - forms in database tim@timothyarnold.co.uk - 2015-02-08 01:47 -0800
  Re: slightly OT - forms in database "J.O. Aho" <user@example.net> - 2015-02-08 11:17 +0100
  Re: slightly OT - forms in database Denis McMahon <denismfmcmahon@gmail.com> - 2015-02-08 13:33 +0000
  Re: slightly OT - forms in database Jerry Stuckle <jstucklex@attglobal.net> - 2015-02-08 09:02 -0500
    Re: slightly OT - forms in database Matthew Carter <m@ahungry.com> - 2015-02-08 15:41 -0500
      Re: slightly OT - forms in database Jerry Stuckle <jstucklex@attglobal.net> - 2015-02-08 16:09 -0500
      Re: slightly OT - forms in database Denis McMahon <denismfmcmahon@gmail.com> - 2015-02-08 21:53 +0000
        Re: slightly OT - forms in database Matthew Carter <m@ahungry.com> - 2015-02-08 21:39 -0500
      Re: slightly OT - forms in database Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-02-09 00:52 +0100

csiph-web