Advertisement
Guest User

Untitled

a guest
Dec 8th, 2016
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.17 KB | None | 0 0
  1. <!-- Grid Section -->
  2. <section class='grid'>
  3. <div class='container'>
  4. <div class='row'>
  5. <?php
  6. $query = ("SELECT
  7. c.collection_id,
  8. p.product_id,
  9. p.main_image,
  10. p.product_name,
  11. p.description,
  12. p.code
  13. FROM collection c
  14. INNER JOIN product p
  15. ON p.collection_id = c.collection_id
  16. WHERE c.collection_id= '".$passedcollectionid."' ");
  17.  
  18. mysqli_query($conn, $query) or die('Error querying database.');
  19.  
  20. $result = mysqli_query($conn, $query);
  21.  
  22. while ($row = mysqli_fetch_array($result)) {
  23. $id = $row ['product_id'];
  24. $image = $row ['main_image'];
  25. $name = $row ['product_name'];
  26. $description = $row ['description'];
  27. $code = $row ['code'];
  28. ?>
  29. <div class='col-xl-3 col-lg-4 col-md-4 col-sm-6 grid-item'>
  30. <a data-toggle='modal' data-target='#view-modal' data-id='<?php echo $row ['product_id']; ?>' id='getProduct' class='grid-link'>
  31. <div class='grid-hover'>
  32. <div class='grid-hover-content'>
  33. <i class='fa fa-plus fa-3x'></i>
  34. </div>
  35. </div>
  36. <?php echo "<img src='img" . $image . "' class='img-responsive'>"; ?>
  37. </a>
  38. <div class='grid-caption'>
  39. <?php
  40. echo "<h4><strong>$name</strong> $code</h4>";
  41. echo "<p>$description </p>";
  42. ?>
  43. </div>
  44. </div>
  45.  
  46. <?php
  47. };
  48. ?>
  49.  
  50. </div>
  51. </div>
  52. </section>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement