0

Hi to all
i have done validation on my HTML page but the problem is that when i press the submit button it show the alert message that name field is not specified but when i OK that message then data enter into the data base without specifying the name field.i want that i specify the name field then again press the submit button then data enter into database

html code

<html>
<head>

<script type="text/javascript" src="jstest.js"></script>
</head>
<img src="idtech_logo.jpg" alt="logo" width="1500" height="80" />

<body bgcolor="#1E90FF">

<form method="POST"
        onsubmit="return validate_form(this)" action="insert.php">
<h1>
<font size="15" face="Monotype Corsiva" color="black">
<center>ID Technologies</center></font></h1>


<center>
<table>

<tr>
     <td width="50%"> First Name: </td> 
     <td> <input type="text" name="fname" /> </td>
</tr>
<tr>
      <td width="50%"> Last Name :</td> 
      <td> <input type="text" name="lname" /></td>
</tr>
<tr>

      <td width="50%"> Organization Name:</td>
      <td> <input type="text" name="oname"/></td>
</tr>
<tr>

        <td width="50%">Email:</td> 
        <td><input type="text" name="email" /></td>
</tr>

<tr>

   <td width="50%">Contact Number:</td>
   <td><input type="text" name="cno" /></td>
</tr>

<tr>
<td width="50%">Duration in years:</td>
<td><input type="text" name="years"/ ></td>

</tr>
</table>
</center>
<br/>
<center>
<table>
<input type="radio"/>Extend<br/>
<input type="radio"/>Read Only<br/><br/>



<a href="WindowsFormsApplication6.exe">Download link</a>
</br></br>

<tr>

   <td width="50%">MAC ID:</td>
   <td><input type="text" name="mid" /></td>
</tr>

<tr>

   <td width="50%">CPU ID:</td>
   <td><input type="text" name="cid" /></td>
</tr>

<tr>

   <td width="50%">MotherBoard ID:</td>
   <td><input type="text" name="mbid" /></td>
</tr>

</table>
</center>
</br></br>
<center>
<input type="submit" value="submit"/>
</center>
</form>


</body>
</html>

jstest.js code

function validate_required(field,alerttxt) {
	with (field) {
		if (value==null||value=="") {
			alert(alerttxt);
			return false;
		}
		else {
			return true;
		}
	}
}

function validate_email(field,alerttxt) {
	with (field) {
		apos=value.indexOf("@")
		dotpos=value.lastIndexOf(".")
		if (apos<1||dotpos-apos<2) {
			alert(alerttxt);
			return false;
		} else {
			return true;
		}
	}
}

function validate_form(thisform) {
	with (thisform) {
		if (validate_required(fname,"Please specify your First Name!")==false) {
			name.focus();
			return false;
		}
		if (validate_required(email,"Email must be filled out!")==false) {
			email.focus();
			return false;
		}
		if (validate_email(email,"Not a valid e-mail address!")==false) {
			email.focus();
			return false;
		}
		if (validate_required(oname,"Specify the organization name!")==false) {
			color.focus();
			return false;
		}
                if (validate_required(cno,"Enter your contact number!")==false) {
			color.focus();
			return false;
		}
	}
}

insert.php code

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("request_license", $con);
echo   "connection establish </br></br>";

$sql="INSERT INTO user_data (Record_ID,First_Name, Last_Name, Name_Of_Organization,Email,Contact_number,Duration_In_Years,MAC_Address,CPU_ID,Motherboard_ID)
VALUES
('null','$_POST[fname]','$_POST[lname]','$_POST[oname]','$_POST[email]','$_POST[cno]','$_POST[years]','$_POST[mid]','$_POST[cid]','$_POST[mbid]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
else{


 echo "record added";

}
mysql_close($con)
?>

plz help me....

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by ansaripk
0

Hi i find my mistake ...thanxxx to all..actually i was not witng the correct variable name e.g in jstest.js

i write
name.focus();
but i have to write
fname.focus();


thanxx to all

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.