Forgot Password / Register
Site Statistics
Total Members: 520
Total Tutorials: 242
Newsest User: 8884244477
Todays Unique Hits: 247
0 Users 5 Guests Online
Forum Index » PHP + MySQL » [req] username availbable
Posted on Saturday 12th July 2008 at 08:16 PM
UrbanTwitch
templates/default/images/noavatar.png's Avatar
Senior Member
Can someone show me when at register for php user system it says if username is or is not available? Thanks.
Posted on Wednesday 16th July 2008 at 11:53 AM
ilyas-shezad
templates/default/images/noavatar.png's Avatar
Junior Member
You mean this part?
PHP Code
1
2
3
4
5
6
7
8
$password = sha1(md5(md5(sha1(md5(sha1(sha1(md5($password))))))));  
$cname = mysql_query("SELECT `username` FROM `members` WHERE `username` = '$username'");  
$cname= mysql_num_rows($cname);  
//checks to see if the username or email allready exist 
if($cname>=1) {  
echo "The username is already in use";  
}else{
Posted on Wednesday 16th July 2008 at 02:31 PM
UrbanTwitch
templates/default/images/noavatar.png's Avatar
Senior Member
Yeah but I got it. This thread can be locked.