westes
08-13-2008, 01:49 AM
i have mysql set up correctly and i cant get this script to work. I get a white screen. I hope you can help me!
<?php
include("functions.php");
connect();
if(!$_POST['submit']){
echo "<table border=\"0\" cellspacing=\"3\" cellpadding=\"3\">\n";
echo "form method=\"post\" action=\"register.php\">\n";
echo "<tr><td colspan=\"2\" align=\"center\">Registration Form</td></tr>\n";
echo "<tr><td>Username</td><td><input type=\"text\" name=\"password\"></td></tr>\n";
echo "<tr><td>Password</td><td><input type=\"password\" name=\"password\"></td</tr>\n";
echo "<tr><td>Confirm</td><td><input type=\"password\" name=\"passconf\"></td</tr>\n";
echo "<tr><td>E-mail</td><td><input type=\"text\" name=\"email\"></td</tr>\n";
echo "<tr><td>Name</td><td><input type=\"text\" name=\"name\"></td</tr>\n";
echo "<tr><td>AIM Address</td><td><input type=\"text\" name=\"aim\"></td</tr>\n";
echo "<tr><td colspan=\"2\" align=\"center\"<input type=\"submit\" name=\"submit\" value =\"Register\"></td></tr>\n";
}else {
$username = protect($_POST['username']);
$password = protect($_POST['password']);
$confirm = protect($_POST['passconf']);
$email = protect($_POST['email']);
$name = protect($_POST['name']);
$aim = protect($_POST['aim']);
$errors = array();
if(!$username) {
$errors[] = "Username is not defined!";
}
if(!$password) {
$errors[] = "Password is not defined!";
}
if(!$password) {
if(!$confirm) {
$errors[] = "Confirmation password is not defined!";
}
}
if(!$email) {
$errors[] = "E-mail is not defined!";
}
if(!$name) {
$errors[] = "Name is not defined!";
}
if($username) {
if(!ctype_alnum($username)) {
$errors[] = "Username can only contaion numbers and letters!";
}
$range = range(1,32);
if(!in_array(strlen($username),$range)) {
errors[] = "Username must be in between 1 and 32 characters!";
}
}
if($password && $confirm) {
if ($password != $confirm) {
$errors[] = "Passwords do not match!";
}
}
if($name) {
$range2 = range(3,64);
if(!in_array(strlen($name),$range2)) {
errors[] = "Name must be in between 3 and 64 characters!";
}
}
if($aim) {
$range3 = range(3,16);
if(!in_array(strlen($aim),$range3)) {
errors[] = "AIM screename must be in between 3 and 16 characters!";
}
}
if($username) {
$sql = "SELECT * FORM 'users' WHERE 'username'='{$username}'";
$res = mysql_query($sql) or die (mysql_error());
if(mysql_num_rows($res) > 0 {
$errors[] = "The username you supplied is already in use!"
}
}
if($email) {
$sql2 = "SELECT * FORM 'users' WHERE 'email'='{$email}'";
$res2 = mysql_query($sql2) or die (mysql_error());
if(mysql_num_rows($res) > 0 {
$errors[] = "The e-mail address you supplied is already in use!";
}
}
if($aim) {
$sql3 = "SELECT * FORM 'users' WHERE 'aim'='{$aim}'";
$res3 = mysql_query($sql3) or die (mysql_error());
if(mysql_num_rows($res3) > 0 {
$errors[] = "The AIM address you supplied is already in use!";
}
}
if(count($errors > 0) {
foreach($errors AS $error {
echo $error . "<br>\n";
}
}else {
$sql4 = "INSERT INTO 'users'
('username', 'password', 'email', 'name', 'aim')
VALUES ('$username','".md5($password)."','$email', '$name', 'aim');";
$res4 = mysql_query($sql4) or die(mysql_error());
echo "Your have successfully registered with the username of <b>{$username}</b> and the password of <b>{$password}</b>";
}
}
?>
<?php
include("functions.php");
connect();
if(!$_POST['submit']){
echo "<table border=\"0\" cellspacing=\"3\" cellpadding=\"3\">\n";
echo "form method=\"post\" action=\"register.php\">\n";
echo "<tr><td colspan=\"2\" align=\"center\">Registration Form</td></tr>\n";
echo "<tr><td>Username</td><td><input type=\"text\" name=\"password\"></td></tr>\n";
echo "<tr><td>Password</td><td><input type=\"password\" name=\"password\"></td</tr>\n";
echo "<tr><td>Confirm</td><td><input type=\"password\" name=\"passconf\"></td</tr>\n";
echo "<tr><td>E-mail</td><td><input type=\"text\" name=\"email\"></td</tr>\n";
echo "<tr><td>Name</td><td><input type=\"text\" name=\"name\"></td</tr>\n";
echo "<tr><td>AIM Address</td><td><input type=\"text\" name=\"aim\"></td</tr>\n";
echo "<tr><td colspan=\"2\" align=\"center\"<input type=\"submit\" name=\"submit\" value =\"Register\"></td></tr>\n";
}else {
$username = protect($_POST['username']);
$password = protect($_POST['password']);
$confirm = protect($_POST['passconf']);
$email = protect($_POST['email']);
$name = protect($_POST['name']);
$aim = protect($_POST['aim']);
$errors = array();
if(!$username) {
$errors[] = "Username is not defined!";
}
if(!$password) {
$errors[] = "Password is not defined!";
}
if(!$password) {
if(!$confirm) {
$errors[] = "Confirmation password is not defined!";
}
}
if(!$email) {
$errors[] = "E-mail is not defined!";
}
if(!$name) {
$errors[] = "Name is not defined!";
}
if($username) {
if(!ctype_alnum($username)) {
$errors[] = "Username can only contaion numbers and letters!";
}
$range = range(1,32);
if(!in_array(strlen($username),$range)) {
errors[] = "Username must be in between 1 and 32 characters!";
}
}
if($password && $confirm) {
if ($password != $confirm) {
$errors[] = "Passwords do not match!";
}
}
if($name) {
$range2 = range(3,64);
if(!in_array(strlen($name),$range2)) {
errors[] = "Name must be in between 3 and 64 characters!";
}
}
if($aim) {
$range3 = range(3,16);
if(!in_array(strlen($aim),$range3)) {
errors[] = "AIM screename must be in between 3 and 16 characters!";
}
}
if($username) {
$sql = "SELECT * FORM 'users' WHERE 'username'='{$username}'";
$res = mysql_query($sql) or die (mysql_error());
if(mysql_num_rows($res) > 0 {
$errors[] = "The username you supplied is already in use!"
}
}
if($email) {
$sql2 = "SELECT * FORM 'users' WHERE 'email'='{$email}'";
$res2 = mysql_query($sql2) or die (mysql_error());
if(mysql_num_rows($res) > 0 {
$errors[] = "The e-mail address you supplied is already in use!";
}
}
if($aim) {
$sql3 = "SELECT * FORM 'users' WHERE 'aim'='{$aim}'";
$res3 = mysql_query($sql3) or die (mysql_error());
if(mysql_num_rows($res3) > 0 {
$errors[] = "The AIM address you supplied is already in use!";
}
}
if(count($errors > 0) {
foreach($errors AS $error {
echo $error . "<br>\n";
}
}else {
$sql4 = "INSERT INTO 'users'
('username', 'password', 'email', 'name', 'aim')
VALUES ('$username','".md5($password)."','$email', '$name', 'aim');";
$res4 = mysql_query($sql4) or die(mysql_error());
echo "Your have successfully registered with the username of <b>{$username}</b> and the password of <b>{$password}</b>";
}
}
?>