Create an Access database tutorial Db1.mdb, where you create a datasheet user, the fields are: U_uid (Automatic), U_user (user name: Text type), U_pass (password: text type)
Set up the form data sent from the receiving register.asp, and insert the successful display page of the registration in Datasheet User:
<%
' Method of string connection to database
Set Conn=server.createobject ("Adodb.connection")
Conn.Open "Driver=driver do Microsoft Access (*.mdb); uid=admin;pwd=;d bq=" &server.mappath ("Regdb1.mdb")
%>
Saving data to a database method
<%@ language=vbscript%>
<!--#include file= "con1.asp"-->
<meta http-equiv= "Content-type content=" text/html; charset=gb2312 "/>
<title> Registration succeeded </ Title><br>
<body>
<%
' Establish Recordset object method
Set Rst=server.createobjec T ("Adodb.recordset")
Set Rst1=conn.execute (insert into user (U_user,u_pass) VALUES (' "&request.form (" U_user ") & "', '" "&request.form (" U_pass ") &" ') "
%>
<table width=" 0 "border=" center ">
<tr>
<td align= "center" ></ Td>
</tr>
</table>
</body>
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
