Guest User

Untitled

a guest
Dec 15th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.47 KB | None | 0 0
  1. 0-500
  2. 501-1000
  3. 1001-2500
  4. 2501-5000
  5.  
  6. <div class="control-group">
  7. <label class="control control--checkbox"> 0-500
  8. <input type="checkbox" value="0 AND 500" class="item_filter price"/>
  9. <div class="control__indicator"></div>
  10. </label>
  11. </div>
  12. <div class="control-group">
  13. <label class="control control--checkbox"> 501-1000
  14. <input type="checkbox" value="501 AND 1000" class="item_filter price"/>
  15. <div class="control__indicator"></div>
  16. </label>
  17. </div>
  18. <div class="control-group">
  19. <label class="control control--checkbox"> 1001-2500
  20. <input type="checkbox" value="1001 AND 2500" class="item_filter price"/>
  21. <div class="control__indicator"></div>
  22. </label>
  23. </div>
  24. <div class="control-group">
  25. <label class="control control--checkbox"> 2501-5000
  26. <input type="checkbox" value="2501 AND 5000" class="item_filter price"/>
  27. <div class="control__indicator"></div>
  28. </label>
  29. </div>
  30.  
  31. <?php
  32. $price="";
  33. $price = isset($_REQUEST['price'])?$_REQUEST['price']:"";
  34.  
  35. $sql = "SELECT * FROM wm_ledtv WHERE pro_live='N'";
  36. if(!empty($price)){
  37. $price =implode("'or pro_price between'",$price);
  38. $sql .= " and pro_price between $price";
  39. }
  40. $result = $conn->query($sql);
  41. if($result->num_rows > 0){
  42. while($row = $result->fetch_assoc()){
  43. ?>
  44. fliter product show.............
  45. <?php
  46. }
  47. }
Add Comment
Please, Sign In to add comment