php - 仅显示下拉表中选定的选项行

Question

下拉框的值是从表头中的数据库获取的。当用户在下拉菜单中选择选项之一[示例:未交付]时，我需要仅显示具有值“未交付”的行....

从数据库获取值:[工作正常]

$sql = "SELECT DISTINCT in_transit FROM do_order";
$result = mysqli_query ($mysqli, $sql);

echo '<select id="my_select" onchange="send_option();">'; 
echo '<option selected>Status</option>';

while ( $row = mysqli_fetch_array($result) )
{
  echo "<option value='" . $row['in_transit'] . "'>" . $row['in_transit'] . "</option>";
}

echo '</select>';

下面的代码显示选定的选项行[当用户选择“未送达”时仅显示“未送达”]:不起作用

$in_transit = mysqli_real_escape_string($conn, $_POST['in_transit']);

        $sql1 = "SELECT in_transit FROM do_order WHERE in_transit LIKE '%$in_transit%'";
        $result = mysqli_query($conn, $sql1);

            if (mysqli_num_rows($result) > 0) 
                {
                    while($row = mysqli_fetch_assoc($result)) 
                        {
                            echo "$row['in_transit']";                             
                        }
                }

Answer 1

用途:

if(isset($_POST['in_transit'])){

echo $_POST['in_transit'];

 $sql1 = "SELECT in_transit FROM do_order WHERE in_transit LIKE '%$in_transit%'";
        $result = mysqli_query($conn, $sql1);

            if (mysqli_num_rows($result) > 0) 
                {
                    while($row = mysqli_fetch_assoc($result)) 
                        {
                            echo "$row['in_transit']";                             
                        }
                }
}

ECHO $_POST['in_transit'] 以确保您在运行查询之前获取邮政值。如果您获得了发布值，则可以对其进行评论。