Guest User

Untitled

a guest
Aug 21st, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. require_once 'functions.php';
  2.  
  3. $PDO = db_connect();
  4.  
  5. $opcao_filtro = filter_input(INPUT_POST, 'opcao_filtro', FILTER_SANITIZE_STRING);
  6.  
  7. $sql = 'SELECT * FROM tablet AS t WHERE';
  8.  
  9. //idlivro, titulo, tipo, e cor.
  10. switch($opcao_filtro)
  11. {
  12. case 'titulo': {
  13. $sql .= ' t.titulo=? like "a%"';
  14. break;
  15. }
  16. case 'autor': {
  17. $sql .= ' t.cor=? like "a%"';
  18. break;
  19. }
  20.  
  21. foreach($rows as $row)
  22. {
  23. echo $row['titulo'];
  24. echo $row['cor'];
  25. echo $row['categoria'];
  26. }case 'tema': {
  27. $sql .= ' t.categoria=? like "a%"';
  28. break;
  29. }
  30. }
  31.  
  32. $stmt = $PDO->prepare($sql);
  33. $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
  34. $result = array_unique($rows);
  35.  
  36. foreach($rows as $row)
  37. {
  38. echo $row['titulo'];
  39. echo $row['cor'];
  40. echo $row['categoria'];
  41. }
  42.  
  43. <button type="submit" class="btn btn-link btn-xs" value="a" name="a">A</button>
Add Comment
Please, Sign In to add comment