作者apson (小李)
看板CSMU-HSA95
标题[心得] homework.php
时间Mon Jun 2 11:23:08 2008
<!doctype html public "-//W3C//DTD HTML 4.01//EN">
<html>
<head>
<title>作业查询</title>
<meta http-equiv="generator" content="PHP Designer 2005" />
</head>
<body bgcolor="#FFFFFF" text="#000000" link="#0000FF" vlink="#800080"
alink="#FF0000">
<br>
<center><font size="5">作业缴交情况与下载</font></center>
<br>
<table border="1" cellspacing="1" cellspadding="1" align="center">
<tr>
<td align ="center" bgcolor ="#ffffcc" width ="15%"><font size="2"
color="Blue">学号</font></td>
<td align ="center" bgcolor ="#ffffcc" width ="25%"><font size="2"
color="Blue">作业名称</font></td>
<td align ="center" bgcolor ="#ffffcc" width ="15%"><font size="2"
color="Blue">姓名</font></td>
<td align ="center" bgcolor ="#ffffcc" width ="12%"><font size="2"
color="Blue">缴交日期</font></td>
<td align ="center" bgcolor ="#ffffcc" width ="25%"><font size="2"
color="Blue">档案名称</font></td>
<td align ="center" bgcolor ="#ffffcc" width ="6%"><font size="2"
color="Blue">下载</font></td>
</tr>
<?php
////////******************************////////
////////
////////******************************////////
$intODBCConnectHandle = odbc_connect("WORKODBC","Sa","") ;
if ($intODBCConnectHandle != 0)
{
$intOpenTableResultID = odbc_exec($intODBCConnectHandle,
"SELECT * FROM homework") ;
$varDataArray = odbc_fetch_array ($intOpenTableResultID) ;
while (strlen($varDataArray) > 0)
{
echo "<tr>" ;
echo "<td bgcolor='#FFFF99' align='center'><font size='2'
color='Blue'>",
$varDataArray[studentno],"</font></td>" ;
echo "<td bgcolor='#FFFF99' align='center'><font size='2'
color='Blue'>",
$varDataArray[workname],"</font></td>" ;
echo "<td bgcolor='#FFFF99' align='center'><font size='2'
color='Blue'>",
$varDataArray[name],"</font></td>" ;
echo "<td bgcolor='#FFFF99' align='center'><font size='2'
color='Blue'>",
$varDataArray[nowDate],"</font></td>" ;
echo "<td bgcolor='#FFFF99' align='center'><font size='2'
color='Blue'>",
$varDataArray[fileNameSet],"</font></td>" ;
echo "<td bgcolor='#FFFF99' align='center'><font size='2'
color='Blue'>
<a href='
http://localhost/Temp/",$varDataArray[fileNameSet], "'>档案
下载</a></td>" ;
echo "</tr>" ;
$varDataArray = odbc_fetch_array ($intOpenTableResultID) ;
}
odbc_close ($intODBCConnectHandle) ;
}
else
{
echo "ERROR-资料库连结失败 !!!" ;
}
?>
</table>
</body>
</html>
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.128.142.226