I'm attempting to retrieve a status from the database using jQuery AJAX. There are 3 potential options for the status: if it is pending, I want to continue loading the request; however, if the status is changed to success or error in the database, the loading request should be interrupted and return the new status (either error or success).
jQuery Code
$.ajax({
type:'get',
url:getStatus.php?record_id=50,
success: function(e){
console.log(e)
}
});
PHP Code - getStatus.php
<?php
require_once ('class/class.php');
$stat = new Stat();
$record_id= $_GET['record_id'];
$status = $stat->getStatus($record_id);
echo $status;
PHP Code - geStatus() Class Method
public function getStatus($record_id){
$query = "SELECT `status` from records ";
$query.= "WHERE `record_id`='{$record_id}'";
/* Get query response */
$response = $this->QueryKey($query);
if($response==true){
$output['success']=$response[0];
}
return json_encode($response);
}
Thank you!