如何检查用户名是否已被使用，如果没有，请将所选用户名输入MySQL数据库？

Question

I am making a registration system, and I wanted to check wether or not a Username chosen by the user has already been used and if it hasn't already been used, enter the chosen username into the DB?.

below is my query as it is so far, but I keep getting syntax errors. For the record: I am going to use BindParam() to bind the PHP input of the user into the query :)

I also have another column called "ID-number", which is a primary key.

Any help on how to do this is welcome!

Greets,

Romulus

---

SELECT CASE 
WHEN `Username` != `Username`

THEN

INSERT INTO 'T_Users' `Username`, `Password`, `Email`
VALUES ':username', ':password', ':email'

END

FROM `T_Users`

Answer 1

you can do something like this

<?php

$query = mysqli_query($con , "SELECT 1 FROM `T_Users` WHERE username = '$username'");
if(mysqli_num_rows($query) > 0) {
   echo "Username is already taken";
} else {
  # Username is available do insert the Data into Database ....
}



?>