Advertisement
Guest User

Untitled

a guest
Jun 15th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. id int auto increment
  2. boleto mediumblob
  3. nomeBoleto varchar,
  4. tipoBoleto varchar,
  5. categoria varchar,
  6. primary key (post_id),
  7. FULLTEXT (categoria)
  8.  
  9. <?php
  10. include "conexão.php";
  11.  
  12. //aqui puxa minha categoria do campo
  13. $categoria = $_POST['comboB'];
  14.  
  15. //e meu select
  16. $stmt = $db->prepare("select id,nomeBoleto,categoria from boletos WHERE MATCH (categoria) AGAINST ('$categoria' in boolean mode)");
  17.  
  18. $stmt->execute();
  19. while($row = $stmt->fetch()){
  20. if($row > 0){
  21.  
  22. <tr>
  23. <td><?php echo $row['id']?></td>
  24. <td><?php echo $row['nomeBoleto']?></td>
  25. <td><?php echo $row['categoria']?></td>
  26. </tr>
  27.  
  28. }
  29. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement