|
Web form data into a database
I have two forms on my Web site, and I would like to capture any entered data into a database.
I use a paid host for the site. It's a Unix-based server using Zeus. It allows FrontPage extensions but not FrontPage's "send to database" functionality that would easily capture the form data to an Access db on the server.
Ideally, I would like to capture all the form data to an Access db on the host server.
Alternately, I would be happy to capture it in a MySQL database or even into tab-delimited text since I can import that information easily into Access.
I'm not sure what the process is to do any of this, so I may be missing other solutions.
Is the answer here:
--somehow modifying my CGI-script (formmailer.pl, not to be confused with formmail.pl)
--using a different CGI-script
--creating/acquiring an additional PHP script
--copying my form HTML code into a form-generating software that has database delivery already built in
--something else?
I really need direction on what the next steps are. I'm a newbie, but I got through building the forms by hand and properly developing the CGI-script in a day and a half, and I'd never heard of it before then. I'm eager to learn!
Thanks so much for any tips on how to store Web form data into a database.
|