Napisałem skrypt rejestracji i mam problem z nim bo nie zapisuje on w bazie danych, są tylko puste miejsca ( oprócz "points" tam jest 0 )
<?php
session_start();
if ((!isset($_POST['login1'])) || (!isset($_POST['pass'])))
{
header('Location: index.php');
exit();
}
require_once "connect.php";
$polaczenie = @new mysqli($host, $db_user, $db_password, $db_name);
if ($polaczenie->connect_errno!=0)
{
echo "Error: ".$polaczenie->connect_errno;
}
else
{
$nick = $_POST['nick'];
$login1 = $_POST['login1'];
$pass = $_POST['pass'];
$email = $_POST['email'];
$nick = htmlentities($nick, ENT_QUOTES, "UTF-8");
$login1 = htmlentities($login1, ENT_QUOTES, "UTF-8");
$pass = htmlentities($pass, ENT_QUOTES, "UTF-8");
$email = htmlentities($email, ENT_QUOTES, "UTF-8");
if ($rezultat = @$polaczenie->query(
sprintf("INSERT INTO users (login, pass, email, nick, points )
values ('%s', '%s', '%s', '%s', 0)",
mysqli_real_escape_string($connection, $login1),
mysqli_real_escape_string($connection, $pass),
mysqli_real_escape_string($connection, $email),
mysqli_real_escape_string($connection, $nick))))
{
echo "ok";
}
$polaczenie->close();
}
?>
Proszę o pomoc!