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><br>
   Jusu Zinute:<br>
  <input type="textfield" name="zinute" >
  <br><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 = "sql108.byethost24.com";
	$username = "b24_20709930";
	$password = "";
	$dbname = "b24_20709930_test";

	$conn = new mysqli($servername, $username, $password, $dbname);

    $vardas = $_POST["vardas"];
	$epastas = $_POST["epastas"];
	$zinute = $_POST["zinute"];
	$ip = $_SERVER['SERVER_ADDR'];
	$find = "SELECT * FROM `sarunas_zube`";
	$result = $conn->query($find);
	$number = 0;

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


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(isset($_POST["post"])){
$sql = "INSERT INTO sarunas_zube (ip, vardas, epastas, zinute) VALUES ('$ip', '$vardas', '$epastas', '$zinute')";
}

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


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

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

  if ($conn->query($update) === TRUE){
	echo "Pachmelas papildytas";
}
else{
    echo "Error: " . $update . "<br>" . $conn->error;
    }

/*else if($result->num_rows > 0){
	while($row = $result->fetch_assoc()){
			echo "id ". $row["id"] ." Data ". $row["data"] ." Ip ". $row["ip"] ." Vardas ". $row["vardas"] ." Epastas ". $row["epastas"] ." Zinute ". $row["zinute"] ." <br>";
	}
}*/

  /*else{
  /*  echo "Error: " . $sql . "<br>" . $conn->error;*/
    /*echo "Error: " . $delete . "<br>" . $conn->error;*/
    /*echo "Error: " . $update . "<br>" . $conn->error;*/

	$conn->close();
?>


</body>
</html>