<html>
<body>
<?php
#register_add.php
#spojeni do mySQL
require("conn_inc_reg.php");
echo "<center>
Delivery etc Registration form</center>";
$error=false;
$pass_error=false;
if (( $login =="") || ($password =="") || ($password2 =="")) {
$error=true;
}
if ( $password != $password2 ) {
$pass_error=true;
}
if ($error) {
echo "
All fields need to be filled in";
}
if ($pass_error) {
echo "
Both passwords fields need to match";
}
if (($error) || ($pass_error)) {
echo "
Back to the register<a href=\"register.php\">form<a>";
exit;
}
#ak sme tu je vsetko v poriatku ....
$sql="INSERT INTO user (login,password) VALUES ('$login','$password')";
$sql2="SELECT * FROM user WHERE login='$login' AND password='$password'";
#kontrola opakujucich sa zaznamov v tabulke user
$mysql_result=mysql_query($sql2,$connection);
#odstranenie chyb pomocou @
$num_rows=@mysql_num_rows($mysql_result);
if ($num_rows !=0 ) {
echo "
this login is alredy in use try another <a href=\"register.php\">back</a>";
exit;
}
#vkladanie uzivatelskeho mena a hesla
if (!mysql_query($sql,$connection)) {
echo "Error cannot add record... check mysql";
echo "
<a href=\"register.php\">back</a>";
exit;
} else {
#vlozenie vporiadku-informacie pre uzivatela
echo "Table updated [".mysql_affected_rows()."] record added
";
echo "Welcome ....Please make a note of your details
";
echo "Login ID:
$login Password:
$password";
echo "
Go to members <a href=\"register.php\"> login page</a>";
}
mysql_close($connection);
?>
</body>
</html>