當前位置:編程學習大全網 - 源碼下載 - 收到定單後自動發出消息的源碼asp+access

收到定單後自動發出消息的源碼asp+access

兩個頁面,壹個是檢查數據庫的頁面tx.asp,另壹個是彈出的小窗口msg_page.asp

tx.asp代碼如下:

<%

'註意:在數據庫中設立壹個字段isread,表示該訂單有沒有閱讀,0為沒有,1為已閱

'打開數據庫

set conn=server.createobject("adodb.connection")

conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("data.mdb")

set rsB=server.createobject("adodb.recordset")

sqlB="select * from 數據表 where isread=0"

rsB.open sqlB,conn,1,1

if rsB.recordcount>0 then

%>

<script Language="JavaScript">

auditingwindowvar=window.open('','auditingwindow','left=400,top=300,toolbar=no,scrollbars=no,resizable=0,menubar=no,width=152,height=153');

auditingwindowvar.location.href="msg_page.asp?info=您好,有新訂單等待妳審核!&title=訂單審核";

</script>

<%

end if

rsB.close

set rsB=nothing

conn.close

set conn=nothing

end if

%>

<html>

<head>

<meta ">

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<title>消息通知</title>

<link rel="stylesheet" type="text/css" href="../css/css.css">

</head>

<body topmargin="1" leftmargin="1" scroll=no>

<bgsound src="../msg.wav" loop="1">

<table border="0" cellpadding="0" cellspacing="0" width="240" height="83" align="center">

<tr>

<td height="150" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF">

<table border="0" cellpadding="0" cellspacing="0" width="100%" height="121" >

<tr>

<td height="44" align="center"><img border="0" src="../image/msg.gif" align="absmiddle" width="34" height="32"> <font color="#FF0000"><%=title%></font></td>

</tr>

<tr>

<td height="100"><%=info%><p>?</p></td>

</tr>

</table>

</td>

</tr>

</table>

<script language="javascript">

window.focus();

setTimeout("window.close()",8000);

</script>

</body>

</html>

樓主只要將tx.asp包含在妳的網站中即可!

  • 上一篇:織夢如何調用文章摘要織夢如何調用文章摘要寫作手法
  • 下一篇:關於加密解密的驗證問題。
  • copyright 2024編程學習大全網