3
Here i created a javascript+php code by which u can create a check available link that u will usually see in many websites.Without submitting the whole form just u can check wther a username exist in the database or not
=================================================-=====
1:filenames: index.php
write a javascript fn like this in the head tag
<script language="javascript">
function x()
{
var y=document.form1.t.value;
open("newtest.php?value="+y,width='10', height='10');
}
</script>
<body>
<form id="form1" name="form1" method="get" action="newtext.php?value=y;">
<p>
<input name="t" type="text" id="t" />
<a href="#" onclick="javascript:x();">checkavailablity</a></p>
</form>
</body>
</html>
==================================================
In 2 nd Page(newtest.php) you can access this value like :
$get_value=$_REQUEST['value'];
//connect to the database
$query="select count(username) as us from <table> WHERE username='$get_value'";
$res=mysql_query($query);
while($row=mysql_fetch_array($res))
{
if($rows['us']>=1)
{
echo "<div align='center'><font color='red'><b>Sorry username exist</b></font></div>";
}
else
{
echo "<div align='center'><font color='blue'><b>You can use this username</b></font></div>";
}
}
