Questions & Answers

stuck why its displaying as undefined instead of returning the correct value. any help would be great. sorry about my awful code. I tried to send the value through cookies and AJAX but still got nothing. Currently i have a call to run the callPHPfunction when the website is loaded then the Test() function runs which runs the Getstatus() that checks the database if the values match a value in the database and return. then the Test() Checks if it has something or not and returns either value as needed.

PHP

if (isset($_GET['functionToCall']) && function_exists($_GET['functionToCall'])) {
    call_user_func($_GET['functionToCall']);
  }
  
  function Test() {
    $status = Getstatus();

    if( is_null( $status ) ){
        return "test2";
        
    }
    if( $status <= 0 ){
        return "test1";
    }

  }

  function Getstatus() {
    $db =& JFactory::getDBO();
    $mc = JRequest::getInt('mc');
    $shift = JRequest::getInt('mc');
    
    $fields = array();
    $fields[] = "*";

    $where = array();
    $where[] = "`mc` = ".$db->quote( $mc );
    $where[] = "`status` = 0";
    $where[] = "`date` = ".$db->quote(date("Y-m-d"));
    $where[] = "`shift` = ".$db->quote( $shift );

    $query = "SELECT ".implode( ",", $fields );
    $query .= " FROM `maintenance`.`autonomous_job` ";
    $query .= "WHERE ".implode( " AND ", $where );
    error_log($query);
    $db->setQuery($query);
    $rows = $db->loadObjectList();

    if($db->getErrorNum()) {
      $error = $db->stderr();
    error_log( $error );
    return null;
        }
    return $rows;
  }


?>

Javascript/Html

function callPHPFunction(mc) {
    var xhttp = new XMLHttpRequest();
    xhttp.open("POST", "helper.php?functionToCall=Test", true);
    xhttp.send();
    jQuery.ajax({
        type: "POST",
        url: "alert.php",
        data: {
            task: "Test",
            $mc: mc
        }
    })

    
}

function FINISHING(mc){

msg += '<br />'+callPHPFunction();
OPERATIONS_errorMsg(msg,0,'barcode');
return false;
}