horan1616
03-17-2010, 04:05 PM
I am setting up a basic reigstration page. I have been out of coding for alittle with now. I basically wanted to setup checks for valid data at the registration page however it just submits the query and runs any of the checks sucessfully. Any idea's?
<?php
require '/include/headerdb.php';
$username = $_POST['username'];
$email = $_POST['email'];
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$vcode = rand(1000000000, 9999999999);
$password = $_POST['password'];
$vpassword = $_POST['vpassword'];
if ($password != $vpassword) {
header("Location: register.php?error=1");
}
if ($username == "") {
header("Location: register.php?error=4");
}
if ($email == "") {
header("Location: register.php?error=5");
}
if ($fname == "") {
header("Location: register.php?error=6");
}
if ($lname == "") {
header("Location: register.php?error=7");
}
if ($password == "") {
header("Location: register.php?error=8");
}
$verquery = mysql_query("SELECT * FROM users");
while ($verarray = mysql_fetch_array($verquery)) {
if ($username == $verarray['username']) {
header("Location: register.php?error=2");
}
if ($email == $verarray['email']) {
header("Location: register.php?error=3");
}
}
$newquery = mysql_query("INSERT INTO users (username, password, fname, lname, vcode, email)
VALUE ('$_POST[username]','$_POST[password]','$_POST[fname]','$_POST[lname]','$vcode','$email')");
if (!$newquery) {
header("Location: register.php?error=3");
} else {
header("Location: regcomplete.php");
}
?>
<?php
require '/include/headerdb.php';
$username = $_POST['username'];
$email = $_POST['email'];
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$vcode = rand(1000000000, 9999999999);
$password = $_POST['password'];
$vpassword = $_POST['vpassword'];
if ($password != $vpassword) {
header("Location: register.php?error=1");
}
if ($username == "") {
header("Location: register.php?error=4");
}
if ($email == "") {
header("Location: register.php?error=5");
}
if ($fname == "") {
header("Location: register.php?error=6");
}
if ($lname == "") {
header("Location: register.php?error=7");
}
if ($password == "") {
header("Location: register.php?error=8");
}
$verquery = mysql_query("SELECT * FROM users");
while ($verarray = mysql_fetch_array($verquery)) {
if ($username == $verarray['username']) {
header("Location: register.php?error=2");
}
if ($email == $verarray['email']) {
header("Location: register.php?error=3");
}
}
$newquery = mysql_query("INSERT INTO users (username, password, fname, lname, vcode, email)
VALUE ('$_POST[username]','$_POST[password]','$_POST[fname]','$_POST[lname]','$vcode','$email')");
if (!$newquery) {
header("Location: register.php?error=3");
} else {
header("Location: regcomplete.php");
}
?>