<?php

//konektimi.php
$conn = new mysqli ("localhost", "", "", "Baza");

$sql = "

create table Perdoruesit
(
    Perdoruesi varchar (50) primary key,
    Password char (40) not null,
    Tel varchar (10) not null
);

";

if ($conn->query($sql))
{
    echo "Keni krijuar tabelen me sukses";
}
else
{
    echo "Tabela nuk eshte krijuar";
    return;
}


//regjistrimi.php
require "konektimi.php";

$canContinue = true;

if (isset ($_POST['user']) && isset ($_POST['pass']) && isset ($_POST['tel']))
{
    $name = $_POST['user'];
    $pass = $_POST['pass'];
    $tel = $_POST['tel'];

    $sql = "select Perdoruesi from Perdoruesit";
    $res = $conn->query($sql);

    while ($row = $res->fetch_assoc())
    {
        $user = $row["Perdoruesi"];

        if ($user == $name)
        {
            echo "Nje perdorues i tille ekziston";
            $canContinue = false;
        }
    }

    if ($canContinue)
    {
        $insertSql = "insert into Perdoruesit () values ('$name', '$pass', '$tel')";

        if ($conn->query ($insertSql))
        {
            echo "Keni futur te dhenen me sukses.";
        }
        else
        {
            echo "Gabim!";
        }
    }
    else
    {
    ?>
        <form method="post" action="<?php $_SERVER["PHP_SELF"]; ?>">
            <input type="text" name='user'></input>
            <input type="text" name='pass'></input>
            <input type="text" name='tel'></input>
            <input type="submit" value="Send"></input>
        </form>

    <?php

    }
}
else
{
    ?>
    <form method="post" action="<?php $_SERVER["PHP_SELF"]; ?>">
        <input type="text" name='user'></input>
        <input type="text" name='pass'></input>
        <input type="text" name='tel'></input>
        <input type="submit" value="Send"></input>
    </form>
    <?php
}
?>