Untitled

<?php

if(session_id() == '' || !isset($_SESSION)){session_start();}

$host = "localhost";
$username = "root";
$pass = "";
$db = "ctsstr";

$koneksi = mysqli_connect($host, $username, $pass, $db);

if(!$koneksi){
  echo 'Koneksi Database Gagal uwu';
}
 ?>
<html>
<head>
	<title>cutest stuff store</title>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<meta http-equiv="X-UA-Compatible" content="ie-edge">
	<link rel ="stylesheet" href="css/bootstrap.min.css">
	<link rel ="stylesheet" href="css/font-awesome.min.css">
  <link rel="stylesheet" href="css/style.css">
</head>
<body>
  <nav class="navbar navbar-light fixed-top navbar-expand-md" style="background-color : #fff">
   <div class="container">
     <a href="index.php" class="navbar-brand">CUTEST STUFF STORE</a>
     <button class="navbar-toggler"  data-toggle="collapse" data-target="#menu">
      <span class="navbar-toggler-icon"></span>
     </button>
     <div class="collapse navbar-collapse" id="menu">
      <ul class="navbar-nav ml-auto">
       <li class="nav-item">
        <a href="index.php" class="nav-link"><i class="fa fa-home"></i> HOME
              </a>
       </li>
       <li class="nav-item">
        <a href="produk.php" class="nav-link"><i class="fa fa-gift"></i> Produk</a>
       </li>
       <li class="nav-item">
        <a href="about.php" class="nav-link"><i class="fa fa-question"></i> About Us</a>
       </li>
       <li class="nav-item">
        <a href="cart.php" class="nav-link"><i class="fa fa-shopping-cart"></i> Cart</a>
       </li>
        <li class="nav-item">
          <a href="contact.php" class="nav-link"><i class="fa fa-phone"></i> Contact</a>
        </li>


        <?php
        if(isset($_SESSION['username'])){
          echo '<li class="nav-item">
            <a href="user.php" class="nav-link"><i class="fa fa-user-circle-o"></i> Account</a>
          </li>
          <li class="nav-item">
            <a href="logout.php" class="nav-link"><i class="fa fa-close"></i>Logout</a>
          </li>';
        }
        else{
          echo '<li class="nav-item">
            <a href="loginform.php" class="nav-link"><i class="fa fa-sign-in"></i> Login</a>
          </li>';
        }
        ?>
      </ul>
     </div>
   </div>
  </nav>
<div class="jarak"></div>
<section>
  <div class="container">
    <div class="row">
      <div class="col text-center">
        <div class="p-5">
          <h1 class="display-4">PRODUK</h1>
        </div>
      </div>
    </div>
  </div>
</section>
<div class="container">
  <select class="form-control" onchange="showData(this.value)">
    <?php
      $query = mysqli_query($koneksi, "SELECT * FROM kategori");
      while($data = $query->fetch_object()){
        echo '<option value="'.$data->id_kategori.'">'.$data->kategori.'</option>';
      }
    ?>
  </select>
  <div id="txtHint">
    <br>
    <div class="row">
    <?php
    $batas = 2;
    $i=0;
    $product_id = array();
    $product_quantity = array();
    $pg = isset( $_GET['pg'] ) ? $_GET['pg'] : "";

    if ( empty( $pg ) ) {
    $posisi = 0;
    $pg = 1;
    } else {
    $posisi = ($pg-1) * $batas;
    }

    $result = mysqli_query($koneksi, "SELECT * FROM produk limit $posisi, $batas");
    $no = 1+$posisi;
    if($result === FALSE){
      die(mysql_error());
    }

    if($result){

      while($obj = $result->fetch_object()){

        echo '
          <div class="col-lg-4">
            <div class="card">
              <div class="container">
              <br>
              <h3 class="card-text">'.$obj->nama.'</h3>
                <img class="card-img-center img-fluid" src="img/'.$obj->img.'" alt="abcdefg">
                  <div class="card-block">
                  <p class="card-text">'.$obj->deskripsi.'
                  <p class="card-text">'.$obj->harga.'
                  <p class="card-text">'.$obj->stok.'';
                    if($obj->stok > 0){
                      echo '<p><a href="update-cart.php?action=add&id='.$obj->id.'"><input class="btn" style="background-color: pink" type="submit" value="Add To Cart"/></a></p>
                      <p><a href="detailproduk.php?id='.$obj->id.'"><input class="btn" style="background-color: grey" type="submit" value="Lihat selengkapnya"/></a></p>

        ';
      }

        else {
          echo 'Stok Habis';
        }
        echo '
        </div>
      </div>
    </div>
  </div>
        ';
        $i++;
      }
    }

    $_SESSION['produk'] = $produk;

    ?>
    <?php
    $no++;
    ?>
    <?php
    //hitung jumlah data
    $jml_data = mysqli_num_rows(mysqli_query($koneksi, "SELECT * FROM produk"));
    //Jumlah halaman
    $JmlHalaman = ceil($jml_data/$batas); //ceil digunakan untuk pembulatan keatas
    echo '<br><div id="body">';
    //Navigasi ke sebelumnya
    if ( $pg > 1 ) {
    $link = $pg-1;
    $prev = "<a href='produk.php?pg=$link'>Sebelumnya </a>";
    } else {
    $prev = "Sebelumnya ";
    }

    //Navigasi nomor
    $nmr = '';
    for ( $i = 1; $i<= $JmlHalaman; $i++ ){

    if ( $i == $pg ) {
    $nmr .= $i . " ";
    } else {
    $nmr .= "<a href=produk.php'?pg=$i'>$i</a> ";
    }
    }

    //Navigasi ke selanjutnya
    if ( $pg < $JmlHalaman ) {
    $link = $pg + 1;
    $next = " <a href=produk.php?pg=$link'>Selanjutnya</a>";
    } else {
    $next = " Selanjutnya";
    }

    //Tampilkan navigasi
    echo $prev . $nmr . $next;
    ?>
      </div>
    </div>
  </div>
  </div>

<script>
  function showData(str) {
    if (str == "") {
        document.getElementById("txtHint").innerHTML = "";
        return;
    } else {
        if (window.XMLHttpRequest) {
            // code for IE7+, Firefox, Chrome, Opera, Safari
            xmlhttp = new XMLHttpRequest();
        } else {
            // code for IE6, IE5
            xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
        }
        xmlhttp.onreadystatechange = function() {
            if (this.readyState == 4 && this.status == 200) {
                document.getElementById("txtHint").innerHTML = this.responseText;
            }
        };
        xmlhttp.open("GET","getkategori.php?q="+str,true);
        xmlhttp.send();
    }
  }
</script>
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.11.0/umd/popper.min.js" integrity="sha384-b/U6ypiBEHpOf/4+1nzFpr53nxSS+GLCkfwBdFNTxtclqqenISfwAzpKaMNFNmj4" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta/js/bootstrap.min.js" integrity="sha384-h0AbiXch4ZDo7tp9hKZ4TsHbi047NrKGLO3SEJAg45jXxnGIfYzk4Si90RDIqNm1" crossorigin="anonymous"></script>
</body>
</html>