Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- require_once 'functions.php';
- $PDO = db_connect();
- $opcao_filtro = filter_input(INPUT_POST, 'opcao_filtro', FILTER_SANITIZE_STRING);
- $sql = 'SELECT * FROM tablet AS t WHERE';
- //idlivro, titulo, tipo, e cor.
- switch($opcao_filtro)
- {
- case 'titulo': {
- $sql .= ' t.titulo=? like "a%"';
- break;
- }
- case 'autor': {
- $sql .= ' t.cor=? like "a%"';
- break;
- }
- foreach($rows as $row)
- {
- echo $row['titulo'];
- echo $row['cor'];
- echo $row['categoria'];
- }case 'tema': {
- $sql .= ' t.categoria=? like "a%"';
- break;
- }
- }
- $stmt = $PDO->prepare($sql);
- $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
- $result = array_unique($rows);
- foreach($rows as $row)
- {
- echo $row['titulo'];
- echo $row['cor'];
- echo $row['categoria'];
- }
- <button type="submit" class="btn btn-link btn-xs" value="a" name="a">A</button>
Add Comment
Please, Sign In to add comment