Untitled

<!DOCTYPE html>
<html>
<body>
<h2> Registracijos forma</h2>
<form action="" method="post">
  Vardas:<br>
  <input type="text" name="vardas" >
  <br>
  E.pastas:<br>
  <input type="email" name="epastas" >
  <br>
   Jusu Zinute:<br>
  <input type="textfield" name="zinute" >
  <br>
   ID TRINIMUI:<br>
   <input type="id" name="id" >
  <br>
  <input type="submit" name="post" value="Submit" >
  <input type="submit" name="delete" value="Delete" >
  <input type="submit" name="update" value="Update" >
  <input type="submit" name="find" value="Find" >
</form>

<?php
$servername = "sql300.byethost7.com";
    $username = "b7_20712779";
    $password = "programuotojas";
    $dbname = "b7_20712779_db";

    $conn = new mysqli($servername, $username, $password, $dbname);
    $vardas = $_POST["vardas"];
    $epastas = $_POST["epastas"];
    $zinute = $_POST["zinute"];
    $id = $_POST["id"];
    $ip = $_SERVER['SERVER_ADDR'];
    $find = "SELECT * FROM `forma3`";
    $result = $conn->query($find);
    $number = 0;

if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }


    if(isset($_POST["post"])){
$sql = "INSERT INTO forma3 (ip, vardas, epastas, zinute) VALUES ('{$ip}', '{$vardas}', '{$epastas}', '{$zinute}')";
}

if(isset($_POST["delete"])){
$delete = "DELETE FROM `forma3` WHERE id = '$id'";
}
if(isset($_POST["update"])){
$update = "UPDATE `forma3` SET `vardas`= '{$vardas}',`epastas`= '{$epastas}',`zinute`= '{$zinute}' WHERE id = '$id'";
}
if(isset($_POST["find"])){

    if($result->num_rows > 0){
        echo "<p><p><table align=\"left\" border=\"1\" cellspacing=\"3\">\n";
        echo "<tr><th>#Nr</th><th>ID</th><th>Data</th><th>IP</th><th>Vardas</th><th>Epastas</th><th>Zinute</th>";

      while($row = $result->fetch_assoc()){
          $number = $number + 1;
          echo "<tr><td> $number </td><td>". $row["id"] ."</td><td>  ". $row["data"] ."</td><td>  ". $row["ip"] ."</td><td>  ". $row["vardas"] ."</td><td>  ". $row["epastas"] ."</td><td>  ". $row["zinute"] ."</td> </tr><br>";
      }
      echo "</table><br>";
    }
    else {echo "Success";
    }
}


if ($conn->query($sql) === TRUE) {
    echo "Success";
}
else{
     $sql . "<br>" . $conn->error;
    }

 if ($conn->query($delete) === TRUE){
    echo "Success";
}
else{
     $delete . "<br>" . $conn->error;
    }

  if ($conn->query($update) === TRUE){
    echo "Success";
}
else{
    $update . "<br>" . $conn->error;
    }
    $conn->close();
?>