Submitted by argie on Thursday, May 24, 2012 - 14:17.
Related code: How to Create Secure Registration Page in PHP/MySQL
This is a simple tutorial that will teach you on how to create a simple registration form using PHP/MySQL with JavaScript for input validation. This tutorial will not teach you on how to create a good design but rather to give you knowledge on how to create a fully functional registration form.
Creating our Table
First we are going to create our database which stores our data.
To create a database:
1. Open phpmyadmin
2. Click create table and name it as simple_login.
3. Then name the database as "registration".
4. After creating a database name, click the SQL and paste the below code.
CREATE TABLE IF NOT EXISTS `member` (
`mem_id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(30) NOT NULL,
`password` varchar(30) NOT NULL,
`fname` varchar(30) NOT NULL,
`lname` varchar(30) NOT NULL,
`address` varchar(100) NOT NULL,
`contact` varchar(30) NOT NULL,
`picture` varchar(100) NOT NULL,
`gender` varchar(10) NOT NULL,
PRIMARY KEY (`mem_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
Creating The Form
Next step is to create a form and save it as index.php. To create a form, open your HTML code editor and paste the code below after the tag.
Registration
Creating our Connection
Next step is to create a database connection and save it as "connection.php". This file is used to connect our form to database. This file serves as a bridge between our form and our database.
Writing Our Save Script
Next step is to create our script that save our input data to database and save it as code_exec.php.
Validating The Input
To add some input validation using javascript, add the code below in the head tag of your index.php file. Input validation is used to make sure that all input field are filled out before saving the to database.
That's it! You've been successfully created your simple registration form with javascript for the input validation.
Registration using php, input validation using javascript.
Update:
I have created another tutorial using a server side validation. And I am also using PDO to secure the registration page. Click here to see my latest update How to Create Registration Page in PHP/MySQL Using PDO Query.
Related code: How to Create Secure Registration Page in PHP/MySQL
thanks friends
this is very useful validation example for beginners.
i request you for post more this types of help code
thanks again
ajay gadhavana
9033516452
Nice work, I used it to implement into a database I had set up with logon already. I got errors for the if ($remarks==null and $remarks=="") line and found that the and needs to be changed to or. if ($remarks==null or $remarks=="") $remarks can't have two values at once so that if statement will never run.
Okay this worked perfectly for me, but it appears on top of the registration form (in other words, the registration form does not disappear when you submit the information details..They're still visible on the page..)
So, how do I get to make the registration form no longer visible, and only the message "The registration process was a success. Please proceed by Logging in, thank you!" appear on the page?
Please help shed some light on this matter, thanks in advance!
THANK YOU VERY MUCH, MAY GOD RICHLY BLESS YOU. I AM BEEN SEARCHING ONLINE FOR A LONG TIME BUT NO AVAIL NOT UNTILL TODAY I CAME ACROSS YOUR POST, VERY PRECISE AND ACURATE. PLEASE CAN U HELP ME WITH SIGIN IN PAGE AGAIST THE REGISTRATION PAGE. THANK YOU.
i have a little bit confusion...where is the location we retreive the remarks....i mean $_GET['remarks'].....what it means.....plz clear my doubt...and thanks for code.....
how come on the more secure Login Page using the Md5 code even with a proper connection to the data base the darn login page can't find the username and password.
I've double and triple checked everything I can't solve the problem.
i am getting an error
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in /home3/grabucom/public_html/connection.php on line 7
Could not connect database
help me man
there is no need to validate all the fields once then start checking the value of each single text boxes.
Where your first checking result will be true the rest of course will be true too
Hi there can you someone please help me on the validation part of this code, I keep trying to get to add the validation in to my index.php but it keeps failing to work. Where exactly do insert it because i tried head tags and does not work.