Was wondering if I can have HTML run an SQL query?

[PuddinPie]

Hello,

I don't know if this is the right forum or not but I was wondering if it was possiable to have an HTML page and when a user fills it out and clicks submit it dumps all the information into a
database" table.

I assume it would be and SQL call but I'm not quite sure how to code it.
Can anybody tell me or direct me to a page that can?
Thank you.

 

[pbaldy]

To the best of my inadequate knowledge, you can't do it with just HTML. You can use ASP, PHP, etc. Here's an ASP example:

http://www.asp101.com/samples/form_to_db.asp

 

[darbid]

Hello,

I don't know if this is the right forum or not but I was wondering if it was possiable to have an HTML page and when a user fills it out and clicks submit it dumps all the information into a
database" table.

I assume it would be and SQL call but I'm not quite sure how to code it.
Can anybody tell me or direct me to a page that can?
Thank you.

My first question is why?

Access Forms etc do this quite well.

If you are only wanting to use Access and HTML then the only way I could do this is to create my HTML as a form with a submit. The submit basically collects all the information and puts it into a comma (or separated string as a fake URL and then tries to navigate to that url

I would then host my html on an access form with the IE control. The Control has an event BeforeNavigate.

When your submit is clicked and it tries to navigate you Cancel the navigation in this event and retrieve the URL from the browser. Then you parse the string to make your Update SQL the usual way.