PHP username check function not working

Question

$con = mysqli_connect("localhost","root","","database");

function user_exists($username) {
$username = sanitize($username);
$query = "SELECT COUNT(user_id) FROM users WHERE username = '$username'";
$result = mysqli_query($con, $query);
return (mysql_result($result, 0) == 1) ? true : false;
}

I believe there is an error in the query because I always get "Username is taken" error, doesnt matter if I insert an existing username or not.

** SOLVED THANKS **

You haven't got $con defined in the function scope. You either need to pass it in with your function parameters, set up the connection within the function itself, or pass it in via a globally accessible class (such as $con = dbmanager::getConnection()). — nealio82
– nealio82, Commented Nov 22, 2013 at 11:38

Harish Singh · Accepted Answer · 2013-11-22 12:23:10Z

0

try this

$query = "SELECT COUNT(user_id) as user_id FROM users WHERE `username` = '$username'";
$result = mysqli_query($con, $query);

mysql_result will not return you the result , it will send error so it gives you true always.

use below code to get result

$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
if($row['user_id']){ return true; } else { return false; }

edited Nov 22, 2013 at 12:23

answered Nov 22, 2013 at 11:38

Harish Singh

3,3195 gold badges27 silver badges40 bronze badges

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

1 Comment

Harish Singh Over a year ago

do not use mysql_result use mysqli_fetch_array check updated answer

Collectives™ on Stack Overflow

PHP username check function not working

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related