Guest User

Untitled

a guest
Feb 24th, 2018
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.16 KB | None | 0 0
  1. <div class="row">
  2. <?php
  3. if(isset($_GET['cat']) && !empty($_GET['cat']))
  4. {
  5.  
  6. $host = "localhost";
  7. $db_name = "avisos";
  8. $username = "root";
  9. $password = "";
  10. $conn = new mysqli ($host, $username, $password, $db_name);
  11.  
  12. if ($conn->connect_error){
  13. die("connection failed: ".$conn->connect_error);
  14. }
  15.  
  16. $video_id = '';
  17. $id = $_GET['cat'];
  18. $sql = "SELECT email, nombre, telefono, descripcion, img , categoria , ai FROM tbl_public WHERE categoria=$id";
  19. $result = $conn->query ($sql);
  20. if($result->num_rows > 0)
  21. {
  22. while ($row = $result->fetch_assoc())
  23. {
  24. $video_id = $row["categoria"];
  25. ?>
  26. <div class="col-md-4 portfolio-item">
  27.  
  28. <p><img src="user_images/<?php echo $row['img']; ?>" height="175" width="210" / ></p>
  29. <h3>
  30. <a href="ver_publicacion.php?ai=<?php echo $row['ai']; ?>" ><?php echo $row['nombre']; ?></a>
  31. </h3>
  32. <!-- <p><?php echo $row['descripcion']; ?></p> -->
  33. </div>
  34. <?php
  35. }
  36. ?>
  37. <tr id="remove_row">
  38. <td><button type="button" name="btn_more" data-vid="<?php echo $video_id; ?>" id="btn_more" class="btn btn-success form-control">More</button></td>
  39. </tr>
  40. <?php
  41. }
  42. else
  43. {
  44. ?>
  45. <div class="col-xs-12">
  46. <div class="alert alert-warning">
  47. <span class="glyphicon glyphicon-info-sign"></span> &nbsp; NO HAY PUBLICACIONES ...
  48. </div>
  49. </div>
  50. <?php
  51. }
  52. }
  53. ?>
  54. </div>
Add Comment
Please, Sign In to add comment