Filtry produktów w php nie dziłają prawidłowo

Question

Hej robie filtry produktów w czystym php i mam problem ponieważ kod poniżej raz działa raz nie

<form action="" method="POST">
                <br><h3>Filtruj</h3>
                <br>Płeć:<br>
                <input type="checkbox" name="gender" value="On"> &nbsp; Mężczyna<br>
                <input type="checkbox" name="gender" value="Ona"> &nbsp; Kobieta<br>
                <input type="checkbox" name="gender" value="Unisex"> &nbsp; Dla obu<br>

                <br>Cena:<br>
                <input id="num" placeholder="Od" type="number" name="n1">
                <input id="num" placeholder="Do" type="number" name="n2"><br>

                <br>Kolor:<br>
                <?php
                    echo 
                    '<select name="color">
                    <option>Wybierz</option>';
 
                    $result = $connect->query("SELECT color FROM products GROUP BY color");
                    while ($row = $result -> fetch_assoc()) 
                    {
                        echo '<option value='.$row['color'].'>'.$row['color'].'</option>';
                    }
                    echo '</select>';
                ?><br>

                <br>wyprzedarz:<br><br>

                <input type="submit" name="sub1" value="Filtruj">

                <?php
                    echo '<a href="selected_category.php?id='.$category_id.'">Reset</a>'
                ?>

                
            </form>

<?php
$category_id = $_GET['id'];
$sql = "SELECT * FROM products WHERE category_id = $category_id";
           
                if(isset($_POST['sub1']))
                {
                    if(isset($_POST['gender']) && !empty($_POST['gender']))
                    {
                        $gender = $_POST['gender'];
                        $sql = $sql . " AND gender = '$gender'";
                    }
                    if(isset($_POST['n1']) && !empty($_POST['n1']))
                    {
                        $n1 = $_POST['n1'];
                        $sql = $sql . " AND price >= '$n1'";
                    }
                    if(isset($_POST['n2']) && !empty($_POST['n2']))
                    {
                        $n2 = $_POST['n2'];
                        $sql = $sql . " AND price <= '$n2'";
                    }
                    if(isset($_POST['color']) && !empty($_POST['color']))
                    {
                        $color = $_POST['color'];
                        $sql = $sql . " AND color = '$color'";
                    }
                }
                else
                {
                    $sql = "SELECT * FROM products WHERE category_id = $category_id";
                }

                $result = $connect->query($sql);

i tak dalej akcja jest taka ze albo mam dobre wyniki albo nie mam nic

 

Comments

Spróbuj tak (zapisałem kod razem podziel sobie jeśli jest taka potrzeba)  

<?php
  //var_dump($_POST);

  $category_id = $_GET['id'] ?? $_POST['id'] ?? 0;
  $sql = "SELECT * FROM products WHERE category_id=$category_id";
            
  if ($_SERVER["REQUEST_METHOD"]=="POST" && isset($_POST['submit1']))
  {
      if (!empty($_POST['gender']))
      {
          $gender = $_POST['gender'];
          $sql .= " AND gender='$gender'";
      }
      
      if (!empty($_POST['n1']) && !empty($_POST['n2']))
      {
          $n1 = $_POST['n1'];
          $n2 = $_POST['n2'];
          $sql .= " AND price BETWEEN $n1 AND $n2";
      } else {
          if (!empty($_POST['n1']))
          {
              $n1 = $_POST['n1'];
              $sql .= " AND price>=$n1";
          }
          if (!empty($_POST['n2']))
          {
              $n2 = $_POST['n2'];
              $sql .= " AND price<=$n2";
          }
      }
      
      if(!empty($_POST['color']))
      {
         $color = $_POST['color'];
         $sql .= " AND color='$color'";
      }
  }

  //echo $sql; 
  $result = $connect->query($sql);

?>
    <style>
      form p {
        margin: 1em 0 0.25em 0;
      }
      form p.clearance-sale {
        margin: 1.5em 0;
      }
    </style>

    <form action="" method="POST">
      <h3>Filtruj</h3>
      <input type="hidden" name="id" value="<?php echo $category_id; ?>">

      <p>Płeć:</p>
      <input type="radio" id="on" name="gender" value="On">
      <label for="on">Mężczyna</label><br>
      <input type="radio" id="ona" name="gender" value="Ona">
      <label for="ona">Kobieta</label><br>
      <input type="radio" id="unisex" name="gender" value="Unisex">
      <label for="unisex">Dla obu</label>
 
      <p>Cena:</p>
      <input id="price_from" placeholder="Od" type="number" min="0" name="n1">
      <input id="price_to"   placeholder="Do" type="number" min="0" name="n2">
 
      <p>Kolor:</p>
      <select name="color">
        <option value="">Wybierz</option>
<?php        
        $result = $connect->query("SELECT color FROM products GROUP BY color");
        while ($row = $result->fetch_assoc()) 
            echo '<option value="'.$row['color'].'">'.$row['color'].'</option>';
?>
      </select>
 
      <p class="clearance-sale">wyprzedaż:</p> 
      <input type="submit" name="submit1" value="Filtruj">
      <a href="selected_category.php?id=<?php echo $category_id; ?>">Reset</a>                 
    </form>