<?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";

$breakLater = false;

if (isset ($_SESSION['perdoruesi']))
{
    $user = $_SESSION['perdoruesi'];

    echo "Jeni regjistruar me sukses.";
    $breakLater = true;
}

if (isset ($_COOKIE['user']) and isset ($_COOKIE['pass']))
{
    $u = $_COOKIE['user'];
    $p = $_COOKIE['pass'];

    echo $u." mundeni mu kqyq ".$p;
}

if ($breakLater == true)
    return;


$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.";
            $_SESSION['perdoruesi'] = $name;

            if (isset ($_POST['chb']))
            {
                setcookie("user", $name, time() + 10000000);
                setcookie("pass", $pass, time() + 10000000);
            }
        }
        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="checkbox" name='chb'></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="checkbox" name='chb'></input>
        <input type="submit" value="Send"></input>
    </form>
    <?php
}
?>