Check if someone is already registered...
Posted: Sun Apr 06, 2003 12:34 am
Hello, what is the lines that I need to output "Username already registered" for a signup form? Thanks.
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<p>Username already registered.</p>Code: Select all
<BR><BR><BR>
<h1>Please signup!</h1>
<p align="center">
<BR><BR><BR>
<Table border=0>
<form action="signup_process.php" method="post">
<tr valign=top>
<th align=right>Desired Username:<td> <input type="text" name="username" maxlength=20><BR>
<tr valign=top>
<th align=right>Desired Password:<td> <input type="password" name="password" maxlength=20><BR>
<tr valign=top>
<th align=right>First Name:<td> <input type="text" name="f_name" maxlength=25><BR>
<tr valign=top>
<th align=right>Last Name:<td> <input type="text" name="l_name" maxlength=25><BR>
<tr valign=top>
<th align=right>Email Address:<td> <input type="text" name="email" maxlength="60"><BR>
<tr valign=top>
<th align=right>Age:<td> <input type="text" name="age" maxlength="3"><BR>
<tr valign=top>
<th align=right>Gender:<td> Male<input type="radio" name="male" value="male"> Female<input type="radio" name="female" value="female"><BR></td>
</table>
<p align="center">
<input type="submit" value="Finish signup!">Code: Select all
<?php
$dbuser = "random";
$dbpass = "random";
$dbname = "random";
$uname = $_POST['username'];
$pword = $_POST['password'];
$fname = $_POST['f_name'];
$lname = $_POST['l_name'];
$email = $_POST['email'];
$age = $_POST['age'];
$gender = $_POST['gender'];
$to = $_POST['email'];
$subject = "Thank you for signing up!";
$link = mysql_connect("localhost", $dbuser, $dbpass) or die ("Database Error: Couldn't Connect!");
$message = "Thank you for signing up, $fname! Your account has been entered into our database.
Username: $uname
Password: $pword
PLEASE DO NOT REPLY TO THIS EMAIL.";
$addy = "From: no-reply@travisbsd.no-ip.org";
mysql_select_db($dbname, $link) or die ("Couldn't open $db!");
$query = "INSERT INTO user_info (username, password, f_name, l_name, email, age, gender)
values( '$uname', '$pword', '$fname', '$lname', '$email', '$age', '$gender' )";
mysql_query($query, $link) or die ("Couldn't input data!");
mysql_close($link);
print "<BR>
<BR>
<BR>
";
print "Thanks for signing up!";
mail($to, $subject, $message, $addy);
?>Code: Select all
...
mysql_select_db($dbname, $link) or die ("Couldn't open $db!");
$query="select uname from user_info were username='$uname'";
$result=mysql_query($query);
if (mysql_num_rows($result)==0) {
$query = "INSERT INTO user_info (username, password, f_name, l_name, email, age, gender)
values( '$uname', '$pword', '$fname', '$lname', '$email', '$age', '$gender' )";
mysql_query($query, $link) or die ("Couldn't input data!");
} else { //
print "Username already taken";
}
mysql_close($link);
...Code: Select all
<? $result=mysql_query($query);
if (mysql_num_rows($result)==0) {
$query = "INSERT INTO user_info (username, password, f_name, l_name, email, age, gender)
?>Code: Select all
$query = "INSERT INTO user_info (username, password, f_name, l_name, email, age, gender)
?>Code: Select all
$query = "INSERT INTO user_info (username, password, f_name, l_name, email, age, gender)";
?>Not if they've just copied and pasted the other code you posted:d1223m wrote:its missing a quote off the end
Code: Select all
$query = "INSERT INTO user_info (username, password, f_name, l_name, email, age, gender) ?>Code: Select all
$query = "INSERT INTO user_info (username, password, f_name, l_name, email, age, gender)"; ?>
Code: Select all
$query = "INSERT INTO user_info (username, password, f_name, l_name, email, age, gender)
values( '$uname', '$pword', '$fname', '$lname', '$email', '$age', '$gender' )";Code: Select all
<?php
$dbuser = "random";
$dbpass = "random";
$dbname = "random";
$uname = $_POST['username'];
$pword = $_POST['password'];
$fname = $_POST['f_name'];
$lname = $_POST['l_name'];
$email = $_POST['email'];
$age = $_POST['age'];
$gender = $_POST['gender'];
$to = $_POST['email'];
$subject = "Thank you for signing up!";
$link = mysql_connect("localhost", $dbuser, $dbpass) or die ("Database Error: Couldn't Connect!");
$message = "Thank you for signing up, $fname! Your account has been entered into our database.
Username: $uname
Password: $pword
PLEASE DO NOT REPLY TO THIS EMAIL.";
$addy = "From: no-reply@travisbsd.no-ip.org";
$dbase = mysql_select_db($dbname, $link) or die ("Couldn't open $db!");
$find_username = mysql_query("SELECT `username` FROM `user_info` WHERE `username` = '$uname'");
if (mysql_num_rows($find_username) != 0) {
die("Username has already been taken.");
} else {
$sql = mysql_query("INSERT INTO `user_info` (`username`, `password`, `f_name`, `l_name`, `email`, `age`, `gender`)
VALUES ('$uname', '$pword', '$fname', '$lname', '$email', '$age', '$gender')", $link) or die ("Couldn't input data!");
mysql_close($link);
print "<BR>
<BR>
<BR>
";
print "Thanks for signing up!";
mail($to, $subject, $message, $addy);
}
?>Code: Select all
$result=mysql_query($query);Code: Select all
$result=mysql_query($query) or die(mysql_error().'<p>'.$query.'</p>');