Form that writes to a CMS table https://interactivetools.com/forum/forum-posts.php?Form-that-writes-to-a-CMS-table-72280 Fri, 06 Mar 2026 12:07:56 -0800 en-us Re: [zip222] Form that writes to a CMS table https://interactivetools.com/forum/forum-posts.php?postNum=2211426#post2211426
I'm also a proponent of using CAPTCHA in my forms instead of "hidden" fields. I find that actively filling in a CAPTCHA code field gives the person filling out the form the feeling that their information is somehow safer.

I originally used the Google app, but switched to using a program called CAPTCHA creator. I find it much easier to customize then the Google app.

Just in case you want to do some other things with your form, I've attached a fairly comprehensive set of php files that I've used for signing up members for a client of mine's website. (I changed paths and web addresses to generic ones for the samples)

There's error checking, automatic posting to hidden fields, automatic display of existing data, and more, including how to work with date fields in your form.

As you discovered, you'll have to have a field in your table you're using for each field referenced in the form.

There are a there are a number of recipes dealing with form customization in my CMSB Cookbook http://www.thecmsbcookbook.com

Hope the attachment helps to clear up some of the finer points.

Jerry Kornbluth
]]> Sat, 21 May 2011 20:04:59 -0700 forum-posts.php?postNum=2211426#post2211426 Re: [northernpenguin] Form that writes to a CMS table https://interactivetools.com/forum/forum-posts.php?postNum=2211425#post2211425 ]]> Sat, 21 May 2011 10:13:40 -0700 forum-posts.php?postNum=2211425#post2211425 Re: [zip222] Form that writes to a CMS table https://interactivetools.com/forum/forum-posts.php?postNum=2211424#post2211424
http://www.google.com/recaptcha/captcha
]]> Sat, 21 May 2011 08:45:15 -0700 forum-posts.php?postNum=2211424#post2211424 Re: [zip222] Form that writes to a CMS table https://interactivetools.com/forum/forum-posts.php?postNum=2211408#post2211408
One thing you can do is randomly generate 3 numbers using rand(). You can then add them together and store the answer in a hidden field. Finally, you display the 3 numbers: (number1 + number2 + number3 = ) with a text box where they type in the answer. If the answer they enter matches you hidden field, it's a valid entry. Otherwise, the page reloads and 3 new numbers are generated.

This is a far from fool proof method, but it could help get you started.

Hope this helps
]]> Fri, 20 May 2011 11:41:18 -0700 forum-posts.php?postNum=2211408#post2211408 Re: [zip222] Form that writes to a CMS table https://interactivetools.com/forum/forum-posts.php?postNum=2211390#post2211390 ]]> Thu, 19 May 2011 10:54:15 -0700 forum-posts.php?postNum=2211390#post2211390 Re: [zip222] Form that writes to a CMS table https://interactivetools.com/forum/forum-posts.php?postNum=2209784#post2209784 ]]> Tue, 22 Feb 2011 17:28:59 -0800 forum-posts.php?postNum=2209784#post2209784 Re: [Jeffncou] Form that writes to a CMS table https://interactivetools.com/forum/forum-posts.php?postNum=2209775#post2209775 ]]> Tue, 22 Feb 2011 14:34:07 -0800 forum-posts.php?postNum=2209775#post2209775 Re: [zip222] Form that writes to a CMS table https://interactivetools.com/forum/forum-posts.php?postNum=2209771#post2209771 ]]> Tue, 22 Feb 2011 14:18:18 -0800 forum-posts.php?postNum=2209771#post2209771 Re: [Jeffncou] Form that writes to a CMS table https://interactivetools.com/forum/forum-posts.php?postNum=2209766#post2209766 ]]> Tue, 22 Feb 2011 13:57:28 -0800 forum-posts.php?postNum=2209766#post2209766 Re: [zip222] Form that writes to a CMS table https://interactivetools.com/forum/forum-posts.php?postNum=2209761#post2209761 ]]> Tue, 22 Feb 2011 13:14:26 -0800 forum-posts.php?postNum=2209761#post2209761 Form that writes to a CMS table https://interactivetools.com/forum/forum-posts.php?postNum=2209750#post2209750 ]]> Tue, 22 Feb 2011 08:39:34 -0800 forum-posts.php?postNum=2209750#post2209750