Untitled

<!DOCTYPE html>
<html>

<head>
    <meta charset="utf-8">
    <title>Form</title>
</head>

<body>

    <div id="form">
        <form method="post">
        <input type="number" name="id" placeholder="id [redagavimui, trynimui]">
            <br>
            <input type="text" name="name" placeholder="Vardas">
            <br>
            <input type="text" name="email" placeholder="El. Paštas">
            <br>
            <input type="text" name="text" placeholder="Jūsų tekstas">
            <br>
            <button type="submit" name="insert">Siųsti</button>
            <button type="submit" name="update">Redaguoti</button>
            <button type="submit" name="delete">Trinti</button>
            <button type="submit" name="search">Ieskoti</button>
        </form>
    </div>
</body>

</html>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "db";

    $id_sablonas = "/[0-9]{1,8}/";
    $vardo_sablonas = "/[A-Za-z]{5,30}/";
    $pasto_sablonas = "/[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\\.[A-Za-z]{2,6}/";
    $teksto_sablonas = "/\w{5,}/";

// 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['REMOTE_ADDR'];

    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";
        }
    }//insert

    //delete mygtukui
    if (isset($_POST['delete'])) {
        $id = $_POST['id'];
        if (preg_match($id_sablonas, $id)){
            $sql = "DELETE FROM vardas_pavarde WHERE id='$id'";
            if ($conn->query($sql) === TRUE) {
                echo "Irasas istrintas sekmingai";
            } else {
                echo "Klaida - neistrinta: " . $conn->error;
            }
        } else {
            echo "Blogai ivestas id";
        }
    }

    // edite mygtukui
    if (isset($_POST['update'])) {
        $id = $_POST['id'];
        $vardas = $_POST['name'];
        $email = $_POST['email'];
        $text = $_POST['text'];
        $ip = $_SERVER['REMOTE_ADDR'];
        if (preg_match ($id_sablonas, $id) && preg_match($vardo_sablonas, $vardas)
            && preg_match($pasto_sablonas, $email) && preg_match($teksto_sablonas, $text)){

                $sql = "UPDATE vardas_pavarde SET vardas='$vardas', epastas='$email', zinute='$text' WHERE id='$id'";
                if ($conn->query($sql) === TRUE) {
                    echo "Irasas redaguotas sekmingai";
                } else {
                    echo "Klaida - iraso nepavyko redaguoti: " . $conn->error;
                }
        } else {
            echo "Blogai ivesti duomenys";
        }
    }

    // search mygtukui
    if (isset($_POST['search'])) {
        $vardas = $_POST['name'];
        if (empty($vardas)) {
            $sql = "SELECT id, data, vardas, epastas, zinute FROM vardas_pavarde";
        } else{
            $sql = "SELECT id, data, vardas, epastas, zinute FROM vardas_pavarde WHERE vardas LIKE '%$vardas%'";
        }
        $result = $conn->query($sql);
        echo "<table border=1>";
        if ($result->num_rows >0) {
            echo "<tr>
                    <th>nr</th>
                    <th>id</th>
                    <th>data</th>
                    <th>Vardas</th>
                    <th>zinute</th>
                  </tr>";
                  $nr= 1;
            while($row= $result->fetch_assoc()){
                echo "<tr><td> " . $nr++. "</td><td> " . $row["id"]. "</td> <td>" . $row["data"]. "</td> <td>" . $row["vardas"].
                  "</td> <td>  " . $row["zinute"]. "</td> </tr>";
            }
        } else{
            echo "0 result";
        }
        echo "</table>";
    }

$conn->close();
?>