Untitled

<?php
$conn = mysqli_connect("localhost", "root", "", "laptops");

if (isset($_POST['laptop']))
{

$ID = $_POST['laptop'];
$Marka = $_POST['brand'];
$Model = $_POST['model'];
$Procesor = $_POST['cpu'];
$Ram = $_POST['ram'];
$Graficka = $_POST['gpu'];
$Zaslon = $_POST['display'];
$HDD = $_POST['hdd'];
$SSD = $_POST['ssd'];
$OS = $_POST['os'];
$Tip = $_POST['type'];
$Težina = $_POST['weight'];
$Baterija = $_POST['battery'];
$Touchscreen = $_POST['tchscreen'];
$Svjetleća_tipkovnica = $_POST['backlit_keys'];
$Kamera = $_POST['camera'];
$Zvucnici = $_POST['speakers'];
$USB = $_POST['usb'];
$HDMI = $_POST['hdmi'];
$Cijena = $_POST['price'];
$Kolicina = $_POST['quantity'];


$sql = "INSERT INTO laptop (id_laptop, marka_id, laptop_ime, procesor_id, ram, graficka_id, zaslon_id, hdd, ssd, os_id, tip, tezina, baterija, touchscreen, svjetleca_tipkovnica, kamera, zvucnici, usb_portovi, hdmi, cijena, preostala_kolicina)
values ('$ID', '$Marka', '$Model', '$Procesor', '$Ram', '$Graficka', '$Zaslon', '$HDD', '$SSD', '$OS', '$Tip', '$Težina', '$Baterija', '$Touchscreen', '$Svjetleća_tipkovnica', '$Kamera', '$Zvucnici', '$USB', '$HDMI', '$Cijena', '$Kolicina') ";
$result = $conn->query($sql);
//header("location: test.php");

}
?>

<html>
    <head>
        <!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css">

<!-- jQuery library -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>

<!-- Popper JS -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>

<!-- Latest compiled JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js"></script>

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
    <link rel="stylesheet" type="text/css" href="index.css">
    </head>
    <body>
    <h1>
                Laptop Selector
            </h1>

            <ul>
                <li><a  href="pocetna.php">Home</a></li>
                <li><a class="active" href="test.php">Laptopi</a></li>
                <li><a href="proizvodaci.php">Proizvođaći</a></li>
                <li><a href="gaming.php">Gaming laptopi</a></li>
                <li><a href="search.php">Tražilica</a></li>
                <li><a href="shop.php">Kupovina</a></li>
              </ul>
              <br>
    </body>
</html>

<form method="post">

<table>
    <tbody>
    <tr>
    <td>ID:</td>
    <td><input type="text" name="laptop"><br></td>
    </tr>
    <tr>
    <td>Marka:</td>
    <td><input type="text" name="brand"><br></td>
    </tr>
    <tr>
    <td>Model:</td>
    <td><input type="text" name="model"><br></td>
    </tr>
    <tr>
    <td>Procesor:</td>
    <td><input type="text" name="cpu"><br></td>
    </tr>
    <tr>
    <td>Ram:</td>
    <td><input type="text" name="ram"><br></td>
    </tr>
    <tr>
    <td>Graficka:</td>
    <td><input type="text" name="gpu"><br></td>
    </tr>
    <tr>
    <td>Zaslon:</td>
    <td><input type="text" name="display"><br></td>
    </tr>
    <tr>
    <td>HDD(GB):</td>
    <td><input type="text" name="hdd"><br></td>
    </tr>
    <tr>
    <td>SSD(GB):</td>
    <td><input type="text" name="ssd"><br></td>
    </tr>
    <tr>
    <td>OS:</td>
    <td><input type="text" name="os"><br></td>
    </tr>
    <tr>
    <td>Tip:</td>
    <td><input type="text" name="type"><br></td>
    </tr>
    <tr>
    <td>Težina(KG:</td>
    <td><input type="text" name="weight"><br></td>
    </tr>
    <tr>
    <td>Baterija(Wh):</td>
    <td><input type="text" name="battery"><br></td>
    </tr>
    <tr>
    <td>Touchscreen:</td>
    <td><input type="text" name="tchscreen"><br></td>
    </tr>
    <tr>
    <td>Svjetleća tipkovnica:</td>
    <td><input type="text" name="backlit_keys"><br></td>
    </tr>
    <tr>
    <td>Kamera:</td>
    <td><input type="text" name="camera"><br></td>
    </tr>
    <tr>
    <td>Zvucnici:</td>
    <td><input type="text" name="speakers"><br></td>
    </tr>
    <tr>
    <td>USB portovi:</td>
    <td><input type="text" name="usb"><br></td>
    </tr>
    <tr>
    <td>HDMI:</td>
    <td><input type="text" name="hdmi"><br></td>
    </tr>
    <tr>
    <td>Cijena:</td>
    <td><input type="text" name="price"><br></td>
    </tr>
    <tr>
    <td>Preostala količina:</td>
    <td><input type="text" name="quantity"><br></td>
    </tr>
    </tbody>

</table>
<br>
<input type="submit">
</form>

<?php
if (isset($_POST['laptop']))
{

if($Kolicina > 20){
    echo "<div class=\"alert alert-danger alert-dismissible\">
    <button type=\"button\" class=\"close\" data-dismiss=\"alert\">&times;</button>
    <strong>Pozor!</strong> Prevelika količina. Maksimalno 20 komada!
  </div>";
}
else{
    echo "<div class=\"alert alert-success alert-dismissible\">
        <button type=\"button\" class=\"close\" data-dismiss=\"alert\">&times;</button>
        <strong>Uspjesno dodano!</strong>
      </div>";
}
}

?>