PDA

Click to See Complete Forum and Search --> : Form submit to database

jburatti
04-21-2009, 11:26 AM
Hello. I posted a question a few weeks ago that was never answered. I thought that it was a simple question and common practice, so I’m going to try again but in different wording.
I designed a web form for people to signup for my businesses’ service and I need it to copy/post all the submitted inputted form data from the user to a database (preferably Access because I know it pretty well, and very new to SQL). I read through most of w3schools.com website several times but still couldn't figure how to post to a database. What I understood from w3schools.com is how to have that information redisplay to the user on the next page, but how do I save the inputted data and access it for processing later?
TheBearMay
04-21-2009, 11:51 AM
What language are you using on the server (i.e. JAVA, ASP.Net, PHP)? If you don't have anything available server side, then you'll probably have to resort to opening up their email client with the data and asking them to hit their email client's send button.
jburatti
04-21-2009, 09:16 PM
I use Yahoo as my host and they support PHP and SQL but not ASP. So to answer your question I would be using PHP, but I dont know it very well yet.
eCat
04-23-2009, 02:10 PM
Creating a form that connects to a database is not "simple" - I'm not sure about "common practice" either!

You have use use a language like PHP to code your form fields so that they correspond to database fields; then you have to build your database with something like MySQL; then you have to write the code that connects your form to the database; then you have to use phpMyAdmin (or something like that) to access the information that gets stored in the db.

If you have time & want to learn, I would suggest browsing the PHP/MySQL forums that are on this site.

Or, you could use software designed for such a thing:

http://www.webdeveloper.com/forum/showthread.php?t=186519 :D

There are many other products out there but most of them only do one part of the "package" (that being form, database & admin module). You can do a google search.

Good luck!

eCat