PHP & MySQL form question

Question

How do I allow all users to have their username field empty without having them need to enter a username when they submit the form using PHP and MySQL?

Here is part my PHP and MySQL code.

$username = mysqli_real_escape_string($mysqli, $purifier->purify(htmlentities(strip_tags($_POST['username']))));


if(isset($_POST['username'])) {
    // Make sure the username address is available:
    $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']))));
    }
}

possible duplicate of stackoverflow.com/questions/2650043/… — Ben S
– Ben S, Commented Apr 16, 2010 at 3:03
Please re-phrase the question.... What you are asking is not very clear... — SpikETidE
– SpikETidE, Commented Apr 16, 2010 at 4:05

Jacob Relkin · Accepted Answer · 2010-04-16 03:09:45Z

2

This should do the trick: <input type="hidden" name="username" value="somevalue"/>.

answered Apr 16, 2010 at 3:09

Jacob Relkin

163k34 gold badges351 silver badges321 bronze badges

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

Comments

Kanak Vaghela · Accepted Answer · 2010-04-20 06:25:58Z

0

if You did not want to fill your name in form then use hidden fied then use hidden field

answered Apr 20, 2010 at 6:25

Kanak Vaghela

8,47810 gold badges34 silver badges38 bronze badges

Collectives™ on Stack Overflow

PHP & MySQL form question

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