Search the Community

I am trying to check data base to see if the username is availible.. Partial code of js and php The echo $username works I do not get a row count or username database result. The database works with other queries..What do I have wrong? form line-> <div>Username: </div> <input id="username" type="text" onblur="checkusername()" onkeyup="restrict('username')" maxlength="16"> function checkusername(){ var u = _("username").value; if(u != ""){ _("unamestatus").innerHTML = 'checking ...'; var ajax = ajaxObj("POST", "php_includes/nameCheck.php"); ajax.onreadystatechange = function() { if(ajaxReturn(ajax) == true) { _("unamestatus").innerHTML = ajax.responseText; } } ajax.send("usernamecheck="+u); } } nameCheck.php <?php //include_once("classes/connect.php"); if(isset($_POST["usernamecheck"])){ $username = preg_replace('#[^a-z0-9]#i', '', $_POST['usernamecheck']); echo $username; //// query to check if the username is in the db already //// $unameSQL = $db->prepare("SELECT username FROM members WHERE username=:usernamecheck LIMIT 1"); $unameSQL->bindValue(':usernamecheck',$username,PDO::PARAM_STR); try{ $unameSQL->execute(); echo $unameSQL; //NOTHING// $unCount = $unameSQL->rowCount(); echo $uncount; //NOTHING// } catch(PDOException $e){ echo $e->getMessage(); $db = null; exit(); } if($unCount == 0){ echo $username, "is OK"; $db = null; exit(); } else { echo "Sorry, that username is already in use in the system"; exit(); } } ?> <?php include_once("classes/connect.php"); if(isset($_POST["usernamecheck"])){ $username = preg_replace('#[^a-z0-9]#i', '', $_POST['usernamecheck']); echo $username; //// query to check if the username is in the db already //// $unameSQL = $db->prepare("SELECT username FROM members WHERE username=:usernamecheck LIMIT 1"); $unameSQL->bindValue(':usernamecheck',$username,PDO::PARAM_STR); try{ $unameSQL->execute(); echo $unameSQL; $unCount = $unameSQL->rowCount(); echo $uncount; } catch(PDOException $e){ echo $e->getMessage(); $db = null; exit(); } if($unCount == 0){ echo $username, "is OK"; $db = null; exit(); } else { echo "Sorry, that username is already in use in the system"; exit(); } } ?>