i have three page code in the following :

index.php :

PHP Code:
<?php require_once('includes/funcs.class.php'); $objectUser = new func("localhost","root","","mesaeed"); if(isset($_POST['username'])) { $objectUser->existUsername($_POST['username']); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <script src="js/jquery-1.9.0.min.js" type="text/javascript"></script> <script src="js/juser.js" type="text/javascript"></script> <link rel="stylesheet" href="style.css" /> </head> <body> <div class="divclass"> <form action="index.php" method="post" id="login"> Username : <input type="text" name="username" id="username" /><br /><br /> Password : <input type="text" name="password" id="password" /><br /><br /> <input type="submit" value="login" id="submitlogin" /><br /><br /> </form> </div> </body> </html>
funcs.class.php :

PHP Code:
<?php require_once('connect.class.php'); class func extends connect { protected $_dbusername; protected $_dbemail; protected $_dbpassword//User ..... Functions ..... function existUsername($dbusername) { $this->_dbusername = $dbusername; global $dbtable,$dbsql,$dbquery; $dbtable = "users"; $dbsql = "SELECT * FROM ".$dbtable." WHERE username = ?"; $dbquery = $this->_connect->prepare($dbsql); $dbquery->bind_param("s", $this->_dbusername); $dbquery->execute(); $dbquery->store_result(); if($dbquery->num_rows == 1) { echo "1"; } else { echo "0"; } $dbquery->close(); }
jquery.js :

Code:
// JavaScript Document $(document).ready(function(e) { $("input#username").change(function(e) { var username = $("input#username").val() $.ajax({ type: "POST", url: "index.php", data: {username: username}, success: function(msg){ if(msg == "1") { alert("Ok . "); } else { alert("No . "); } } }); }); });
but it doesnt work !!!!!
if entered username: name , alert no .
if enter username :admin(its the username in the databae) ,alert no .

the orginal code enclosed by me .

the orginal code : http://uploadkon.ir/?file=meSaeed.zip