Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- id int auto increment
- boleto mediumblob
- nomeBoleto varchar,
- tipoBoleto varchar,
- categoria varchar,
- primary key (post_id),
- FULLTEXT (categoria)
- <?php
- include "conexão.php";
- //aqui puxa minha categoria do campo
- $categoria = $_POST['comboB'];
- //e meu select
- $stmt = $db->prepare("select id,nomeBoleto,categoria from boletos WHERE MATCH (categoria) AGAINST ('$categoria' in boolean mode)");
- $stmt->execute();
- while($row = $stmt->fetch()){
- if($row > 0){
- <tr>
- <td><?php echo $row['id']?></td>
- <td><?php echo $row['nomeBoleto']?></td>
- <td><?php echo $row['categoria']?></td>
- </tr>
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement