Validating the Form with MySQL

Asked By deangellopeter 0 points N/A Posted on - 08/22/2012

Can anyone help me regarding the issue of MySQL form validator that I want to apply to my web page?

How can I validate the form in case if the username in the database already exists when a new user wants to create the account?

I need the expert opinion.

• Status: Open
• Question Views: 855
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Manhathen Den 5 points N/A #160072

Validating the Form with MySQL

You need to create an SQL which will filter the database to look for username in your table which is the same to the username that the user enters. To do that I used PHP as programming code to connect to MySQL database and validate the user.

<? PHP

$ username =$_POST [username];

If (MySQL_num_rows (MySQL_query ("SELECT fldusername FROM users WHERE fldusername = '$ username '")))

{

$msg=$msg."username already exists";

}

?>PHP

If data on your database table matched to user inputted username then it will give an error message saying that the username already exist. You can use this query in any filed also.

Hope this helped you.

About Manhathen Den

Questions
1

Answers
151

Best Answers
24

• Vote Up 0 Vote Down

• Posted on - 08/23/2012
• Question Category: MySQL Server