Advertisement
Guest User

Untitled

a guest
Nov 27th, 2016
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. <form action="handle.php" method="post">
  2. <input type="checkbox" name="age[]" value="18|19|20|">From 18 to 20<br>
  3. <input type="checkbox" name="age[]" value="21|22|23|24|25|26|27|28|29|30|">From 21 to 30<br>
  4. <input type="checkbox" name="age[]" value="31|32|33|34|35|36|37|38|39|40">From 31 to 40<br>
  5. <input type="checkbox" name="age[]" value="41|42|43|44|45|46|47|48|49|50">From 41 to 50<br>
  6. <input type="checkbox" name="age[]" value="51|52|53|54|55|56|57|58|59|60|61|62|63|64|65|66|67|68|69|70|">Above 50<br>
  7. <input type="submit" />
  8. </form>
  9.  
  10. <?php
  11. $dbhost = 'localhost';
  12. $dbuser = 'root';
  13. $dbpass = 'root';
  14. $dbname = 'test';
  15. $con=mysqli_connect($dbhost,$dbuser,$dbpass,$dbname);
  16. if ($con->connect_error) {
  17. die("Connection failed: " . $conn->connect_error);
  18. }
  19.  
  20. $age = $_POST['age'];
  21. $result = $con->query("SELECT name FROM users WHERE age REGEXP '$age[]' ");
  22. $row_cnt = $result->num_rows;
  23. echo "Your search returned" . $row_cnt . "results";
  24. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement