Display error message when ajax result return null value

Question

I would like to ask how to display error message when null value and 0 value in the ajax result from SQL

{"value":
    {"columns": [["More than 85%",null],["Less than 85%",0]],
    "type":"pie"}
}

else no pop out message shown.

$.ajax({
    type: "POST",
    url: "charts/prod.php?year=" + $("#selectyear").val() + "&month=" + $("#selectmonth").val(),
    dataType: "json", 
    success: function (result) { 
        var chart = c3.generate({
            bindto: '#piepie',
            data: result.value,
            color: { 
                pattern: ['#f35213', '#f1af4c'] 
            },
            pie: { title: "Productivity", }
        });     
    },
    error: function() {
        if ((result == null) && (result == 0)){ 
            alert ('Data are not ready yet!!');  
        } 
        else {
            ('error');
        }
    }   
});

Barmar · Accepted Answer · 2016-10-18 05:28:56Z

1

The variable result doesn't exist in the error: function. You need to do that test in the success: function.

The null and 0 values are deep in the structure, you need to access them properly.

$.ajax({
    type: "POST",
    url: "charts/prod.php?year=" + $("#selectyear").val() + "&month=" + $("#selectmonth").val(),
    dataType: "json", 
    success: function (result) {
        if (result.value.columns[0][1] == null && result.value.columns[1][1] == 0) {
            alert ('Data are not ready yet!!');
        } else {
            var chart = c3.generate({
                bindto: '#piepie',
                data: result.value,
                color: { 
                    pattern: ['#f35213', '#f1af4c'] 
                },
                pie: { title: "Productivity", }
            });
        }
    },
    error: function() {
        alert('error');
    }   
});

edited Oct 18, 2016 at 5:28

answered Oct 18, 2016 at 5:20

Barmar

789k57 gold badges555 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Barmar Over a year ago

Are you sure the PHP script is returning json_encode(null) or json_encode(0) when there's no data available?

Barmar Over a year ago

Maybe you should be testing if (result.value == null) instead of if (result == null)?

hihi Over a year ago

{"value":{"columns":[["More than 85%",null],["Less than 85%",0]],"type":"pie"}} the result is null and 0

Barmar Over a year ago

That's result.value.columns[0][1] == null and result.value.columns[1][1] == 0.

hihi Over a year ago

{"percentage":["-100","0","-50","-50","0"],"new":"0","pending":"0","completed":"1","ongoing":"1","delay":"1"}

|

Veer · Accepted Answer · 2016-10-18 05:18:36Z

0

Try this,

$.ajax({
   type: "POST",
   url: "charts/prod.php?year=" + $("#selectyear").val() + "&month=" + $("#selectmonth").val(),
   dataType: "json", 
   success: function (result) { 
      if ((result == null) && (result == 0)){ 
        alert ('Data are not ready yet!!');  
      }else {
          var chart = c3.generate({
               bindto: '#piepie',
               data: result.value,
               color: { 
               pattern: ['#f35213', '#f1af4c'] },
               pie: { title: "Productivity", }
          });
       }        
   },
   error: function() {
      alert('error'); 
   }   
 });

answered Oct 18, 2016 at 5:18

Veer

7,1461 gold badge16 silver badges13 bronze badges

1 Comment

Veer Over a year ago

can you post your response here ?? just want to see what response send by server and according to that i can suggest.

Collectives™ on Stack Overflow

Display error message when ajax result return null value

2 Answers 2

9 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related