Codul sursa pentru Editare Clienti

<?php
    $servername = "localhost";
    $username = "root";
    $password = "";
    $DBname = "itmaniax";
    $user = $pass = $email = $confirm = "";
    $user_error = $pass_error = $email_error = $confirm_error = $mesaj = "";
    $valid_user = $valid_pass = $valid_confirm = $valid_email = 0;
    $conn = mysqli_connect($servername, $username, $password, $DBname);

function validare()
{
    if(!($GLOBALS['conn']))
    {
        die("Connection to the DB failed: ") . mysqli_connect_error();
        return;
    }

    if(empty($_POST["user"]))
    {
        $GLOBALS['user_error'] = "Campul este gol!";
    }

    else
    {
        $GLOBALS['user'] = $_POST['user'];
        $sql = "SELECT username FROM itmaniax.client";
        $result = mysqli_query($GLOBALS['conn'], $sql);

        while($row = mysqli_fetch_assoc($result))
        {
            if(strcmp($GLOBALS['user'], $row['username']) == 0)
            {
                $GLOBALS['user_error'] = "Username luat!";
                $GLOBALS['valid_user'] = 0;
            }
            else if(!preg_match('/^[a-zA-Z ]*$/', $GLOBALS['user']))
            {
                $GLOBALS['user_error'] = "Username invalid!";
                $GLOBALS['valid_user'] = 0;
            }
            else
            {
                $GLOBALS['valid_user'] = 1;
            }
        }
    }

    if(empty($_POST["email"]))
    {
        $GLOBALS['email_error'] = "Campul este gol!";
    }

    else
    {
        $GLOBALS['email'] = $_POST["email"];
        if(!filter_var($GLOBALS['email'], FILTER_VALIDATE_EMAIL))
        {
            $GLOBALS['email_error'] = "E-mail invalid!";
        }
        else
        {
            $GLOBALS['valid_email'] = 1;
        }
    }

    if(empty($_POST["pass"]))
        $GLOBALS['pass_error'] = "Campul este gol!";
    else
    {
        $GLOBALS['valid_pass'] = 1;
        $GLOBALS['pass'] = $_POST["pass"];
    }

    if(empty($_POST["confirm"]))
        $GLOBALS['confirm_error'] = "Campul este gol!";
    else
    {
        $GLOBALS['confirm'] = $_POST["confirm"];
        if(strcmp($GLOBALS['confirm'], $GLOBALS['pass']) == 0)
        {
            $GLOBALS['valid_confirm'] = 1;
        }
        else
        {
            $GLOBALS['confirm_error'] = "Parola nu e identica!";
        }
    }
}

function inserare_client()
{
    if($GLOBALS['valid_user'] && $GLOBALS['valid_pass'] && $GLOBALS['valid_confirm'] && $GLOBALS['valid_email'] && $GLOBALS['conn'])
    {
        $sql = "INSERT INTO itmaniax.client(username, password, email) VALUES ('".$GLOBALS['user']."', '".$GLOBALS['pass']."', '".$GLOBALS['email']."')";

        if(mysqli_query($GLOBALS['conn'], $sql))
        {
            $GLOBALS['mesaj'] = "A fost adaugat cu succes!";
        }
        else
        {
            $GLOBALS['mesaj'] = "Error: " . mysqli_error($GLOBALS['conn']);
        }
    }
    mysqli_close($GLOBALS['conn']);
}

