submitting the validated data to the database
Posted: Thu Aug 27, 2009 9:06 am
Hi
My task is a subscription form it contains
1. Username.
2. Mobile No.
3. Email.
i have to validate the input values if the values are true then the values are to be inserted into the database,
index.php
db.php
can anyone help me on this
My task is a subscription form it contains
1. Username.
2. Mobile No.
3. Email.
i have to validate the input values if the values are true then the values are to be inserted into the database,
index.php
Code: Select all
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Subscription Form</title>
<script language="JavaScript" type="text/javascript">
function valMyForm()
{
var cname, cmobile, cemail;
with(window.document.subform)
{
cname = name;
cmobile = mobile;
cemail = email;
}
if(trim(cname.value) == '')
{
alert('Please enter your name');
cname.focus();
return false;
}
else if(trim(cmobile.value) == '')
{
alert('Please enter your mobile Number');
cmobile.focus();
return false;
}
else if(trim(cemail.value) == '')
{
alert('Please enter your email');
cemail.focus();
return false;
}
else if(!isEmail(trim(cemail.value)))
{
alert('Email address is not valid');
cemail.focus();
return false;
}
else
{
cname.value = trim(cname.value);
cmobile.value = trim(cmobile.value);
cemail.value = trim(cemail.value);
return true;
}
}
function trim(str)
{
return str.replace(/^\s+|\s+$/g,'');
}
function isEmail(str)
{
var regex = /^[-_.a-z0-9]+@(([-_a-z0-9]+\.)+(ad|ae|aero|af|ag|ai|al|am|an|ao|aq|ar|arpa|as|at|au|aw|az|ba|bb|bd|be|bf|bg|bh|bi|biz|bj|bm|bn|bo|br|bs|bt|bv|bw|by|bz|ca|cc|cd|cf|cg|ch|ci|ck|cl|cm|cn|co|com|coop|cr|cs|cu|cv|cx|cy|cz|de|dj|dk|dm|do|dz|ec|edu|ee|eg|eh|er|es|et|eu|fi|fj|fk|fm|fo|fr|ga|gb|gd|ge|gf|gh|gi|gl|gm|gn|gov|gp|gq|gr|gs|gt|gu|gw|gy|hk|hm|hn|hr|ht|hu|id|ie|il|in|info|int|io|iq|ir|is|it|jm|jo|jp|ke|kg|kh|ki|km|kn|kp|kr|kw|ky|kz|la|lb|lc|li|lk|lr|ls|lt|lu|lv|ly|ma|mc|md|mg|mh|mil|mk|ml|mm|mn|mo|mp|mq|mr|ms|mt|mu|museum|mv|mw|mx|my|mz|na|name|nc|ne|net|nf|ng|ni|nl|no|np|nr|nt|nu|nz|om|org|pa|pe|pf|pg|ph|pk|pl|pm|pn|pr|pro|ps|pt|pw|py|qa|re|ro|ru|rw|sa|sb|sc|sd|se|sg|sh|si|sj|sk|sl|sm|sn|so|sr|st|su|sv|sy|sz|tc|td|tf|tg|th|tj|tk|tm|tn|to|tp|tr|tt|tv|tw|tz|ua|ug|uk|um|us|uy|uz|va|vc|ve|vg|vi|vn|vu|wf|ws|ye|yt|yu|za|zm|zw)|(([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|[2][5][0-5])\.){3}([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|[2][5][0-5]))$/i;
return regex.test(str);
}
</script>
</head>
<body>
<center>
<form action="include_db/db.php" method="post" name ="subform" onsubmit=" return valMyForm();">
<table width="250" align="center" border="0" cellpadding="2" cellspacing="1">
<tr>
<td>
Username:  <input type="text" name="name" /><br>
</td>
</tr>
<tr>
<td>
Mobile:       <input type="text" name="mobile" /><br>
</td>
</tr>
<tr>
<td>
Email:         <input type="text" name="email" /><br>
</td>
</tr>
<tr>
<td>
                  <input type="submit" name="subscribe" value="Subscribe"/>
</td>
</tr>
</table>
</form>
</center>
<?php
?>
</body>
</html>Code: Select all
<?php
//connection parameters
$username = "root";
$password = "";
$dbhost = "localhost";
//connection string
$dbconnection = mysql_connect($dbhost,$username,$password) or die("Error with database connection".mysql_error());
//selecting the database
$selectdb = mysql_select_db("example", $dbconnection);
//checking whether database is selected or not
if(!$selectdb)
{
echo "error in connection string".mysql_error();
}
else
{
echo "Connection Successfull";
}
echo "<br/>";
$sql="INSERT INTO subscribe (uname, mobile, email)
VALUES ('$_REQUEST[cname]','$_REQUEST[cmobile]','$_REQUEST[cemail]')";
if (!mysql_query($sql,$dbconnection))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($dbconnection);
?>