joined:Apr 1, 2005
Greetings and thanks to everyone who has helped so far.
I'm almost there as far as the registration form goes. If there are no errors, everything works.
I'm using a form to put data into a MySql database. It involves two pages. The first page is an html page that contains the form itself. Users enter data into the input boxes and then click on the submit button. And when the submit button is clicked, the data from the input boxes is sent to a PHP page that inputs the data into the MySql table.
An abridged version of the code I'm using is posted below.
And if there are no errors, everything works.
But, for example, if one of the fields is empty, an alert box pops up and says "At least one of the fields is empty."
And when I click on the "Ok" button in the alert box, the data in the field is automatically sent and the empty field is entered in the MySql table resulting in a blank field in the table.
What am I doing wrong? What I want is for the information to be sent to the PHP page only when there are no errors.
var usr_name = document.getElementById('u_name')
var passwrd = document.getElementById('pass')
var reenter_passwrd = document.getElementById('reenter_pass')
if (usr_name.value.length==0 || passwrd.value.length==0 || reenter_passwrd.value.length==0)
alert("At least one field is empty.")
<form action="insert_data.php" method="post">
Username: <input type="text" name="user_name" id="u_name">
Password: <input type="password" name="pass_word" id="pass">
Reenter Password; <input type="password" name="reenter_pass_word" id="reenter_pass">
<input type="submit" value="Submit" onClick="check_fields()">
Page two titled "input_data"
$con = mysql_connect("host_address","database_name","password");
die('Could not connect: ' . mysql_error());
$sql="INSERT INTO subjects (username, password)
die('Error: ' . mysql_error());
echo "1 record added";