Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. <?php
  2. if(!isset($_POST['search'])) exit('No se recibió el valor a buscar');
  3.  
  4. require_once 'conexion.php';
  5.  
  6. function search()
  7. {
  8. $mysqli = getConnexion();
  9. $search = $mysqli->real_escape_string($_POST['search']);
  10. $query = "SELECT nombre, id, Imagen FROM tabla_imagen WHERE nombre LIKE '%$search%' ";
  11. $res = $mysqli->query($query);
  12. while ($row = $res->fetch_array(MYSQLI_ASSOC)) {
  13. echo "<p><a href='$row[nombre]' target='_blank'>$row[nombre]</a>
  14. <a href='$row[Imagen]' target='_blank'>$row[Imagen]</a>
  15.  
  16. <a href='$row[Imagen]' target='_blank'>$row[nombre]</a>
  17.  
  18.  
  19.  
  20. </p>";
  21.  
  22. <tr>
  23. <td><img height="80px" src="data:image/jpg;base64,<?php echo base64_encode($row['Imagen']); ?>"/></td>
  24. </tr>
  25. }
  26. }
  27.  
  28. search();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement