<?php
if(isset($_POST['submit'])){
# connect to the database here
# search the database to see if the user name has been taken or not
$query = sprintf("SELECT * FROM users WHERE user_name='%s' LIMIT 1",mysql_real_escape_string($_POST['user_name']));
$sql = mysql_query($query);
$row = mysql_fetch_array($sql);
#check too see what fields have been left empty, and if the passwords match
if($row||empty($_POST['user_name'])|| empty($_POST['fname'])||empty($_POST['lname'])|| empty($_POST['email'])||empty($_POST['password'])|| empty($_POST['re_password'])||$_POST['password']!=$_POST['re_password']){
# if a field is empty, or the passwords don't match make a message
$error = '';
if(empty($_POST['user_name'])){
$error .= 'User Name can\'t be empty
';
}
if(empty($_POST['fname'])){
$error .= 'First Name can\'t be empty
';
}
if(empty($_POST['lname'])){
$error .= 'Last Name can\'t be empty
';
}
if(empty($_POST['email'])){
$error .= 'Email can\'t be empty
';
}
if(empty($_POST['password'])){
$error .= 'Password can\'t be empty
';
}
if(empty($_POST['re_password'])){
$error .= 'You must re-type your password
';
}
if($_POST['password']!=$_POST['re_password']){
$error .= 'Passwords don\'t match
';
}
if($row){
$error .= 'User Name already exists
';
}
$error .= '
'
}else{
# If all fields are not empty, and the passwords match,
# create a session, and session variables,
$query = sprintf("INSERT INTO users_table(`user_name`,`f_name`,`l_name`,`email`,`password`)
VALUES('%s','%s','%s','%s',PASSWORD('%s'))",
mysql_real_escape_string($_POST['user_name']),
mysql_real_escape_string($_POST['fname']),
mysql_real_escape_string($_POST['lname']),
mysql_real_escape_string($_POST['email']),
mysql_real_escape_string($_POST['password']))or die(mysql_error());
$sql = mysql_query($query);
# Redirect the user to a login page
header("Location: login.php");
exit;
}
}
# echo out each variable that was set from above,
# then destroy the variable.
if(isset($error)){
echo $error;
unset($error);
}
?>
ben 10 jogos
<!-- Start your HTML/CSS/JavaScript here -->
<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post">
User Name:
<input type="text" name="user_name" <? if(!$row){echo 'value="'.$_POST['user_name'].'"';} ?>/>

First Name:
<input type="text" name="fname" <? echo 'value="'.$_POST['fname'].'"'; ?>/>

Last Name:
<input type="text" name="lname" <? echo 'value="'.$_POST['lname'].'"'; ?>/>

Email:
<input type="text" name="email" <? echo 'value="'.$_POST['email'].'"'; ?>/>

Password:
<input type="password" name="password" />

Re-Type Password:
<input type="password" name="re_password" />

<input type="submit" name="submit" value="Sign Up" />

</form>