Basic knowledge that ASP must have

This article introduces some basic knowledge about ASP, which must be known to all ASP newbies. I hope it will be helpful to you, let’s take a look together.

We all know that ASP is the abbreviation of Active Server Page, meaning dynamic server page. ASP is an application developed by Microsoft to replace CGI scripting programs. It can interact with databases and other programs and is a simple and convenient programming tool. The following are some basic knowledge for your reference.

1. Database connection

The following is the quoted content:

1. <%
2. setconn=server.createobject(adodb.connection)
3. conn.opendriver={microsoftaccessdriver(*.mdb)};dbq=&server.mappath(database name)
4. %>

2. Open the database

The following is the quoted content:

1. exec=select* from database table
2. setrs=server.createobject(adodb.recordset)
3. rs.openexec,conn,1,1

Parameter 1, 1 is read

Read content format: <%=rs(field)%>

3. Add record processing program

The following is the quoted content:

1. <%
2. setconn=server.createobject(adodb.connection)
3. conn.opendriver={microsoftaccessdriver(*.mdb)};dbq=&server.mappath(database name)
4. name=request.form(field)name,tel,message is the field value set by submitting the form
5. tel=request.form(field)
6. message=request.form(field)
7. exec=insertinto table name (field) values ​​('+field +') multiple separated by commas
8. conn.executeexec commits using execute
9. conn.close
10. setconn=nothing
11. %>

4. Search Processor

The following is the quoted content:

1. <%
2. name=request.form(field)name, tel is the field value set by the submit form
3. tel=request.form(field)
4. setconn=server.createobject(adodb.connection)
5. conn.opendriver={microsoftaccessdriver(*.mdb)};dbq=&server.mappath(database name)
6. exec=select*from table wherename='+field+'andtel=+field
7. setrs=server.createobject(adodb.recordset)
8. rs.openexec,conn,1,1
9. %>
10. 'The content searched on the page is exported
11. <%
12. dowhilenotrs.eof
13. %><tr>
14. <td><%=rs(name)%></td>
15. <td><%=rs(tel)%></td>
16. <td><%=rs(time)%></td>
17. </tr>
18. <%
19. rs.movenext
20. loop
21. %>

5. Delete record processing program

The following is the quoted content:

1. <%
2. setconn=server.createobject(adodb.connection)
3. conn.opendriver={microsoftaccessdriver(*.mdb)};dbq=&server.mappath(database name)
4. exec=delete*from table name where number=&request.form(id)
5. conn.executeexec
6. %>

6. Modify the record processing program

The following is the quoted content:

1. <%
2. setconn=server.createobject(adodb.connection)
3. conn.opendriver={microsoftaccessdriver(*.mdb)};dbq=&server.mappath(database name)
4. exec=select*from table name where number=&request.form(id)
5. setrs=server.createobject(adodb.recordset)
6. rs.openexec,conn,1,3'1,3 is the meaning of modification
7. rs(name)=request.form(field)'name,tel,message is the field value set by submitting the form
8. rs(tel)=request.form(field)
9. rs(message)=request.form(field)
10. rs.update
11. rs.close
12. setrs=nothing
13. conn.close
14. setconn=nothing
15. %>

Modify record execution program: Enter ID number page >>> Export corresponding ID data >>>>>>> Directly modify the handler

7. Examples of background login processing programs

The following is the quoted content:

1. <%
2. dimname, password
3. name=request.form(name)
4. password=request.form(password)
5. dimexec,conn,rs
6. exec=select*from table name where(name='&field&'andpassword='&field&')
7. setconn=server.createobject(adodb.connection)
8. conn.opendriver={microsoftaccessdriver(*.mdb)};dbq=&server.mappath(database name)
9. setrs=server.createobject(adodb.recordset)
10. rs.openexec,conn
11. ifnotrs.eofthen
12. rs.Close
13. conn.Close
14. session(checked)=yes
15. session(check)=right
16. response.Redirectindex.asp
17. else
18. session(checked)=no
19. session(check)=wrong
20. response.Redirectlogin.asp
21. endif
22. %>

Each background page plus:

1. <%ifnotsession(checked)=yesthen's session defines a checked string variable
2. response.Redirectlogin.asp
3. else
4. %>

I hope that the above introduction to the basic knowledge of ASP can bring some help to beginners.