Untitled

<!DOCTYPE html>
<html>
<head>
	<title>Untitled</title>
	<meta charset='utf-8'>
	<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
	<form method='post'>
		<p> Table info</p>
		<input type='text' name='firstname' placeholder='Vardas' pattern='[a-zA-Z]{5,30}'><br>
		<input type='text' name='email' placeholder='Email' pattern='[a-zA-Z0-9]+@[a-zA-Z0-9]+.[a-zA-Z]{2,5}'><br>
		<input type='text' name='message' placeholder='Tekstas' pattern='[a-zA-Z0-9\s]{5,}'><br>
		<button type='submit' name='insert'>Siusti</button><br>
		<input type='text' name='deleteEdit' placeholder='ID' pattern='[0-9]{1,4}'><br>
		<button type='submit' name='edit'>Redaguoti</button>
		<button type='submit' name='delete'>Trinti</button>
		<button type='submit' name='display'>Rodyti duombaze</button>
	</form>
<?php
	$servername = "localhost";
	$username = "root";
	$password = "";
	$dbname = "test";

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

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

	// Insert

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

	  $name = $_POST['firstname'];
	  $email = $_POST['email'];
	  $text = $_POST['message'];
	  $ip = $_SERVER['REMOTE_ADDR'];


		 if ((preg_match('/[a-zA-Z]{5,30}/', $name)) and (preg_match('/[a-zA-Z0-9]@[a-zA-Z0-9].[a-zA-Z]{2,5}/', $email)) and (preg_match('/[a-zA-Z0-9\s]{5,}/', $text))) {

		  	$sql = "INSERT INTO mantas_zukauskas(ip, vardas, epastas, zinute) VALUES('$ip', '$name', '$email', '$text')";
		        if ($conn->query($sql) === TRUE) {
	   	  	echo "New record created successfully";
		        } else {
	   		echo "Error: " . $sql . "<br>" . $conn->error;
		  }
		  } else {
		  	die ("Form filled incorrectly");
		  }
		}

	// Delete

	if (isset($_POST['delete'])) {
		$id = $_POST['deleteEdit'];

		$check = mysqli_query($conn, "SELECT * FROM mantas_zukauskas WHERE id = '$id'");

		if (mysqli_num_rows($check) > 0) {
 			 } else {
 		 	die ("ID does not exist in table");
 			 }

		if (preg_match('/[0-9]{1,4}/', $id)) {
			$sql ="DELETE FROM mantas_zukauskas WHERE id = '$id'";
			if ($conn->query($sql) === TRUE) {
				echo "Record deleted successfully";
			} else {
				echo "Error: " . $sql . "<br>" . $conn->error;
			}
		} else {
			die ("Error, not deleted");
			}
		}

	// Edit

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

		$id = $_POST['deleteEdit'];
		$name = $_POST['firstname'];
		$email = $_POST['email'];
		$text = $_POST['message'];
		$ip = $_SERVER['REMOTE_ADDR'];


			if ((preg_match('/[a-zA-Z]{5,30}/', $name)) and (preg_match('/[a-zA-Z0-9]@[a-zA-Z0-9].[a-z]{2,5}/', $email)) and (preg_match('/[a-zA-Z0-9\s]{5,}/', $text)) and (preg_match('/[0-9]{1,4}/', $id))) {

				$check = mysqli_query($conn, "SELECT * FROM mantas_zukauskas WHERE id = '$id'");

				if (mysqli_num_rows($check) > 0) {} else {
 					die ("ID does not exist in table");
 				}

		  		$sql = "UPDATE mantas_zukauskas SET vardas ='$name', epastas = '$email', zinute = '$text', ip = '$ip' WHERE id='$id'";

				if ($conn->query($sql) === TRUE) {
		   	  		echo "Record updated successfully";
				} else {
		   			echo "Error: " . $sql . "<br>" . $conn->error;
				}
			} else {
				 die ("Form filled incorrectly");
			}
	}

	// Show data on page

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

		$id = $_POST['deleteEdit'];
		if ($id == TRUE) {
			$check = mysqli_query($conn, "SELECT * FROM mantas_zukauskas WHERE id = '$id'");
		} else {
			$check = mysqli_query($conn, "SELECT * FROM mantas_zukauskas");
		}
		if ($check->num_rows > 0) {
			while ($row = $check->fetch_assoc()) {
				echo "ID: " . $row["id"]. " Vardas: " . $row["vardas"]. " E-mail: " . $row["epastas"]. " Zinute: " . $row["zinute"]. "<br>";
			}
		}
	}

$conn->close();

?>
</body>
</html>