如何访问php / mysql查询值以便在jQuery中使用？

Question

I'm trying to enable a button based on a query result using php/mysql and jQuery:

$query = mysql_query("SELECT definition, rating FROM tbl_disease WHERE disease = '".$disease."' ;  ")

The button should be enabled based on the value of 'rating':

<input type="button" name="book" id="book" class="login login-submit"  align="center" value="Book Appointment">

I know how to enable/disable buttons using jQuery so was wondering how I would access the 'rating' value from the query using jQuery and enabling/disabling the button based on that?

Answer 1

Do an Ajax call, In back end execute the query return response. Based on the response you can handle it in jQuery.

$.ajax({
  type: 'POST',
  url: "/updateFunction",
  data: {
    records: "disease"
  },
  success: function(result) {
    alert(result)
    // do your stuff here           
  }
});