Untitled

<html>
<head>
<meta charset="utf-8">
<title>Form</title>
</head>
<body>
<div id="form">
<form method="post">
<input type="name" name="name" placeholder="Vardas" pattern="[A-Za-z]{5,30}" title="Minimum 5 simboliai"><br>
<input type="email" name="email" placeholder="El. Paštas" pattern="^[a-zA-Z0-9._][^<>{},;:]+@ [a-zA-Z0-9._][^<>{},;:]+.[a-z]{2,4}$"><br>
<input type="text" name="text" placeholder="Jūsų tekstas" pattern="\w{5,}"><br>
<button type="submit" name="insert" >Siųsti</button>
		<button type="submit" name="redaguoti">Redaguoti</button>
		<button type="submit" name="trinti">Trinti</button>

</form>
</div>
</body>
</html>

<?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" mygtukui
if (isset($_POST["insert"])){
$vardas = $_POST['name'];
$email = $_POST['email'];
$text = $_POST['text'];
$ip = $_SERVER['PHP_SELF'];


$vardo_sablonas = "/[A-Za-z]{5,30}/";
if (preg_match($vardo_sablonas, $vardas)) {
echo "Vardas atitinka šabloną";
}else{
die("Vardas neatitinka šablono");
}

$pasto_sablonas = "/^[a-zA-Z0-9._][^<>{},;:]+@ [a-zA-Z0-9._][^<>{},;:]+.[a-z]{2,4}$/";
if (preg_match($pasto_sablonas, $email)) {
echo "Pastas atitinka šabloną";
}else{
die("Pastas neatitinka šablono");
}

$teksto_sablonas = "/\w{5,}/";
if (preg_match($teksto_sablonas, $text)) {
echo "Tekstas atitinka sablona";
}else{
die("Tekstas neatitinka sablono");
}

$vardo_sablonas = "/[A-Za-z]{5,30}/";
$pasto_sablonas = "^[a-zA-Z0-9._][^<>{},;:]+@ [a-zA-Z0-9._][^<>{},;:]+.[a-z]{2,4}$/";
$teksto_sablonas = "/\w{5,}/";
if (preg_match($vardo_sablonas, $vardas) &&
preg_match($pasto_sablonas, $email) &&
preg_match($teksto_sablonas, $text)){
$sql = "INSERT INTO vardas_pavarde(ip, vardas, epastas, zinute) VALUES('$ip', '$vardas', '$email' , '$text')";

if($conn->query($sql) === TRUE){
echo "New record created successfuly";
}else{
echo "Error: " . $sql . "<br>" . $conn ->error;
}
}else{
echo "Blogai ivesti duomenys";
}
}
$conn->close();
?>