PHP

PHP SQL Nov zavihek

<?php // PHP SQL urnik.php ?>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <link rel="stylesheet" href="/dokumenti/stili.css" type="text/css">
  </head>
  <body>
    <center>
    <p>Urnik</p>
<?php
    $povezava = new mysqli("localhost", "pi", "raspberry","test");
    if ($povezava->connect_error) die("Napaka: " . $povezava->connect_error);
    $id=$_POST['id'];$weekday=$_POST['weekday'];$min=$_POST['min'];$indexvrednost=$_POST['indexvrednost'];$vrednost=$_POST['vrednost'];
    if(isset($_POST['dodaj'])){
    $mysql="insert into urnik (weekday, min, indexvrednost , vrednost) values ('$weekday','$min','$indexvrednost','$vrednost')";
    $podatki = $povezava->query($mysql);
    echo "Id ".$id." dodan!<hr/>";}

if(isset($_POST['nov'])){
    $mysql="insert into urnik (weekday, min, indexvrednost , vrednost) values ('0','0','0','0')";
    $podatki = $povezava->query($mysql);
    echo "Id nov dodan!<hr/>";}

if(isset($_POST['brisi'])){
    $mysql="delete from urnik where id='$id'";
    $podatki = $povezava->query($mysql);
    echo "Id ".$id." zbrisan!<hr/>";}

if(isset($_POST['popravi'])){
    $mysql="update urnik set weekday='$weekday',min='$min',indexvrednost='$indexvrednost',vrednost='$vrednost' where id='$id'";
    $podatki = $povezava->query($mysql);
    echo "Id ".$id." popravljen!<hr/>";}

$mysql="select * from urnik";
    if(isset($_POST['urejeno'])){
      $mysql="select * from urnik order by min";}
    if(isset($_POST['filter'])){
      $mysql="select * from urnik where min='$min'";}
    $podatki = $povezava->query($mysql);
    print("    <table>\n      <th></th><th>Id</th></th><th>weekday</th><th><form method=post><button name=urejeno>min</button></form></th><th>Indexvrednost</th><th>Vrednost</th>");
    while($vrstica = $podatki->fetch_assoc()){
      print("      <tr><form method=post><td><button name=brisi>briši</button><button name=popravi>popravi</button><button name=dodaj>dodaj</button><button name=filter>filter po min</button><input type=hidden name=iducenci value=".$vrstica["iducenci"]."></td>\n");
      print("      </td><td><input type=\"text\" name=\"id\" value=".$vrstica["id"]."></td><td><input type=\"text\" name=\"weekday\" value=".$vrstica["weekday"]."></td><td><input type=\"text\" name=\"min\" value=".$vrstica["min"]."></td><td><input type=\"text\" name=\"indexvrednost\" value=".$vrstica["indexvrednost"]."></td><td><input type=\"text\" name=\"vrednost\" value=".$vrstica["vrednost"]."></td></form></tr>\n");
      }
    print("</table><hr>");
    $povezava->close();
?>
    <form method=post><button name=nov>nov</button></form>
  </body>
</html>