<?php
$servername = "localhost";
$username = "cl54-gorda";
$password = "gorda";
$dbname = "cl54-gorda";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}/*
$sql = "INSERT INTO Percents (email, percent)
VALUES ('maili','5%')";*/

$saxeli=$_POST["saxeli"];
$gvari=$_POST["gvari"];
$ID=$_POST["ID"];
$username=$_POST["nick"];
$status=$_POST["status"];
$password=$_POST["password"];
$gender=$_POST["gender"];


$sql = "INSERT INTO  `users` (  `saxeli` ,  `gvari`, `sqesi`,`id`,`statusi`,`username`,`password` ) VALUES ( '$saxeli',  '$gvari' ,  '$gender','$ID','$statusi','$username','$password') ";

if ($conn->query($sql) === TRUE) {
  // header('Location: ' . $_SERVER['HTTP_REFERER']);
    echo "added  to database ";
} else {
    echo "bliad";
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
/*

$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";
if  {
$sql = "INSERT INTO  `Percents` (  `email` ,  `percent` ) VALUES ( '$email',  '$fPercent' ) ";
print("your subscription for discount successfully added to our base");
}else echo "havent got percent's value";

*/
/*if (($fPercent=='') && ($sPercent =='') && ($tPercent ==''))
    {
        $sql = "INSERT INTO  `Percents` (  `email` ,  `percent` , `cat` ) VALUES ( '$email',  '$foPercent' , '4' ) ";
    }
else
    if  (($sPercent=='') && ($tPercent=='') && ($foPercent==''))
    {
        $sql = "INSERT INTO  `Percents` (  `email` ,  `percent` , `cat` ) VALUES ( '$email',  '$fPercent', '1' )";
    }
else
    if  (($tPercent=='') &&  ($foPercent=='') && ($fPercent==''))
    {
        $sql = "INSERT INTO  `Percents` (  `email` ,  `percent` , `cat` ) VALUES ( '$email',  '$sPercent' , '2' )";
    }
else
     if  (($foPercent=='') &&  ($fPercent=='') &&  ($sPercent==''))
    {
        $sql = "INSERT INTO  `Percents` (  `email` ,  `percent`, `cat` ) VALUES ( '$email',  '$tPercent', '3' )";
    }*/
/*
?>