1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

username validation in php

Discussion in 'PHP' started by pinku, Apr 3, 2008.

  1. pinku

    pinku New Member

    hi,

    lI am new to php coding. I'd need some help...im setting up a username/password system and need to be able to check whether a new username is unique. I have tired....can u help me?
     
  2. U can do this by just a select query here is the solution

    $query = "SELECT * FROM UserTable WHERE username=".$_Post['username'];
    $Con = mysql_query($query, $connection) or die(mysql_error());
    $row = mysql_fetch_assoc($Con);
    $totalRows = mysql_num_rows($Con);

    if($totalRows>0)
    {
    echo 'Username exist';
    }
    else
    {
    echo 'Unique Username';
    }

    hope this code can help
     

Share This Page