Data Already Exist

Question

Hi, I make a registration form recently using PHP, how to produce an error/message when user input a name that already exist?

Answer 1

Okay I misunderstood your question.
Well first of all you need to add new column called "id" with auto increment.
You check if the row exist using SELECT query and rowCount() in PDO or mysqli_num_rows in mysqli

Answer 2

$pre = $db->prepare("SELECT id FROM users WHERE name=:name)
$pre->bindParam(":name", $name);
$pre->execute();
if($pre->rowCount()) {
echo "Name already exists";
} else {
}

Answer 3

What do you mean exist?
How do you store them. Show me your table.

Answer 4

oh ok tq ^^

Answer 5

lets just assume I have a database name "login" with table named "users" with 3 column which is "email", " name", "password" with value "[email protected]", " boyd", "1234" respectively. And then, when another user register, he/she put the same name on the register form and submit, my code will scan the table in the database if the name already exist.

Answer 6

btw i use xampp and mysql