Es una fórmula qe envía username, name, email, categary. la recoge esta otra que la procesa, y me manda ese error:
La fórmula:
<FORM name="data" METHOD="POST" ACTION="/php/php/udb.php" onSubmit="return check(this)">
Choose a User Name User Name<input name="username" size="12">
Your password will be e-mailed to you.
Please be sure you enter a valid email address below.
Enter Your Information
Your Name<input name="name" size="27">
Email Address
<input name="email" size="27" >
Category of inscription
<select name="category" id="Category">
<option value="comercial" selected>Comercial</option>
<option value="resident">Resident</option>
</select>
<input type="submit" value="Registarme" name="register" >
</FORM>
Y lo recube esta:
<?
session_start();
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>...::::::Registro::::::...</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF">
<?
@ $db=mysql_connect ("localhost", "dombeach_wuser", "wuser");
if (!$db){
echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db ("dominic_dominical");
if ($HTTP_POST_VARS['register']!=""){
$password=getpassword();
$query = "INSERT INTO `Registration` (`username` ,`password`, `admin` , `Validated` , `Name` , `Email` , `category` )
VALUES ("
."'".$username."',"
."'".$password."',"
."0,"
."0,"
."'".$name."',"
."'".$email."',"
."'".$category."')";
$result = mysql_query($query);
if ($result){
sendmail($username,$password,$email);
echo "<script>document.location.href='/php/postuser.html'</script>";
}else{
echo " <script>document.location.href='/php/error.php?err=0'</script>";
//echo $query;
}
} // insertar
if ($HTTP_POST_VARS['password']!=""){
$query = "Select * From Registration where username ='".$username."'";
//echo $query;
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$dbpassword = $row["password"];
if ($dbpassword==NULL){
echo " <script>document.location.href='/ferre/error.php?err=1'</script>";
}else{
if ($mypassword == $dbpassword){
$query = "update Registration set password='".$npassword."' where username ='".$username."'";
$result = mysql_query($query);
if ($result){
echo " <script>document.location.href='/php/passwordchanged.html'</script>";
}else{
echo " <script>document.location.href='/php/error.php?err=3'</script>";
}
}else{
echo " <script>document.location.href='/php/error.php?err=2'</script>";
}
}
} // password
if ($HTTP_POST_VARS['Ingresar']!=""){
$query = "Select * From Registration where username ='".$username."'";
//echo $query;
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$dbpassword = $row["password"];
if ($dbpassword == $password){
session_register("session_username");
$session_username = $username;
echo " <script>document.location.href='/php/menu.php'</script>";
}else{
//echo $query;
echo " <script>document.location.href='/php/error.php?err=4'</script>";
}
} // Actualizar
function getpassword(){
$randomn= mt_rand(0,65000);
return $randomn;
}
?>
</body>
</html>
Se que es mucho, pero tal vez si se hubiquen.
gracias!.
