I'm just trying to check whether the username already exists, the basic idea is that when the form is sent,my ajax code will connect to checkUsername.php, and checkUsername.php will go to my database and check whether the username is already exists, and return a span.
$.ajax({
url: "checkUsername.php",
type: "post",
data: {"usernameCheck": v1},
dataType:"text",
success:function(data){
alert("system avaliable!!");
if($("#status-not-available").val(data) == "no"){
$('#username').css({'border' : '4px solid red'});
checkUsername = false;
}
else{
$('#username').css({'border' : '4px solid white'});
}
},
fail:function(data){
alert("system not avaliable");
},
});
php:
$database = new SQLite3('myDatabase.db'); //setup connection
$usernameCheck = $_POST['usernameCheck']; //get the username they input
$stmt = $database->prepare("SELECT * FROM users WHERE username = :usernameCheck");
$stmt->bindValue(':usernameCheck',$usernameCheck,SQLite3_TEXT);
$row = $stmt->execute()->fetchArray();
if(isset($row['username'])){
echo "<span class='status-not-available'>no</span>";
}
else{
echo "<span class='status-not-available'>yes</span>";
}