代码如下~!
<?phpsession_start();
/*if ($_SESSION["username"]=="")
{
header("Location:index.php");
exit();
}*/
include("db_conn.php");
include("db_func.php");
$ShowCourse_sql="select * from Course order by CouNo";
$ShowCourseResult=mysql_query($ShowCourse_sql);?>
<html>
<head>
<META http-equiv=Content-Type content="text/html; charset=utf8"/>
<title>课程信息显示</title>
</head>
<body><center>点击课程编码连接可以查看课程细节</center>
<TABLE width=“610” border="0" align="center" cellpadding="0" cellspacing="1">
<tr bgcolor="#0066cc">
<td width="80" align="center"><font color="#FFFFFF">课程编码</font></td>
<td width="220" align="center"><font color="#FFFFFF">课程名称</font></td>
<td width="80" align="center"><font color="#FFFFFF">课程类别</font></td>
<td width="50" align="center"><font color="#FFFFFF">学分</font></td>
<td width="80" align="center"><font color="#FFFFFF">任课教师</font></td>
<td width="80" align="center"><font color="#FFFFFF">上课时间</font></td>
</tr>
<?php
if(mysql_num_rows($ShowCourseResult)>0)
{
$number=mysql_num_rows($ShowCourseResult);
$check=$p+10;
for($i=0;$i<$number;$i++)
{
$row =mysql_fetch_array($ShowCourseResult);
if($i>=$p&&$i<$check)
{
if($i%2==0)
echo "<tr bgcolor='#dddddd'>";
else
echo "<tr>";
echo" <td width='80' > <a href='CourseDetail.php?CouNo=".$row['CouNo']." '>".$row['CouNo']."</a></td>";
echo" <td width='220'>".$row['CouName']."</td>";
echo" <td width='80'>".$row['Kind']."</td>";
echo" <td width='50' >".$row['Credit']."</td>";
echo" <td width='80' >".$row['Teacher']."</td>";
echo" <td width='100' >".$row['SchoolTime']."</td>";
echo"</tr>";
$j=$i+1;
}
} }
?>
</TABLE>
<br>
<TABLE width="400" border="0" align="center">
<tr>
<td align="center">
<a href="ShowCourse.php?p=0">第一页</a>
</td>
<td align="center">
<?php
if($p>9)
{
$last=(floor($p/10)*10)-10;
echo"<a href='ShowCourse.php?p=$last'>上一页</a>";
}
else
echo"上一页";
?>
</td>
<td align="center">
<?php
if($i>9 and $number>$check)
{
echo"<a href='ShowCourse.php?p=$j'>下一页</a>";
}
else
echo"下一页";
?>
</td>
<td align="center">
<?php
if($i>9)
{
$final=floor($number/10)*10;
echo"<a href='ShowCourse.php?p=$final'>最后一页</a>";
}
else
echo"最后一页";
?>
</td>
</tr>
</TABLE>
<form method="POST" action=SearchCourse1.php>
<table width="364" border="0" align="center">
<tr><td align=center>请输入查询信息</td></tr>
<tr>
<td>查询<select name="ColumnName" >
<option value="CouNo" >课程编号
<option value="CouName" >课程名称
<option value="Kind" >类型
<option value="Credit" >学分
<option value="Teacher" >教师
<option value="DepartName" >开课系部
<option value="SchoolTime" >上课时间
</select>为
<input type=text name="KeyWord" size=20>的课程
</td>
</tr>
</table>
<table width="364" border="0" align="center">
<input type="submit" value="确定" name="B1">
<input type="reset" value="重置" name="B2">
</table>
</form></body>
</html>
一到下一页的时候就传不了参数了~
<?phpsession_start();
/*if ($_SESSION["username"]=="")
{
header("Location:index.php");
exit();
}*/
include("db_conn.php");
include("db_func.php");
$ShowCourse_sql="select * from Course order by CouNo";
$ShowCourseResult=mysql_query($ShowCourse_sql);?>
<html>
<head>
<META http-equiv=Content-Type content="text/html; charset=utf8"/>
<title>课程信息显示</title>
</head>
<body><center>点击课程编码连接可以查看课程细节</center>
<TABLE width=“610” border="0" align="center" cellpadding="0" cellspacing="1">
<tr bgcolor="#0066cc">
<td width="80" align="center"><font color="#FFFFFF">课程编码</font></td>
<td width="220" align="center"><font color="#FFFFFF">课程名称</font></td>
<td width="80" align="center"><font color="#FFFFFF">课程类别</font></td>
<td width="50" align="center"><font color="#FFFFFF">学分</font></td>
<td width="80" align="center"><font color="#FFFFFF">任课教师</font></td>
<td width="80" align="center"><font color="#FFFFFF">上课时间</font></td>
</tr>
<?php
if(mysql_num_rows($ShowCourseResult)>0)
{
$number=mysql_num_rows($ShowCourseResult);
$check=$p+10;
for($i=0;$i<$number;$i++)
{
$row =mysql_fetch_array($ShowCourseResult);
if($i>=$p&&$i<$check)
{
if($i%2==0)
echo "<tr bgcolor='#dddddd'>";
else
echo "<tr>";
echo" <td width='80' > <a href='CourseDetail.php?CouNo=".$row['CouNo']." '>".$row['CouNo']."</a></td>";
echo" <td width='220'>".$row['CouName']."</td>";
echo" <td width='80'>".$row['Kind']."</td>";
echo" <td width='50' >".$row['Credit']."</td>";
echo" <td width='80' >".$row['Teacher']."</td>";
echo" <td width='100' >".$row['SchoolTime']."</td>";
echo"</tr>";
$j=$i+1;
}
} }
?>
</TABLE>
<br>
<TABLE width="400" border="0" align="center">
<tr>
<td align="center">
<a href="ShowCourse.php?p=0">第一页</a>
</td>
<td align="center">
<?php
if($p>9)
{
$last=(floor($p/10)*10)-10;
echo"<a href='ShowCourse.php?p=$last'>上一页</a>";
}
else
echo"上一页";
?>
</td>
<td align="center">
<?php
if($i>9 and $number>$check)
{
echo"<a href='ShowCourse.php?p=$j'>下一页</a>";
}
else
echo"下一页";
?>
</td>
<td align="center">
<?php
if($i>9)
{
$final=floor($number/10)*10;
echo"<a href='ShowCourse.php?p=$final'>最后一页</a>";
}
else
echo"最后一页";
?>
</td>
</tr>
</TABLE>
<form method="POST" action=SearchCourse1.php>
<table width="364" border="0" align="center">
<tr><td align=center>请输入查询信息</td></tr>
<tr>
<td>查询<select name="ColumnName" >
<option value="CouNo" >课程编号
<option value="CouName" >课程名称
<option value="Kind" >类型
<option value="Credit" >学分
<option value="Teacher" >教师
<option value="DepartName" >开课系部
<option value="SchoolTime" >上课时间
</select>为
<input type=text name="KeyWord" size=20>的课程
</td>
</tr>
</table>
<table width="364" border="0" align="center">
<input type="submit" value="确定" name="B1">
<input type="reset" value="重置" name="B2">
</table>
</form></body>
</html>
一到下一页的时候就传不了参数了~
$KeyWord=$_POST['KeyWord'];
$KeyWord=trim($KeyWord);我用了POST了啊~!
你post的这几个变量要跟在url参数的后面
$ColumnName=$_POST['ColumnName'];
$KeyWord=$_POST['KeyWord'];
$KeyWord=trim($KeyWord);include("db_conn.php");
include("db_func.php");switch($ColumnName)
{
case "CouNo":
$SearchCourse_SQL="SELECT * FROM Course where CouNo LIKE \"%".$KeyWord."%\" ";
break;
case "CouName":
$SearchCourse_SQL="SELECT * FROM Course where CouName LIKE \"%".$KeyWord."%\" ";
break;
case "Kind":
$SearchCourse_SQL="SELECT * FROM Course where Kind LIKE \"%".$KeyWord."%\" ";
break;
case "Credit":
$SearchCourse_SQL="SELECT * FROM Course where Credit LIKE \"%".$KeyWord."%\" ";
break;
case "Teacher":
$SearchCourse_SQL="SELECT * FROM Course where Teacher LIKE \"%".$KeyWord."%\" ";
break;
case "DepartName":
$SearchCourse_SQL="SELECT * FROM Course,Department where Course.DepartNo=Department.DepartNo and DepartName LIKE \"%".$KeyWord."%\" ";
break;
case "SchoolTime":
$SearchCourse_SQL="SELECT * FROM Course where SchoolTime LIKE \"%".$KeyWord."%\" ";
break;
default:
echo "Error";
}$SearchCourseResult=mysql_query($SearchCourse_SQL);
?><center>点击课程编码连接可以查看课程细节</center>
<TABLE width=“610” border="0" align="center" cellpadding="0" cellspacing="1">
<tr bgcolor="#0066cc">
<td width="80" align="center"><font color="#FFFFFF">课程编码</font></td>
<td width="220" align="center"><font color="#FFFFFF">课程名称</font></td>
<td width="80" align="center"><font color="#FFFFFF">课程类别</font></td>
<td width="50" align="center"><font color="#FFFFFF">学分</font></td>
<td width="80" align="center"><font color="#FFFFFF">任课教师</font></td>
<td width="80" align="center"><font color="#FFFFFF">上课时间</font></td>
</tr>
<?phpif(mysql_num_rows($SearchCourseResult)>0)
{
$number=mysql_num_rows($SearchCourseResult);
$check=$p+10;
for($i=0;$i<$number;$i++)
{
$row =mysql_fetch_array($SearchCourseResult);
if($i>=$p&&$i<$check)
{
if($i%2==0)
echo "<tr bgcolor='#dddddd'>";
else
echo "<tr>";
echo" <td width='80' > <a href='CourseDetail.php?CouNo=".$row['CouNo']." '>".$row['CouNo']."</a></td>";
echo" <td width='220'>".$row['CouName']."</td>";
echo" <td width='80'>".$row['Kind']."</td>";
echo" <td width='50' >".$row['Credit']."</td>";
echo" <td width='80' >".$row['Teacher']."</td>";
echo" <td width='100' >".$row['SchoolTime']."</td>";
echo"</tr>";
$j=$i+1;
}
} }
?>
</TABLE>
<br>
<TABLE width="400" border="0" align="center">
<tr>
<td align="center">
<a href="SearchCourse1.php?p=0&&ColumnName=<?php echo $ColumnName ?> &&KeyWord=<?php echo $KeyWord ?>">第一页</a>
</td>
<td align="center">
<?php
if($p>9)
{
$last=(floor($p/10)*10)-10;
echo" <a href='SearchCourse1.php?p=$last && ColumnName=$ColumnName && KeyWord=$KeyWord'>上一页</a> ";
}
else
echo"上一页";
?>
</td>
<td align="center">
<?php
if($i>9 and $number>$check)
{
echo"<a href='SearchCourse1.php?p=$j && ColumnName=$ColumnName && KeyWord=$KeyWord'>下一页</a>";
}
else
echo"下一页";
?>
</td>
<td align="center">
<?php
if($i>9)
{
$final=floor($number/10)*10;
echo"<a href='SearchCourse1.php?p=$final && ColumnName=$ColumnName && KeyWord=$KeyWord'>最后一页</a>";
}
else
echo"最后一页";
?>
</td>
</tr>
</TABLE><form method="POST" action=SearchCourse1.php>
<table width="364" border="0" align="center">
<tr><td align=center><div align="center">请输入查询信息</td></tr>
<tr>
<td>查询<select name="ColumnName" >
<option value="CouNo" >课程编号
<option value="CouName" >课程名称
<option value="Kind" >类型
<option value="Credit" >学分
<option value="Teacher" >教师
<option value="DepartName" >开课系部
<option value="SchoolTime" >上课时间
</select>为
<input type=text name="KeyWord" size=20>的课程
</td>
</tr>
</table>
<table width="364" border="0" align="center">
<input type="submit" value="确定" name="B1">
<input type="reset" value="重置" name="B2">
</table>
</form>
直接改成 $ColumnName=$_REQUEST['ColumnName'];echo" <a href='SearchCourse1.php?p=$last && ColumnName=$ColumnName && KeyWord=$KeyWord'>上一页</a> ";& 一个就可以