signup.php
<?php //signup.php with yui
include_once 'header.php';
echo <<<_END
<script src="yahoo-min.js"></script>
<script src="event-min.js"></script>
<script src="connection-min.js"></script>
<script>
function checkUser(user)
{
if(user.value == '')
{
document.getElementById('info').innerHTML = ''
return
}
params = "user=" +user.value
callback = {success:successHandler, failure:failureHandler }
request = YAHOO.util.Connect.asyncRequest('POST', 'checkuser.php, callback, params)
}
function successHandler(o)
{
document.getElementById('info').innerhtml = o.responseText;
}
function successHandler(o)
{
document.getElementById('info').innerHTML = o.status + " " + o.statusText;
}
</script>
<hr> Sign Up Form</hr>
_END;
$error = $user = $pass = "";
if (isset($_SESSION['user'])) destroySession();
if (isset($_POST['user']))
{
$user = sanitizeString($_POST['user']);
$pass = sanitizeString($_POST['pass']);
if ($user == "" || $pass == "")
{
$error = "Not all fields were entered<br /><br />";
}
else
{
$query = "SELECT * FROM members WHERE user='$user'";
if(mysql_num_rows(queryMysql($query)))
{
$error = "That Username is already taken<br /><br />";
}
else
{
$query = "INSERT INTO members VALUES('$user', '$pass')";
queryMysql($query);
}
die("<h4>Account created</h4Please Log in.");
}
}
echo <<<_END
<form method='post' action='signup.php'>$error
Username <input type='text' maxlength='16' name='user' value='$user'
onblur='checkUser(this)'/><span id='info'></span><br />
Password <input type='password' maxlength='16' name='pass'
value='$pass' /><br />
<input type='submit' value='Signup' />
</form>
_END;
?>
checkuser.php
<?php //checkuser.php
include_once 'functions.php';
if (isset($_POST['user']))
{
$user = sanitizeString($_POST['user']);
$query = "SELECT * FROM members WHERE user='$user'";
if (mysql_num_rows(queryMysql($query)))
echo "<font color=red> ←Sorry, already taken</font>";
else echo "<font color=green> ← Username Available</font>";
}
?>
as there are no errors im not sure where i have went wrong. any help would be appreciated

New Topic/Question
Reply
MultiQuote







|