Advertisement
rintan

can't retrieve data

Dec 10th, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 5 1.30 KB | None | 0 0
  1. Index.php
  2.         <div class="specia-top">
  3.             <ul class="grid_2">
  4.         <?php
  5.             include ('koneksi.php');
  6.             $query = "SELECT * from produk";
  7.             $result = mysqli_query($conn, $query);
  8.             $row = mysqli_fetch_array($result);
  9.             echo mysqli_error($conn);
  10.             if(mysqli_num_rows($result)>0){
  11.             while($row== mysqli_fetch_array($result)){
  12.         ?>
  13.         <li>
  14.                 <a href="details.php?id=<?php echo $row['id'];?>"><img src='files/gbr_produk/<?php echo $row['gambar'];?>' class="img-responsive" alt=""></a>
  15.                 <div class="special-info grid_1 simpleCart_shelfItem">
  16.                     <h5><?php echo $row['nm_brg']; ?></h5>
  17.                     <div class="item_add"><span class="item_price"><h6><?php echo "IDR", $row['harga_brg'];?></h6></span></div>
  18.                     <div class="item_add"><span class="item_price"><a href="#">add to cart</a></span></div>
  19.                     <div class="item_add"><span class="item_price"><a href="product_detail?id=<?php echo $row['id'];?>">Detail</a></span></div>
  20.                 </div>
  21.         </li>
  22.         <li>
  23.         <?php
  24.             }
  25.             }
  26.         ?>
  27.         </li>
  28.         <div class="clearfix"> </div>
  29.     </ul>
  30.         </div>
  31.  
  32. Koneksi.php
  33. <?php
  34.     $dbname = "pbw_clothing";
  35.     $host = "localhost";
  36.     $username = "root";
  37.     $password = "";
  38.     $conn = mysqli_connect($host, $username, $password, $dbname);
  39.  
  40.         if (mysqli_connect_errno()) {
  41.         echo "koneksi server gagal dilakukan";
  42.         exit();
  43.     }
  44.  
  45.  
  46.  
  47. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement