Can we use CMS with a page form to collect data from visitors?

3 posts by 2 authors in: Forums > CMS Builder
Last Post: April 28, 2009   (RSS)

By (Deleted User) - April 28, 2009

We want to have a form to collect data from a visitor and it should go into the database. We want to be able to “Approve” the listings before it goes live.

Right now we just have a regular web form that arrives via email after submit. Our client then manually adds it to the database (which is by the way built using “Listing Manager”).

Just thinking that one option would be to create a username & password for guest posting. Limit the amount of items lets say to 20 for that user (to prevent spam, etc). and selecting not to publish this users listings. Then, our client will manually change the author to lets say and administrator once it is approved. Is that a good idea? On average they don’t get more than a few entries a day and expect it to stay the same in the future.

Re: [RapidWeb] Can we use CMS with a page form to collect data from visitors?

By Dave - April 28, 2009

Hi RapidWeb,

I've attached a sample add form that will insert a record into the database. If you create a checkbox called 'hidden' in the CMS and set that to 1 by default for new records created with the add form that should do what you want.

Another approach is to setup user accounts as you suggested. Just create the same 'hidden' checkbox field and make it admin only (in the field editor) with a default value of checked. Then users won't be able to set records to un-hidden, only admins will.

Hope that helps!
Dave Edis - Senior Developer
interactivetools.com
Attachments:

addform_005.php 3K