php 值传递后查找数据库找不到-php教程-PHP中文网

php 值传递后查找数据库找不到

WBOY

发布： 2016-06-23 14:04:28

原创

829 人浏览过

做一个简单的学生管理系统
专业：

回复讨论(解决方案)

至少要这样
$query = "select * from s where pro='$pro'";

贴出你的代码看看啦

至少要这样
$query = "select * from s where pro='$pro'";
结果是一样的无法匹配到单独显示$pro都有值

贴出你的代码看看啦
if (!empty($_POST["sname"]))
{
$sname = $_POST["sname"];
}
else
{$sname="空";}
if (!empty($_POST["sid"]))
{
$sid=$_POST["sid"];
}
else
{$sid="空";}
$pro = $_POST["pro"];
$grade=$_POST["grade"];
$class=$_POST["class"];
?>
if ($grade =="全部" && $class =="全部" && $pro=="全部" && $sname=="空" && $sid=="空" )
{
   $query = "select * from s  order by sid desc";
}
else if ($grade =="全部" && $class =="全部" && $pro=="全部" && $sname!="空" && $sid=="空" )
{
   $query = "select * from s  where sname=$sname order by sid desc";
}
else if ($grade =="全部" && $class =="全部" && $pro=="全部" && $sname=="空" && $sid!="空" )
{
   $query = "select * from s where sid=$sid order by sid desc";
}
else if ($grade =="全部" && $class =="全部" && $pro=="全部" && $sname!="空" && $sid!="空" )
{
   $query = "select * from s where sid=$sid and sname=$sname order by sid desc";
}
else if ($grade =="全部" && $class =="全部" && $pro!="全部" && $sname=="空" && $sid=="空" )
{
$query = "select * from s where pro=$pro order by sid desc";
}

$result = $db->query($query);
if  ($result >0) {
while ($row = $result->fetch_assoc()) {

  ?>

     ">查看详细信息 ">编辑 ">删除

     }
}
else {
echo "无符合条件记录";
}
$result->free_result;
$db->close();
  ?>

专业：

至少要这样
$query = "select * from s where pro='$pro'";
可以了多谢