按类别过滤以在php中打印_php教程

上一篇: 在where子句LINQ PHP中发送变量下一篇:php – 列出依赖于特定GitHub存储...

按类别过滤以在php中打印

发布时间：2022-04-30 发布网站：脚本宝典

脚本宝典收集整理的这篇文章主要介绍了按类别过滤以在php中打印，脚本宝典觉得挺不错的，现在分享给大家，也给大家做个参考。

我正在制作一份报告,我需要按类别过滤细节.我的ITr表中有两个类别,即Resident和4Ps.

到目前为止,这是我的代码.我可以在这里打印itr表的所有细节.

<table>
  <tr>
    <th style = "padding-right:80px;padding-left:150px;">
    <center>Name</center></th>
    <th style = "padding-right:10px;padding-left:15px;"><center>Age</center>
    </th>
    <th style = "padding-right:10px;padding-left:20px;">
    <center>Gender</center></th>
    <th style = "padding-right:30px;padding-left:40px;">
    <center>Purok</center></th>
 </tr>
 <?PHP
   $query = $conn->query("SELECT * From itr LIMIT 30") or 
   die(MysqLi_error());
   for($a = 1; $a <= 30; $a++){
     $fetch = $query->fetch_array()
 ?>
<tr>
  <td><?PHP echo $a.". ".$fetch['Firstname']." ".$fetch['firstname']?></td>
  <td><center><?PHP echo $fetch['age']?></center></td>
  <td><center><?PHP echo $fetch['gender']?></center></td>
  <td><center><?PHP echo $fetch['address']?></center></td>
</tr>
<?PHP
}
$conn->close();
?>

我想要的是只使用像“按类别过滤”这样的按钮打印4P类别的人,我可以选择按居民或4P过滤,这样我只能使用一个 PHP 文件.我不知道怎么做.请帮忙：)

这是类别的htML

<label for = "category">Please select category:</label>
    <select style = "width:22%;" class = "form-control" name = "category" required = "required">
        <option value = "">--select category--</option>
        <option value = "RESIDENT">RESIDENT</option>
        <option value = "4Ps">4Ps</option>
    </select>
<br />

这是我的itr表：

这是我想要的输出：

解决方法

1.您需要在表单中放置category-select-Box

2.当用户根据即将到来的类别提交表单时,需要更改查询.

如下所示： –

<form method="POST">

    <label for = "category">Please select category:</label>
    <select style = "width:22%;" class = "form-control" name = "category" required = "required">
        <option value = "">--Select category--</option>
        <option value = "RESIDENT">RESIDENT</option>
        <option value = "4PS">4Ps</option> <!-- changed option value to capitals-->
    </select>
    <input tyPE="submit" name="submit" value="submit">
</form>

<table>
  <tr>
    <th style = "padding-right:80px;padding-left:150px;">
    <center>Name</center></th>
    <th style = "padding-right:10px;padding-left:15px;"><center>Age</center>
    </th>
    <th style = "padding-right:10px;padding-left:20px;">
    <center>Gender</center></th>
    <th style = "padding-right:30px;padding-left:40px;">
    <center>Purok</center></th>
 </tr>
 <?PHP
   if(isset($_POST['category']) && $_POST['category'] !==''){
    $category = $_POST['category'];
    $query = $conn->query("SELECT * From itr where category = '$category' LIMIT 30") or die(MysqLi_error());
   }else{
    $query = $conn->query("SELECT * FROM itr LIMIT 30") or die(MysqLi_error());
   }
   for($a = 1; $a <= 30; $a++){
     $fetch = $query->fetch_array()
 ?>
<tr>
  <td><?PHP echo $a.". ".$fetch['firstname']." ".$fetch['firstname']?></td>
  <td><center><?PHP echo $fetch['age']?></center></td>
  <td><center><?PHP echo $fetch['gender']?></center></td>
  <td><center><?PHP echo $fetch['address']?></center></td>
</tr>
<?PHP
}
$conn->close();
?>