How to check if username already registered

by

mysqli_num_rows() can only be used with SELECT queries, it returns the number of rows in the result set.

To test how many rows were affected by a modification query, use mysqli_affected_rows(). And the argument to this should be $connect, not $result (which is just a boolean).

$result = mysqli_query($connect, $query);
if (!$result) {
    die (mysqli_error($connect));
} elseif (mysqli_affected_rows($connect) == 0) {
    exit ("Username already exists");
} else {
    echo '<h3><font color="red">You have successfully registered</font></h3>';
}

More Related Contents:

  1. Sign in form always showing "Wrong Credentials"
  2. Php condition doesn't work for html [closed]
  3. Php if($var) used to work [closed]
  4. Parse error: syntax error, unexpected ‘else’ (T_ELSE) in C:\xampp3\htdocs\wb_html\login.php on line 8 [duplicate]
  5. Parse error: syntax error, unexpected ‘;’ [closed]
  6. Why is PHP printing variables used in if statement?
  7. About if else statement [closed]
  8. PHP – Change value y,n in database [closed]
  9. PHP If Statement with Multiple Conditions
  10. Does PHP have short-circuit evaluation?
  11. if statement in the middle of concatenation? [closed]
  12. PHP – If/else, for, foreach, while – without curly braces?
  13. Check whether $_POST-value is empty
  14. check if variable empty
  15. Case insensitive string comparison
  16. Using if(isset($_POST[‘submit’])) to not display echo when script is open is not working
  17. Which is Faster and better, Switch Case or if else if?
  18. PHP: Check if variable exist but also if has a value equal to something
  19. What are the differences between backtick and single quote? Can I use IF statement in a query as above?
  20. Simpler way to check if variable is not equal to multiple string values?
  21. PHP check value against multiple values with OR-operator
  22. Type-juggling and (strict) greater/lesser-than comparisons in PHP
  23. Undefined index with PHP sessions
  24. break out of if and foreach
  25. New containing div after every 3 records
  26. endforeach in loops?
  27. Why does (0 == ‘Hello’) return true in PHP?
  28. Prevent Direct Access To File Called By ajax Function [duplicate]
  29. How to install PHP mbstring on CentOS 6.2
  30. PHP code for anti hotlinking

Leave a Comment