need help with ajax

sauravlnk

Hi friends i m new to to this site any help will be greatly appreciated I am making a sign up form in php and i am using a username availabilty feature there using jsp and ajax when i enter a username In textbox its showing that the username is available or not but when i am submitting the value the not available username is also submited to the database...😕 can anyone pls help me out...here the coding....

check.js
var request;
function createRequest()
{
try{
request=new XMLHttpRequest();
}catch(e){
try{
request=new ActiveXObject("Msxml2.XMLHTTP");
}catch(e){
request=new ActiveXObject("Microsoft.XMLHTTP");
}
}return request;
}

function CheckUsername(username){
request=createRequest()
if (request==null){
alert ("Browser does not support HTTP Request")
return
}

var url="check.php?username="+username
request.open("GET",url,true)
request.onreadystatechange = function () {
if (request.readyState == 4) {
document.getElementById("usernameresult").innerHTML = request.responseText;
}
};
request.send(null);

}

check.php
<?php
$con= mysql_connect('localhost', 'root');
if (!$con) {
die('Could not connect to database server: ' . mysql_error());
}
$dbname = 'my_db';
$db_selected = mysql_select_db($dbname, $con);
if (!$db_selected) {
die("Could not connect $dbname " . mysql_error());
}
$user=$_GET[username];
$check=mysql_num_rows(mysql_query("SELECT * FROM user WHERE username ='$user'")); // Checks to see if a user is in the users table or not.
if($check == 0){
echo 'username available';
}elseif($check != 0){
echo 'username not available';
}

signup.php

<?php
$con=mysql_connect("localhost","root");
if(!$con)
{
echo "db connect failure".mysql_error();
}
mysql_select_db("my_db");
?>
<body><head><script type='text/javascript'>

function formValidator(){
// Make quick references to our fields
var name = document.getElementById('name');
var age = document.getElementById('age');
var addr = document.getElementById('addr');
var phne = document.getElementById('phne');
var username = document.getElementById('username');
var email = document.getElementById('email');
var pass = document.getElementById('pass');
var pass1 = document.getElementById('pass1');

	// Check each input in the order that it appears in the form!
if(isAlphabet(name, "Please enter only letters for your name")){
	if(isNumeric(age, "Please enter numbers only")){
	if(isAlphanumeric(addr, "Numbers and Letters Only for Address")){
	if(isNumeric(phne, "Please enter numbers only")){
		if(emailValidator(email, "Please enter a valid email address")){
		if(lengthRestriction(username, 6, 20)){
		if(madeSelection(pass,"password field cannot be blank")){
		if(madeSelection(pass1,"confirm password field cannot be blank")){
												return true;
					}
				}
			}
		}
	}
	}
	}
	}	
return false;

}

function notEmpty(elem, helperMsg){
if(elem.value.length == 0){
alert(helperMsg);
elem.focus(); // set the focus to this input
return false;
}
return true;
}

function isNumeric(elem, helperMsg){
var numericExpression = /^[0-9]+$/;
if(elem.value.match(numericExpression)){
return true;
}else{
alert(helperMsg);
elem.focus();
return false;
}
}

function madeSelection(elem, helperMsg){
if(elem.value == ""){
alert(helperMsg);
elem.focus();
return false;
}else{
return true;
}
}

function isAlphabet(elem, helperMsg){
var alphaExp = /^[a-zA-Z]+$/;
if(elem.value.match(alphaExp)){
return true;
}else{
alert(helperMsg);
elem.focus();
return false;
}
}

function isAlphanumeric(elem, helperMsg){
var alphaExp = /^{[0-9a-zA-Z]+$/;}
if(elem.value.match(alphaExp)){
return true;
}else{
alert(helperMsg);
elem.focus();
return false;
}
}

?>
</form>
</body>

pls help me😕😕😕

bradgrafelman

sauravlnk;10898349 wrote:
pls help me😕😕😕

You might want to help others (so that they're more apt to help you) by placing your code in the appropriate bbcode tag (e.g.

 or [code=php]) to preserve any code indention as well as provide syntax highlighting.