Registrace

<?php
// Povinný
$user = @$_POST['username'];
$pass = @$_POST['password'];
$verifypa = @$_POST['passverify'];
$mail = @$_POST['email'];
$gender = @$_POST['gender'];
// Nepovinný
$name = @$_POST['name'];
$surname = @$_POST['surname'];
$icq = @$_POST['icq'];
$jabber = @$_POST['jabber'];
$skype = @$_POST['skype'];
$msn = @$_POST['msn'];
$www = @$_POST['www'];
$phone = @$_POST['phone'];
$state = @$_POST['state'];
$born = @$_POST['born'];
$ints = @$_POST['ints'];
$age = @$_POST['age'];
$say = @$_POST['say'];
$job = @$_POST['say'];
// Jiný
$show = @$_POST['show'];
if ($show == "ok") {
if (!empty($user) && !empty($pass) && !empty($verifypa) && !empty($mail) && $pass == $verifypa) {
$conn = mysql_connect("*********", "*******", "****") or die("Nepodarilo se pripojit k databszi.");
$sel = mysql_select_db("**");
$val = "(user, pass, mail, gender";
if (isset($name)) { $val .= ", name"; }
if (isset($surname)) { $val .= ", surname"; }
if (isset($icq)) { $val .= ", icq"; }
if (isset($jabber)) { $val .= ", jabber"; }
if (isset($skype)) { $val .= ", skype"; }
if (isset($msn)) { $val .= ", msn"; }
if (isset($www)) { $val .= ", www"; }
if (isset($phone)) { $val .= ", phone"; }
if (isset($state)) { $val .= ", state"; }
if (isset($born)) { $val .= ", born"; }
if (isset($ints)) { $val .= ", ints"; }
if (isset($age)) { $val .= ", age"; }
if (isset($say)) { $val .= ", say"; }
if (isset($job)) { $val .= ", job"; }
$val .= ")";
$ins = "('$user', '$pass', '$mail', '$gender'";
if (isset($name)) { $ins .= ", '$name'"; }
if (isset($surname)) { $ins .= ", '$surname'"; }
if (isset($icq)) { $ins .= ", '$icq'"; }
if (isset($jabber)) { $ins .= ", '$jabber'"; }
if (isset($skype)) { $ins .= ", '$skype'"; }
if (isset($msn)) { $ins .= ", '$msn'"; }
if (isset($www)) { $ins .= ", '$www'"; }
if (isset($phone)) { $ins .= ", '$phone'"; }
if (isset($state)) { $ins .= ", '$state'"; }
if (isset($born)) { $ins .= ", '$born'"; }
if (isset($ints)) { $ins .= ", '$ints'"; }
if (isset($age)) { $ins .= ", '$age'"; }
if (isset($say)) { $ins .= ", '$say'"; }
if (isset($job)) { $ins .= ", '$job'"; }
$ins .= ")";
$sql = "INSERT INTO users $val values $ins;";
if (mysql_query($sql)) { Header("Location: http://www.seznam.cz/"); } else { Header("Location: http://www.google.cz/"); }
} else {
echo('<input type="hidden" name="show" value="ahoj">');
$error = "Registrace nebyla úspěšná:\\n";
if (empty($user)) { $error .= " - Uživatelské jméno nebylo zadáno\\n"; }
if (empty($pass)) { $error .= " - Heslo nebylo zadáno\\n"; }
if (empty($verifypa)) { $error .= " - Kontrola hesla nebyla zadána\\n"; }
if (empty($mail)) { $error .= " - Email nebyl zadán\\n"; }
if (empty($gender)) { $error .= " - Pohlaví nebylo zadáno\\n"; }
if ($pass != $verifypa) { $error .= " - Hesla nejsou shodná\\n"; }
echo("<script>alert('".$error."');</script>");
}
}
?>

INSERT INTO users (user, pass, mail, gender, name, surname, icq, jabber, skype, msn, www, phone, state, born, ints, age, say, job) values ('Werewolf', 'omfgnewim', 'TomAgrav@seznam.cz', 'm', '', '', '', '', '', '', '', '', '', '', '', 'nechci', '', '');