Asp tutorial html form to database connectivity l.jpg
This presentation is the property of its rightful owner.
1 / 18

ASP Tutorial HTML Form to Database Connectivity PowerPoint PPT Presentation

ASP Tutorial HTML Form to Database Connectivity Database Connectivity (1 of 3) You can connect to the database in two ways. (You can access the following info to discuss the two options.

Related searches for ASP Tutorial HTML Form to Database Connectivity

Download Presentation

ASP Tutorial HTML Form to Database Connectivity

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

Asp tutorial html form to database connectivity l.jpg

ASP Tutorial HTML Form to Database Connectivity

D. Nord

Database connectivity 1 of 3 l.jpg

Database Connectivity(1 of 3)

  • You can connect to the database in two ways. (You can access the following info to discuss the two options. -One more

    • DSN connection (DSN stands for Data Source Name – this method can be used if you already have a server set up for the web pages via ODBC)

    • DSN-less connection (this is an easier way to connect to your database – you do not have to configure your computer to set this up)

  • The following code shows you how to connect to your access database with a DSN-less connection.

D. Nord

Create a database 2 of 3 l.jpg

Create a Database(2 of 3)

  • First create a database named “comments.mdb” using Microsoft Access.

  • Then create a table and name it “commentadd”.

  • Include the following fields in the table:

    • name

    • comments

    • email

D. Nord

Database table before data is entered 3 of 3 l.jpg

Database Table Before data is entered(3 of 3)

D. Nord

Connecting to a database 1 of 5 l.jpg

Connecting to a Database(1 of 5)

  • Next, create a form with the fields you require.

  • Name the file anything you want. Ex: contact.htm

  • In the

    <form method="POST" action="addrecord.asp"> area in the form, change the action=“addrecord.asp” to whatever name you want and include the .asp extension.

D. Nord

Creating the html form 2 of 5 l.jpg

Creating the HTML Form(2 of 5)

  • <html>

  • <head>

  • <title>Feedback Form</title>

  • </head>

  • <body>

  • <p><b><font size="6" face="Century Gothic">Feedback Form</font></b></p>

  • <p><font size="4" face="Century Gothic">Please fill out this form to help us

    improve our site.</font></p>

D. Nord

Slide7 l.jpg

(3 of 5)

  • <form method="POST" action="addrecord2.asp">

  • <p><b>Name: </b>

  • <input name="name" type="text" size="32"></p>

  • <p><b>Comments: </b>

  • <textarea rows="4" name="comments" cols="30"></textarea></p>

  • <p><b>Email Address: </b>

  • <input type="text" name="email" size="26"></font></p>

D. Nord

Slide8 l.jpg

(4 of 5)

  • <p>&nbsp;</p>

  • <p>

  • <input type="submit" value="Submit Your Entries" name="B1"><input type="reset" value="Clear Your Entries" name="B2">

  • </p>

  • </form>

  • </body>

  • </html>

D. Nord

Form page example 5 of 5 l.jpg

Form Page - Example(5 of 5)

D. Nord

Connecting to a database 1 of 8 l.jpg

Connecting to a Database(1 of 8)

  • Next create the ASP response pageand give it the same name as is found in the form in “action=…..”

  • The following slides contain the ASP code to connect to the database.

  • Lines 3 – 6 declare all the variables required.

  • Line 10 - sets up the connection to the database and opens the connection with the database

D. Nord

Code explanation 2 of 8 l.jpg

Code Explanation(2 of 8)

  • Line 19 opens the table in the database using the method.

  • Line 20 - 24 adds new data from the form tothe table using the rs.addnew method.

  • Line 25 - 27 updates the table and moves to end of the record.

  • Lines 28 - 30 closes all the connections to the database.

D. Nord

Connecting to a database 3 of 8 l.jpg

Connecting to a Database(3 of 8)

  • <%@ Language="VBScript"%>

  • <%

  • 'Declare all local variables

  • dim rs

  • dim strconn

  • dim strID

D. Nord

Slide13 l.jpg

(4 of 8)

7.‘Sets up the connection to the database(The entire line 9 must be on one line)

  • set strconn=server.createobject("adodb.connection")

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

  • 'Create an ADO recordset object

  • set rs = server.createobject("adodb.recordset")

  • 'Initialise the strID variable with an SQL statement to query the database

  • strID = "SELECT commentadd.Name, commentadd.comments, FROM commentadd;“

  • 'Set the cursor type we are using so we can navigate through the recordset

  • rs.CursorType = 2

  • 'Set the lock type so that the record is locked by ADO when it is updated

  • rs.lockType = 3

  • 'Open the recordset with the SQL query(the 2,2 deals with writing and locking the table)

  • rs.Open strID, strconn, 2,2

D. Nord

Slide14 l.jpg

(5 of 8)

20. ‘Adds new data from the Form to the Table

21. rs.addnew

22. rs("name") = request("name")

23. rs("comments") = request("comments")

24. rs("email") = request("email")

25. ‘Updates the Table and Moves to end of record

26. rs.update

27. rs.movelast

28. ‘Closes all the connections to the Database

29. set rs = nothing

30. set conn = nothing

31. %>

D. Nord

Slide15 l.jpg

(6 of 8)

32. <html>

33. <head>

34. <title>Thank you</title>

35. </head>

36. <body>

37. <center>Thank you</center><br>

38. <center>Please click <a href="/index.html">here</a>

39. to return to the home page.</center>

40. </body>

41. </html>

D. Nord

Asp response page 7 of 8 l.jpg

ASP Response Page(7 of 8)

This is the response page that is displayed once the form is submitted. This page is generated by the ASP code shown in the previous slides. The message displayed above can be changed to show your own message.

D. Nord

Access database 8 of 8 l.jpg

Access Database(8 of 8)

This is what the database will look like after the form is submitted. The data from the form is saved in the database.

D. Nord

Components and objects these are different than the ado objects l.jpg

Components and Objects(These are different than the ADO Objects)

  • ASP consists of five primarybuilt in objects

    • Application – manages Web application's information

    • Request – retrieves information from a browser for processing at the server

    • Response – transmits information from a Web server to browser

    • Server – controls behavior of a Web server

    • Session – tracks and manages individual user sessions within particular Web application

      The built-in objects are special because they are built into ASP and need not to be declared or created before they can be used in scripts.

D. Nord

  • Login