TheDemoSite.co.uk  sample code: ASP and MySQL - PHP and MySQL - phpFormMailer - ASP Contact form 
asp code examples with database connectivity

ASP and MySQL
sample code

  Just examples of ASP code, linking to your MySQL database and JavaScript.
|1. Home |2. The Database |3. Add a User |4. Login |5. Get your db online|

asp code examples with database connectivity

This page shows the ASP and JavaScript code used in the "Add a User" section.

addauser.asp

<!--#INCLUDE FILE="header.inc"-->
<!--#INCLUDE FILE="validateform.inc"-->
<blockquote>
<p>Below is the current single record within the database: </p>
</blockquote>

<blockquote>
<blockquote>
<!--#INCLUDE FILE="getrecord.inc"-->
</blockquote>
</blockquote>

<blockquote>
<p>Add your own username and password, enter your details below and click save.&nbsp; <strong>DO
NOT</strong> use valid details as the details you enter will be displayed above and the
next visitor will view them as you are now.</p>
</blockquote>

<form ACTION="savedata.asp" name="saveform" METHOD="POST" align="center">
<div align="center"><center><table border="0" height="59" width="314" bgcolor="#800080"
cellspacing="1" cellpadding="0">
<tr>
<td width="248" height="19" bgcolor="#C0C0C0"><div align="right"><p><font color="#000000"><small>Your
test username:</small></font></td>
<td width="123" height="19" bgcolor="#C0C0C0"><div align="left"><p><input NAME="username"
VALUE SIZE="8" MAXLENGTH="16" tabindex="1"></td>
<td width="51" height="19" bgcolor="#C0C0C0" align="center"><div align="center"><center><p><a
href="javascript:alert('The username must be between 4 and 16 characters long.')"><small><small>Help</small></small></a></td>
</tr>
<tr align="center">
<td width="248" height="17" bgcolor="#C0C0C0"><div align="right"><p><font color="#000000"><small>Your
test password:</small></font></td>
<td height="17" width="123" bgcolor="#C0C0C0"><div align="left"><p><input type="password"
name="password" size="8" tabindex="2" maxlength="8"></td>
<td width="51" height="17" bgcolor="#C0C0C0" align="center"><a
href="javascript:alert('The password must be between 4 and 8 characters long.')"><small><small>Help</small></small></a></td>
</tr>
<tr align="center">
<td width="248" height="1" bgcolor="#C0C0C0"></td>
<td width="123" height="1" bgcolor="#C0C0C0"><div align="left"><p><input TYPE="button"
NAME="FormsButton2" VALUE="save" ONCLICK="validateForm()" tabindex="3"></td>
<td width="51" height="1" bgcolor="#C0C0C0" align="center"><a
href="javascript:alert('Click to save the details')"><small><small>Help</small></small></a></td>
</tr>
</table>
</center></div>
</form>

<p align="center">&nbsp;</p>

<p align="center"><a href="addausercode.asp">Click here to view the ASP and JavaScript
code</a> used for this page.</p>

<p align="center">&nbsp;</p>
<!--#INCLUDE FILE="footer.inc"-->

 

validateform.inc

 

db_conn.asp

<%
//MySQL and ASP demo code
set rsE = Server.CreateObject("ADODB.Recordset")
rsE.ActiveConnection = "Driver={MySQL ODBC 5.1 Driver}; DATABASE=yourDBname;USER=yourUsername; PASSWORD=yourpass; Server=127.0.0.1"
%>

*you MUST replace: yourDBname, yourUsername and yourpass with your own details.

getrecord.inc

<!---#INCLUDE FILE="db_conn.asp" --->
<%
//MySQL and ASP demo code

strQ = "SELECT * from members"
rsE.Open strQ

While Not rsE.EOF
Response.Write "<h3>The username:</b> " & rsE("username") & "</br>"
Response.Write "The password:</b> " & rsE("password") & "</h3>"
rsE.MoveNext
Wend

rsE.close
Set rsE = Nothing
%>

 

savedata.asp

<!---#INCLUDE FILE="db_conn.asp" --->
<%
//MySQL and ASP demo code

strQ = "UPDATE members SET username = '" & Request.Form("username")
strQ = strQ & "', password = '" & Request.Form("password") & "'"

rsE.Open strQ

Response.Redirect("addauser.asp")
%>

< Go Back<


ASP.TheDemoSite.co.uk is a MySQL database and ASP code example site. 
The database and ASP scripts are all hosted on:
Janet approved Registrar for AC.UK and GOV.UK domain names - Seiretto Ltd Copyright .  All rights reserved.
Sample code: ASP and MySQL - PHP and MySQL - phpFormMailer - ASP Contact form