Directing web forms to numerous databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a newsletter subscribe form on our website. I would like to have the
data
(name, email address, city, state etc) recorded in my subscribe table in
Access. Additionally, I want to have the same data recorded to other
databases if the subscriber chooses various areas of interest from a check
box on the website form. Where do I start?
 
I have a newsletter subscribe form on our website. I would like to
have the data
(name, email address, city, state etc) recorded in my subscribe table
in Access. Additionally, I want to have the same data recorded to
other databases if the subscriber chooses various areas of interest
from a check box on the website form. Where do I start?

First you have to get the form POST data to a programmable computer.

If you can script the website itself, you use whatever scripting
language is available: PHP or ASP or etc. Presumably the database is on
the webserver so it's all self-contained. You set the action attribute of
the form to your script, and the method attribute to post.

If you can't use scripts, then you should be able to have the website
email the entire form contents to you: you can then write a parsing
routine to get the relevant fields out of the email and into the
database.

Just one comment: the phrase "other databases" fills me with dread. Do
you mean other tables in the same database?

Best wishes


Tim F
 
Back
Top