Not adding to the DB [PHP]
When you press register, it doesn't add the contents to the database. All it does is refresh the page.
PHP Code:
<?php
if($logged['in'] == 1){
header("Location: index.php");
}
if(row_exists('users','ip',$ip)){ ?>
Your IP ($ip) has already been registered with.
<?php }
else{
if($_GET["action"] == "register"){
$username = clean($_POST['username']);
$email = clean($_POST['email']);
$password = clean($_POST['password']);
$cpassword = clean($_POST['cpassword']);
$errors = 0;
$error_message = '';
if(empty($username) || empty($email) || empty($password) || empty($cpassword)){
$errors++;
$error_message = 'All fields must be filled in.';
}
if(row_exists('users','username',$username)){
$errors++;
$error_message = 'That username is already taken.';
}
if(row_exists('users','email',$email) || !is_valid_email($email)){
$errors++;
$error_message = 'That email is alreayd in use or is incorrect.';
}
$password = enc($password);
$cpassword = enc($cpassword);
if($password != $cpassword){
$errors++;
$error_message = 'The two passwords you entered do not match.';
}
if($errors = 0){
$insert = mysql_query("INSERT INTO `users` (`username`,`password`,`email`,`ip`,`joindate`,`jointime`) VALUES ('".$username."','".$password."','".$email."','".$ip."','".$date."','".$time."')");
$subject = "Welcome to willSystem";
$body = "Thanks for joining (test message from willSystem demo.)";
send_mail($email,$subject,$body);
?>
Thanks for joining, you may now <a href="login.php">login</a>.
<?php
exit();
} else{
echo $error_message;
}
}
?>
<form method="post" action="?action=register">
Username<br />
<input type="text" name="username" value="<?=$username?>" maxlength="12"><br /><br />
Email<br />
<input type="text" name="email" value="<?=$email?>"><br /><br />
Password<br />
<input type="password" name="password"> Confirm <input type="password" name="cpassword"><br /><br />
<input type="submit" name="register" value="Register"><br /><br />
All fields are required.
</form>
<?php
}
?>
Thanks for any help given.
