ASP advanced article online Management Update-Administrator & column Management
Author: Beach Boy
The previous chapters have basically implemented most of the functions of the article management system, but in this system, the administrator name and password as well as the column update to their own in the database operation, so that does not fully realize the complete system of online management update, so I recently to the management system has been further improved, it added a related function , realize the real sense of the article Management System online Management update!
Implementation of these functions is also through the update of the database and even new content to achieve, where the use of database Operations Command Updata and AddNew is the key, where the Updata, where the use of AddNew here can be reflected, the following for you to introduce their detailed implementation process!
File changepass.asp
"Open the database connection file
<!--#include file= "conn.asp"-->
<%
"Restrict administrative users to access
If Request.Cookies ("Adminok") = "" Then
Response.Redirect "Login.asp"
End If
%>
<meta http-equiv= "Content-type" content= "text/html; charset=gb2312 ">
<title> Modify password column information </title>
<meta name= "generator" content= "Microsoft FrontPage 3.0" >
<link rel= "stylesheet" type= "Text/css" href= "Style.css" >
<body>
<div align= "center" ><center>
<font face= italics _gb2312 size=4> web Article Admin Admin page </font>
<table border= "1" width= "80%" bordercolorlight= "#000000" cellspacing= "0" cellpadding= "0"
bordercolordark= "#FFFFFF" >
<%
Dim rs,tsql
Dim rst
"Open recordset admin and display its contents
Set Rs=server. CreateObject ("ADODB.") RecordSet ")
Set Rst=server. CreateObject ("ADODB.") RecordSet ")
Rs.Open "SELECT * from admin", conn,1
%>
<tr>
<TD width= "50%" Align=center><form name=pass method= "POST" action= "changepass.asp" >
