HTML Help -- Form Submit Button.

DarinT

Member
Oct 3, 2000
121
0
0
I'm working on my first HTML project in a while [ http://www.PerfectComputingLLC.com ] and I want to notify the users when the page is complete. So, I want to have a form field were they can enter their email address, and click a submit button. Behind that, I would like for these email addresses to be written to a text file or something along those lines. I'm pretty sure that the hosting company is running IIS 5.0 (nice and patched too, so please don't do anything :) ), so the server can do all of the neat asp stuff if necessary.
Thanks...
-DarinT
 

ugh

Platinum Member
Feb 6, 2000
2,563
0
0
To write the data into a file using ASP, try looking at the FileSystemObject documentation here. This should keep you occupied :D
 

milehigh

Senior member
Nov 1, 1999
951
0
76
Here's a signup form I used for a football pool using Access...


<%
' Grab the HTML Form Fields
name = Request( "name" )
email = Request( "email" )
phone = Request( "phone" )

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\path\file.mdb")

mySQL = "INSERT INTO players ( name, email, phone) VALUES ( '" & name & "','" & email & "','" & phone & "')"

Conn.Execute mySQL

Conn.Close
Set Conn = Nothing
%>

<html>
<head><title>savedata.asp</title></head>
<body>

<Big> You've been added!! Good Luck!! </big>
<a href="default.html"> Return to home page.</a>

</body>
</html>

 

DarinT

Member
Oct 3, 2000
121
0
0
Okay. Here is what I've got for the code so far. I havn't made the Access database yet, but otherwise, does this look okay to you guys?



<form name="email" method="post" action="post">
<input type="text" name="email">
<input type="image" border="0" name="emailbutton" src="images/requpbutton.gif" width="142" height="40">
<%

emailbutton=Request("email")

Set Conn = Server.CreateObject("ADODB.Connection")

Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\database\emailrequest.mdb")

mySQL = "INSERT INTO emailupdates ( email) VALUES ( '" & email & "')"

Conn.Execute mySQL

Conn.Close
Set Conn = Nothing
%>
</form>