article.asp

来自「1. 在界面的开头显示新闻添加的位置」· ASP 代码 · 共 72 行

<!--#include file="conn.asp"-->
<% 
dim rs,strsql,title,content,author,tuijian,classid
title=request.form("title")
content=request.form("content")
author=request.form("author")
tuijian=request.form("tuijian")
classid=request.form("class")
set rs=server.CreateObject("ADODB.Recordset")
insertsql="insert into article(title,content,author,tuijian,classid,visitnum) values('"&title&"','"&content&"','"&author&"','"&tuijian&"','"&classid&"',0)"
modsql="update article set title='"&title&"',content='"&content&"',author='"&author&"',tuijian='"&tuijian&"',classid='"&classid&"' where articleid="&request.QueryString("articleid")
%>
<!--#include file="head.asp"-->
</div>
<br>
<table width="779" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="##0066CC">
  <tr>
    <td width="180"align="left" valign="top" scope="row">　
      <table width="100%" height="100%" border="0">
        <tr><td align="center" valign="top" scope="row"><!--#include file="login.asp"--></tr>
		<tr><td align="center" valign="top" scope="row"><!--#include file="hot.asp"--></tr>
		<tr><td align="center" valign="top" scope="row"><!--#include file="tuijian.asp"--></td></tr>
	  </table>
		
    </td>
	
    <td width="490" align="center" valign="top">
	<table width="100%" align="center" cellpadding="0" cellspacing="0">
      <tr height="30"><td></td></tr><tr bgcolor="#003399" valign="top">
        <td valign="top" align="center">
	    <%
		if request.form("update")="update" then
        rs.open modsql,conn
		else
		rs.open insertsql,conn
		end if
        %>
       发表成功！<a href="admin.asp">返回</a>
		</td>
		</tr>
		</table>
		</td></tr>
    </table></td>
	<td width="120"align="left" valign="top" scope="row">　
      <table width="100%" height="100%" border="0">
        <tr><td align="center" valign="top" scope="row"><table><tr>
          <td align="center" valign="top" scope="row">管理登陆</td>
        </tr>
		<tr><td align="center" valign="top" scope="row"><form action="/admin/login.asp" method="post">
		<p>用户名：<input type="text" name="name" size="10">
		<p>密&nbsp;&nbsp;码：<input type="password" name="password" size="10">
		<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" value="登陆" style="background-color:#ffffff">&nbsp;<input type="reset" value="登陆"style="background-color:#ffffff ">
		</form></td></tr></table></tr>
		<tr><td align="center" valign="top" scope="row"><table height="200">
		<tr>
          <td align="center" valign="top" scope="row">热门文章</td>
        </tr></table></tr>
		<tr><td align="center" valign="top" scope="row"><table height="200">
       <tr>
          <td align="center" valign="top" scope="row">热门图片</td>
		  <td>
		  </td>
        </tr></table></td></tr>
	  </table>
		
    </td>
  </tr>
</table>
  <p align="center">Copyright (C) 2004 Tie8.Studio All Rights Reserved </p>
    <p align="center">版权所有 铁吧</p>
</body>
</html>