21,886
社区成员
发帖
与我相关
我的任务
分享
<?php
$host = "127.0.0.1";
$user = "sa";
$password = "abc2350";
$database = "Pmc_News";
$conn = mssql_connect($host,$user,$password) or die("链接数据库失败");
$dbname = mssql_select_db($database,$conn);
?>
<?php
require_once("mssql.php"); //如果这句放在这里,那样在我的index.php页面的两个<select>下拉列表就获取不到数据,显示我定的错误信息“提取数据失败”
function FillNameList()
{
//require_once("mssql.php");如果这句放在这里,index.php页面的一个<select>可以获取到数据,另外一个就获取不到数据。
$sql = "SELECT ID,UserName FROM Student";
$list = mssql_query($sql,$conn) or die ("提取数据失败!");
if ($list)
{
$totalNum = mssql_num_rows($list); //记录总条数
if ($totalNum != 0)
{
while ($row = mssql_fetch_row($list))
{
echo "<option value='$row[0]'>$row[1]</option>";
}
}
}
}
?>
<?php
require_once("biz.php");
function CreatePointList()
{
for($i=0;$i<=10;$i++)
{
echo "<input type='radio' value='$i' name='point'>".$i;
}
}
?>
<html>
<head>
<title>Grade</title>
</head>
<body>
<form id="form1" action="" method="POST">
<table style="border:solid 1;width:400px;">
<tr>
<td colspan="2" align="center">
<span>评分</span>
</td>
</tr>
<tr>
<td width="150px">
<span>我的名字:</span>
</td>
<td width="250px;">
<select name="myName">
<?php FillNameList(); ?>
</select>
</td>
</tr>
<tr>
<td width="150px">
<span>被评分人:</span>
</td>
<td width="250px">
<select name="otherName">
<?php FillNameList(); ?>
</select>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<?php CreatePointList(); ?>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="评分">
<input type="button" value="查看" onclick="javascript:location.href='showlist.php';">
</td>
</tr>
</table>
</form>
</body>
</html>
<?php
require_once("mssql.php");
function FillNameList()
{
global $conn; //声明是用全局的$conn
$sql = "SELECT ID,UserName FROM Student";
$list = mssql_query($sql,$conn) or die ("提取数据失败!");
if ($list)
{
$totalNum = mssql_num_rows($list); //记录总条数
if ($totalNum != 0)
{
while ($row = mssql_fetch_row($list))
{
echo "<option value='$row[0]'>$row[1]</option>";
}
}
}
}
?>