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);
?>