function stergere()
{
    $gasit = 0;

    if(!($GLOBALS['conn']))
    {
        die("Connection to the DB failed: ") . mysqli_connect_error();
        return;
    }

    if(empty($_POST["user"]))
    {
        $GLOBALS['user_error'] = "Campul este gol!";
    }
    else
    {
        $GLOBALS['user'] = $_POST['user'];
        $sql = "SELECT username FROM itmaniax.client";
        $result = mysqli_query($GLOBALS['conn'], $sql);

        while($row = mysqli_fetch_assoc($result))
        {
            if(strcmp($GLOBALS['user'], $row['username']) == 0)
            {
                $GLOBALS['user'] = $row['username'];
                $gasit = 1;
                break;
            }
        }
    }

    if(!$gasit)
    {
        $GLOBALS['user_error'] = "Userul nu exista!";
    }
    else
    {
        $sql = "DELETE FROM itmaniax.client WHERE username = '".$GLOBALS['user']."'";

        if(mysqli_query($GLOBALS['conn'], $sql))
        {
            $GLOBALS['mesaj'] = "Clientul a fost sters cu success!";
        }
        else
        {
            $GLOBALS['mesaj'] = "Error: " . mysqli_error($GLOBALS['conn']);
        }
    }
    mysqli_close($GLOBALS['conn']);
}

function editeaza()
{
    $gasit = 0;

    if(!($GLOBALS['conn']))
    {
        die("Connection to the DB failed: ") . mysqli_connect_error();
        return;
    }

    if(empty($_POST["user"]))
    {
        $GLOBALS['user_error'] = "Campul este gol!";
    }

    else
    {
        $GLOBALS['user'] = $_POST['user'];
        $sql = "SELECT username FROM itmaniax.client";
        $result = mysqli_query($GLOBALS['conn'], $sql);

        while($row = mysqli_fetch_assoc($result))
        {
            if(strcmp($GLOBALS['user'], $row['username']) == 0)
            {
                $gasit = 1;
                $GLOBALS['valid_user'] = 1;
                break;
            }
        }
    }

    if($gasit == 0)
    {
        $GLOBALS['user_error'] = "Userul nu exista!";
    }
    else
    {
        if(empty($_POST["email"])) // daca nu a introdus nimic in campul "E-mail" va ramane valoarea din db dupa ce va da submit
        {
            $sql = "SELECT email FROM itmaniax.client WHERE username = '".$GLOBALS['user']."'";
            $result = mysqli_query($GLOBALS['conn'], $sql);
            $GLOBALS['email'] = $result; // retin valoarea emailului in $GLOBALS['email'], dar in query imi va da eroare ca nu il putea converti in string
            $GLOBALS['valid_email'] = 1;
        }

        else // altfel se schimba cu valoarea introdusa
        {
            $GLOBALS['email'] = $_POST["email"]; // aici functioneaza corect
            if(!filter_var($GLOBALS['email'], FILTER_VALIDATE_EMAIL))
            {
                $GLOBALS['email_error'] = "E-mail invalid!";
            }
            else
            {
                $GLOBALS['valid_email'] = 1;
            }
        }

        if(empty($_POST["pass"])) // daca nu introduce nimic in campul parola, ramane aceeasi
        {
            $sql = "SELECT password FROM itmaniax.client WHERE username = '".$GLOBALS['user']."'";
            $result = mysqli_query($GLOBALS['conn'], $sql);
            $GLOBALS['pass'] = $result;
            $GLOBALS['valid_pass'] = 1;
        }
        else // altfel se schimba
        {
            $GLOBALS['valid_pass'] = 1;
            $GLOBALS['pass'] = $_POST["pass"]; // aici e bine
        }

        if($GLOBALS['valid_user'] && $GLOBALS['valid_pass'] && $GLOBALS['valid_email'])
        {
            // aici apare eroarea in caz ca nu se introduce nimic,
            $sql = "UPDATE itmaniax.client SET password = '".$GLOBALS['pass']."', email = '".$GLOBALS['email']."' WHERE username = '".$GLOBALS['user']."'";

            if(mysqli_query($GLOBALS['conn'], $sql))
            {
                $GLOBALS['mesaj'] = "Clientul a fost editat cu success!";
            }
            else
            {
                $GLOBALS['mesaj'] = "Error: " . mysqli_error($GLOBALS['conn']);
            }
        }
    }
    mysqli_close($GLOBALS['conn']);
}

if(isset($_POST['submit']))
{
    validare();
    inserare_client();
}

if(isset($_POST['submit_sterge']))
{
    stergere();
}

if(isset($_POST['submit_editeaza']))
{
    editeaza();
}