PHP & MySQL username submit problem

Question

I want to allow users to either have there username field empty at any time but I get the username error message Your username is unavailable! how can I correct this problem?

Here is the PHP code.

if(isset($_POST['username'])) {

    $u = "SELECT * 
          FROM users 
          WHERE username  = '$username'
          AND user_id <> '$user_id'";
    $r = mysqli_query ($mysqli, $u) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($mysqli));

    if (mysqli_num_rows($r) == TRUE) { // Unavailable.
        echo '<p class="error">Your username is unavailable!</p>';
        $username = NULL;
    } else if(mysqli_num_rows($r) == 0) { // Available.
        $username = mysqli_real_escape_string($mysqli, $purifier->purify(htmlentities(strip_tags($_POST['username']))));
    }
}

NONE of these examples are working. I want to know how can I let my users have no username?

Billiam · Accepted Answer · 2010-04-16 01:38:29Z

1

if(isset($_POST['username']) && trim($_POST['username'])!=='') {

Otherwise, $_POST['username'] will be set even if the form is submitted with an empty field.

answered Apr 16, 2010 at 1:38

Billiam

2,3492 gold badges19 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sergei · Accepted Answer · 2010-04-16 01:39:54Z

0

if(isset($_POST['username']) && !empty($_POST['username'])) {
...

answered Apr 16, 2010 at 1:39

Sergei

2,7571 gold badge17 silver badges17 bronze badges

Collectives™ on Stack Overflow

PHP & MySQL username submit problem

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related