复选框的删除如何操作,谁知道。。。。。 本帖最后由 buhao_md 于 2010-08-12 15:44:33 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 echo '<form action="delect_sj.php" method=post>';while ($row = mysql_fetch_array($result)) { echo '<tr>'; echo '<td><input type=checkbox name="hid[]" value="'.$row['h_id'].'"></td>';//checkbox echo '<td>'.$row['hotel_id'].'</td>'; echo '<td>'.$row['start_date'].'</td>'; echo '<td>'.$row['end_date'].'</td>'; echo '<td>'.$row['content'].'</td>'; echo '<td>'.$row['source'].'</td>'; echo '<td>'.$row['s_type'].'</td>'; echo '<td>'.' <a href="delect_sj.php?hid='.$row['h_id'].'" onclick="return delconfirm()">删除</a> '.' <a href="upedit.php?hid='.$row['h_id'].'" >编辑</a> '.'</td>'; echo '</tr>';}echo '<input type=submit value="删除所选"></form>';delect_sj.php:$hid = !empty($_GET['hid'])?intval($_GET['hid']):0;if(!$hid){ $hid = isset($_POST['hid'])?$_POST['hid']:array(0=>0); $hid = "'".join("','",$hid)."'";}else{ $hid = "'$hid'";}$_SESSION['adminuser']=$_SESSION['user_login'];//接收用户名$sql1 = mysql_query( "SELECT content,hotel_id FROM `hotel_activities_2` WHERE h_id in($hid)");$content = mysql_fetch_array($sql1); //print_r($content);if($content){ $logdata['hotel_id']=$content['hotel_id']; $logdata['content']=$content['content']; $logdata['operating']="删除"; writedblog($logdata);/*********开始删除*******/$query="delete from hotel_activities_2 where h_id in($hid)";if (mysql_query($query)){ echo "<script>alert('数据删除成功');window.location='chaxun.php';</script>";}else{echo "<script>alert('数据删除失败');window.location='chaxun.php';</script>"; }} 删除一个的时候可以,但删除多项的时候报错$hid = !empty($_GET['hid'])?intval($_GET['hid']):0;if(!$hid){ $hid = isset($_POST['hid'])?$_POST['hid']:array(0=>0); $hid = "'".join("','",$hid)."'";}else{ $hid = "'$hid'";}$_SESSION['adminuser']=$_SESSION['user_login'];//接收用户名$sql1 = mysql_query( "SELECT content,hotel_id FROM `hotel_activities_2` WHERE h_id=$hid");$content = mysql_fetch_array($sql1); //......这句话报错.......//print_r($content);if($content){ $logdata['hotel_id']=$content['hotel_id']; $logdata['content']=$content['content']; $logdata['operating']="删除"; writedblog($logdata);/*********开始删除*******/$query="delete from hotel_activities_2 where h_id in($hid)";if (mysql_query($query)){ echo "<script>alert('数据删除成功');window.location='chaxun.php';</script>";}else{echo "<script>alert('数据删除失败');window.location='chaxun.php';</script>"; }}/********定义函数*************/function writedblog($data){ $time=date('Y-m-d H:i:s',time()); return mysql_query("insert into hotel_rizhi(hotel_id,name,content,operating,time) values ('$data[hotel_id]','$_SESSION[adminuser]','$data[content]','$data[operating]','$time')");} WHERE h_id in($hid)");下面的两个语句都改了的哈 你仔细看我发的代码!!!出错的地方的前面那条语句应该是:WHERE h_id in($hid) 在线咨询系统 369网址导航源码(php版) 双表查询问题 问个很有水平的问题。。 apache php与JSP整合 google map v3 图标堆叠顺序问题 oscommerce二次开发问题 如果匹配文章内容链接 使用thinkphp和extjs4完成一个后台的功能,求回复,很急! 关于PHP搜索抓取内容的问题? 有谁做过drupal 这样的整站程序在哪里可以下载
while ($row = mysql_fetch_array($result)) {
echo '<tr>'; echo '<td><input type=checkbox name="hid[]" value="'.$row['h_id'].'"></td>';//checkbox
echo '<td>'.$row['hotel_id'].'</td>';
echo '<td>'.$row['start_date'].'</td>';
echo '<td>'.$row['end_date'].'</td>';
echo '<td>'.$row['content'].'</td>';
echo '<td>'.$row['source'].'</td>';
echo '<td>'.$row['s_type'].'</td>';
echo '<td>'.' <a href="delect_sj.php?hid='.$row['h_id'].'" onclick="return delconfirm()">删除</a> '.' <a href="upedit.php?hid='.$row['h_id'].'" >编辑</a> '.'</td>';
echo '</tr>';
}
echo '<input type=submit value="删除所选"></form>';delect_sj.php:
$hid = !empty($_GET['hid'])?intval($_GET['hid']):0;
if(!$hid){
$hid = isset($_POST['hid'])?$_POST['hid']:array(0=>0);
$hid = "'".join("','",$hid)."'";
}else{
$hid = "'$hid'";
}
$_SESSION['adminuser']=$_SESSION['user_login'];//接收用户名
$sql1 = mysql_query(
"SELECT content,hotel_id
FROM `hotel_activities_2`
WHERE h_id in($hid)");
$content = mysql_fetch_array($sql1);
//print_r($content);
if($content){
$logdata['hotel_id']=$content['hotel_id'];
$logdata['content']=$content['content'];
$logdata['operating']="删除";
writedblog($logdata);
/*********开始删除*******/
$query="delete from hotel_activities_2 where h_id in($hid)";
if (mysql_query($query)){
echo "<script>alert('数据删除成功');window.location='chaxun.php';</script>";
}else{
echo "<script>alert('数据删除失败');window.location='chaxun.php';</script>";
}
}
$hid = !empty($_GET['hid'])?intval($_GET['hid']):0;
if(!$hid){
$hid = isset($_POST['hid'])?$_POST['hid']:array(0=>0);
$hid = "'".join("','",$hid)."'";
}else{
$hid = "'$hid'";
}$_SESSION['adminuser']=$_SESSION['user_login'];//接收用户名
$sql1 = mysql_query(
"SELECT content,hotel_id
FROM `hotel_activities_2`
WHERE h_id=$hid");
$content = mysql_fetch_array($sql1); //......这句话报错.......
//print_r($content);
if($content){
$logdata['hotel_id']=$content['hotel_id'];
$logdata['content']=$content['content'];
$logdata['operating']="删除";
writedblog($logdata);
/*********开始删除*******/
$query="delete from hotel_activities_2 where h_id in($hid)";
if (mysql_query($query)){
echo "<script>alert('数据删除成功');window.location='chaxun.php';</script>";
}else{
echo "<script>alert('数据删除失败');window.location='chaxun.php';</script>";
}
}
/********定义函数*************/
function writedblog($data){
$time=date('Y-m-d H:i:s',time());
return mysql_query("insert into hotel_rizhi(hotel_id,name,content,operating,time) values
('$data[hotel_id]','$_SESSION[adminuser]','$data[content]','$data[operating]','$time')");
}
下面的两个语句都改了的哈
出错的地方的前面那条语句应该是:WHERE h_id in($hid)