*** .html<td width="16%"><input type="radio" name="radiobutton" value="select * from bse_stm_p " />*** .php $sql=$_POST["radiobutton"]."limit $offset,$Page_size ";我把html页面的值传到PHP页面之后可以获取到值,但是点击下一页就显示错误了,
我大概知道是传值的问题,有没有一种方法把传递过来的值保存,分页的时候不会出错!
我大概知道是传值的问题,有没有一种方法把传递过来的值保存,分页的时候不会出错!
原因有
1 你没有进行post提交
2 进行了post提交 但是你radio没选上把你html的点击下一页贴出来看看 还有你的form写了没有
另外你的做法很奇怪
另外,你这样直接传SQL是很不安全的。
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="16%"><input type="radio" name="radiobutton" value="select * from bse_stm_p where NAME" />清朝</td>
<td width="16%"><input type="radio" name="radiobutton" value="普票" />普票</td>
<td width="16%"><input type="radio" name="radiobutton" value="抗日前" />抗前</td>
<td width="16%"><input type="radio" name="radiobutton" value="普改" />普改</td>
<td width="16%"><input type="radio" name="radiobutton" value="普票" />普票</td>
<td width="20%"><input type="radio" name="radiobutton" value="香港" />香港</td>
</tr>
<tr>
<td><input type="radio" name="radiobutton" value="商埠" />商埠</td>
<td><input type="radio" name="radiobutton" value="纪念" />纪念</td>
<td><input type="radio" name="radiobutton" value="东北" />东北</td>
<td><input type="radio" name="radiobutton" value="纪念" />纪念</td>
<td><input type="radio" name="radiobutton" value="纪念" />纪念</td>
<td><input type="radio" name="radiobutton" value="澳门" />澳门</td>
</tr>
<tr>
<td><input type="radio" name="radiobutton" value="客邮" />客邮</td>
<td><input type="radio" name="radiobutton" value="限省" />限省</td>
<td><input type="radio" name="radiobutton" value="西北" />西北</td>
<td><input type="radio" name="radiobutton" value="特种" />特种</td>
<td><input type="radio" name="radiobutton" value="专题" />专题</td>
<td> </td>
</tr>
<tr>
<td height="33"><input type="radio" name="radiobutton" value="其他" />其他</td>
<td><input type="radio" name="radiobutton" value="特种" />特种</td>
<td><input type="radio" name="radiobutton" value="华北" />华北</td>
<td><input type="radio" name="radiobutton" value="文编" />文编</td>
<td><input type="radio" name="radiobutton" value="其他" />其他</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input type="radio" name="radiobutton" value="日占" />日占</td>
<td><input type="radio" name="radiobutton" value="华东" />华东</td>
<td><input type="radio" name="radiobutton" value="票" />J 票</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input type="radio" name="radiobutton" value="啊是的发生地方" />其他</td>
<td><input type="radio" name="radiobutton" value="啊是的发生地方" />华南</td>
<td><input type="radio" name="radiobutton" value="啊是的发生地方" />T 票</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="radio" name="radiobutton" value="啊是的发生地方" />西南</td>
<td><input type="radio" name="radiobutton" value="啊是的发生地方" />编年</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td><input type="radio" name="radiobutton" value="啊是的发生地方" />其他</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td colspan="2"><input type="submit" name="Submit2" value="提交" /></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</form> <table width="679" border="0">
<?php
/*
* Created on 2010-4-17
*
* Order by Kove Wong
*/
$link=mysql_connect("localhost","root","root");
mysql_select_db('bse');
mysql_query('set names gb2312'); $Page_size=25; $result=mysql_query('select * from bse_stm_p');
$count = mysql_num_rows($result);
$page_count = ceil($count/$Page_size);
$init=1;
$page_len=7;
$max_p=$page_count;
$pages=$page_count; //判断当前页码
if(empty($_GET['page'])||$_GET['page']<0){
$page=1;
}else {
$page=$_GET['page'];
} $offset=$Page_size*($page-1);
$sql=$_POST["radiobutton"]."limit $offset,$Page_size ";
$result=mysql_query($sql,$link);
while ($row=mysql_fetch_array($result)) {
?>
<tr>
<td width="10%" align="center"><?php echo $row['TYPE'];?></td>
<td width="10%" align="center"><?php echo $row['NAME'];?></td>
<td width="10%" align="center"><?php echo $row['CDE_R'];?></td>
<td width="10%" align="center"><?php echo $row['PAR'];?></td>
<td width="20%" align="center"><?php echo $row['DESC'];?></td>
<td width="10%" align="center"><?php echo $row['DTD_F'];?></td>
<td width="13%" align="center"><?php echo $row['SET'];?></td>
</tr>
<?php
}
$page_len = ($page_len%2)?$page_len:$pagelen+1;//页码个数
$pageoffset = ($page_len-1)/2;//页码个数左右偏移量 $key='<div class="page">';
$key.="<span>$page/$pages</span> "." "." "." "; //第几页,共几页
if($page!=1){
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page=1\">第一页</a> "." "." "." "; //第一页
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page=".($page-1)."\">上一页</a>"." "." "." "; //上一页
}else {
$key.="第一页 "." "." "." ";//第一页
$key.="上一页"." "." "." "; //上一页
} if($pages>$page_len){
//如果当前页小于等于左偏移
if($page<=$pageoffset){
$init=1;
$max_p = $page_len;
}else{//如果当前页大于左偏移
//如果当前页码右偏移超出最大分页数
if($page+$pageoffset>=$pages+1){
$init = $pages-$page_len+1;
}else{
//左右偏移都存在时的计算
$init = $page-$pageoffset;
$max_p = $page+$pageoffset;
}
}
}
for($i=$init;$i<=$max_p;$i++){
if($i==$page){
$key.=' <span>'.$i.'</span>';
} else {
$key.=" <a href=\"".$_SERVER['PHP_SELF']."?page=".$i."\">".$i."</a>"." ";
}
} if($page!=$pages){
$key.=" <a href=\"".$_SERVER['PHP_SELF']."?page=".($page+1)."\">下一页</a> "." "." "." ";//下一页
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page={$pages}\">最后一页</a>"." "." "." "; //最后一页
}else {
$key.="下一页 "." "." "." ";//下一页
$key.="最后一页"." "." "." "; //最后一页
}
$key.='</div>';
?>
</table>
改为
<form action="show_list.php" method="get">
radio只会传递被选择的那个值 什么都没选 则为空
提醒一下 你看看
不选择的时候
出现
Notice: Undefined index: radiobutton in D:\phpnow1.5.5.1 for xp\htdocs\PHP\Tra_class\show_list.php on line 84
好像是没有值的意思吧
用GET之后可以传递过来值,也可以获取到,但还是点击下一页的时候就出现跟上面一样的提示
Notice: Undefined index: radiobutton in D:\phpnow1.5.5.1 for xp\htdocs\PHP\Tra_class\show_list.php on line 84
好像只有选清朝的时候,才是select * from bse_stm_p where NAME 值
<td width="16%"><input type="radio" name="radiobutton" value="普票" />普票</td>
选清朝的时候 获取到的是 select * from bse_stm_p where NAME
选普票的时候 获取到的是 普票
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page=".($page-1)."\">上一页</a>"." "." "." "; //上一页
$key.=" <a href=\"".$_SERVER['PHP_SELF']."?page=".($page+1)."\">下一页</a> "." "." "." ";//下一页
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page={$pages}\">最后一页</a>"." "." "." "; //最后一页
这些地方都只传递了页号,没有传递与查询有关的信息