Untitled

<?php
  echo "<head>
    <script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/2.2.3/jquery.min.js'></script>
</head>";
$host = "localhost";
$user = "lumenart_glavni";
$pass = "LumenartMV";
$baza = "lumenart_baza";
echo "<h1>Artikli</h1>";


//

$mysqli = new mysqli($host, $user, $pass, $baza);

if (mysqli_connect_errno()) {
       die("Nije moguca konekcija!");
}


if (!empty($_GET['action'])) {
    if(!empty($_SESSION['username'])){
                    $sifr = $_GET['sif'];
                    switch($_GET['action']) {
                        case "dodaj":
                    $query = "select * from artikal where sifra ='$sifr'";
                    $result = mysqli_query($mysqli, $query);

                     $row = mysqli_fetch_assoc($result);
                      $array[] = $row;
                    if (empty($_SESSION["korpa"])) {
                         $_SESSION["korpa"] = $array;

                     } else {
                         $_SESSION["korpa"] = array_merge($_SESSION["korpa"], $array);
                     }
                    echo '<script language="javascript">';
                   echo 'alert("Uspesno ste dodali artikal u korpu!")';
                   echo '</script>';
                    }


                    }else{
                    echo '<script language="javascript">';
                   echo 'alert("Morate biti registrovani da bi dodali artikal u korpu!")';
                   echo '</script>';
    }
}

  $upit = "select * from artikal";

if(isset($_GET['trazi'])){
  $upit = "SELECT * FROM artikal where sifra='$rezic'";
  unset($_GET['lupa']);}

if(isset($_POST['stone'])){
  $upit = "SELECT * FROM artikal where vrsta='stonalampa'";}

  if(isset($_POST['lampe'])){
  $upit = "SELECT * FROM artikal where vrsta='lampa'";}

if(isset($_POST['lusteri'])){
  $upit = "SELECT * FROM artikal where vrsta='luster'";}

if(isset($_POST['zidnel'])){
  $upit = "SELECT * FROM artikal where vrsta='zidnalampa'";}

if(isset($_POST['plafonjere'])){
  $upit = "SELECT * FROM artikal where vrsta='plafonjera'";}

if(isset($_POST['svi'])){
  $upit = "SELECT * FROM artikal";}

$rezultat = $mysqli->query($upit);
if ($rezultat) {

//koliko ima svih
$svih= $mysqli->query("select * from artikal");
$svihima = $svih->num_rows;
//koliko ima stonih lampi
  $stonih = $mysqli->query("select * from artikal where vrsta='stonalampa'");
  $stonihima = $stonih->num_rows;
  //koliko ima stonih lampi
  $zidnihl = $mysqli->query("select * from artikal where vrsta='zidnalampa'");
  $zidnihlima = $zidnihl->num_rows;
  //koliko ima obicnih lampi
  $lampi = $mysqli->query("select * from artikal where vrsta='lampa'");
  $lampiima = $lampi->num_rows;
//koliko ima plafonjera
  $lustera = $mysqli->query("select * from artikal where vrsta='luster'");
  $lusteraima = $lustera->num_rows;
//koliko ima lustera
  $plafonjera = $mysqli->query("select * from artikal where vrsta='plafonjera'");
  $plafonjeraima = $plafonjera->num_rows;
echo "<meta charset='utf-8'>";
echo "<body><div class='col-md-12 text-center'>";
echo "<div class=row>";
  //filter
  echo "<div id=pretraga class='col-md-4 text-center'>";
  echo "<form name=pret method=post><table><th><h2>Proizvodi</h2></th>";
  echo "<tr><td>Stone lampe ($stonihima)&nbsp;<input class=lista name=stone type=checkbox></td></tr>";
  echo "<tr><td>Podne lampe ($lampiima)&nbsp;<input class=lista name=lampe type=checkbox></td></tr>";
  echo "<tr><td>Plafonjere ($plafonjeraima)&nbsp;<input class=lista name=plafonjere type=checkbox></td></tr>";
  echo "<tr><td>Lusteri ($lusteraima)&nbsp;<input class=lista name=lusteri type=checkbox></td></tr>";
  echo "<tr><td>Zidne lampe ($zidnihlima)&nbsp;<input class=lista name=zidnel type=checkbox></td></tr>";
  echo "<tr><td>Svi artikli ($svihima)&nbsp;<input class=lista name=svi type=checkbox></td></tr>";
  echo "<tr><td><button style='color: #fff;background: rgb(4,43,96);border-radius: 30px;border: none;' type=submit>Pretraga</button></td></tr>";
  echo "</table></form></div>";
  //lista artikala
while($red = mysqli_fetch_assoc($rezultat)){
  $sifl = "" . $red['sifra'];
  echo "<div class='col-md-4 text-center' style='float: left;'";
  echo "<p align='center'><br><br>";
  echo "<img width='250px' height='250px' src='". $red['slika'] ."'><br>";
  echo "Šifra: <label id=asd name=$sifl>".$red['sifra']."</label><br>";
  echo "Proizvođač: ".$red['proizvodjac']."<br>";
  echo "Model: ".$red['model']."<br>";
  echo "Dimenzije: ".$red['dimenzije']."<br>";
  echo "Materijal: ".$red['materijal']."<br>";
  echo "Sijalično grlo: ".$red['sijalicno_grlo']."<br>";
  echo "Jačina: ".$red['jacina']."<br>";
  echo "Opis: ".$red['opis']."<br>";
  echo "Cena: ".$red['cena']."rsd<br>";
  echo "<a class='btn btn-primary' href='proizvodi.php?action=dodaj&sif=".$red['sifra']."'>Dodaj u korpu</a>";
  echo "</div>";}
  echo "</p></div></div>
  <script type='text/javascript'>
    $('.lista').on('change', function() {
        $('.lista').not(this).prop('checked', false);
    });
  </script>
  <script type='text/javascript'>
  function dodajukorpu(){
  return alert('Uspesno ste dodali artikal u korpu!);
  }
  </script>
  </body>";
}
    $mysqli->close();
?>
  <html>
  <head>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/2.2.3/jquery.min.js"></script>
</head>
  <body>
    <script type="text/javascript">
    $('.lista').on('change', function() {
        $('.product-list').not(this).prop('checked', false);
    });
  </script>
  </body>
</html>