Parse JSON in Ajax

Question

This is my JS code

function process_file(file_name) {
 $.ajax({
 type: "POST",
 url: "process_file.php?file_name="+file_name,
 datatype : "json",
 cache: true,
 success: function(data) {
 console.log(data);
 //alert(data);
 var error_flag = data[0]["error_flag"];
 var database_insert = data[0]["database_insert"];
 var mysql_message = data[0]["mysql_message"];
 var excel_read_message = data[0]["excel_read_message"];
 alert(mysql_message);
 $("#error_flag").html(error_flag);
 $("#database_insert").html(database_insert);
 $("#mysql_message").html(mysql_message);
 $("#excel_read_message").html(excel_read_message);
 }
 });
}

Console log that is displayed:

[{"error_flag":true,"database_insert":true,"mysql_message":"Data Inserted Successfully","excel_read_message":null}]

I want to extract each variable in js code. I have tried various but not getting what is desired.

• Martin Tournoij: What exactly is the problem? Do you have an error? Which like doesn't work? At a glance, this code seems valid...
• user3331391: Alert is not producing any data its always blank.
• Bart Friederichs: Have you tried to Google your problem? First hit: stackoverflow.com/questions/4935632/…
• Fizer Khan: Do you mean that you cannot access the variable? I think it is dataType, not a datatype. if dataType:'json' will give the javascript object in success callback instead of string.
• user3331391: Thanks @FizerKhan it was a typo. How did I not check that! Thanks any ways for highlighting it.

Answer 1

I think, the data comes as a string, thats why you cannot access the members. Change datatype to dataType

function process_file(file_name) {
 $.ajax({
 type: "POST",
 url: "process_file.php?file_name="+file_name,
 dataType : "json",
 cache: true,
 success: function(data) {
 console.log(data);
 //alert(data);
 var error_flag = data[0]["error_flag"];
 var database_insert = data[0]["database_insert"];
 var mysql_message = data[0]["mysql_message"];
 var excel_read_message = data[0]["excel_read_message"];
 alert(mysql_message);
 $("#error_flag").html(error_flag);
 $("#database_insert").html(database_insert);
 $("#mysql_message").html(mysql_message);
 $("#excel_read_message").html(excel_read_message);
 }
 });

Answer 2

Problem here is the way you are accessing json attribute is not correct. as your json under curley bracket is not array.

You'll have to do like below:

var error_flag = data[0].error_flag;
// repeat it for other vars

• Fizer Khan: No, we can access the members inside object by both ways data[0].error_flag; and data[0]["error_flag"];
• user3331391: Thanks for answer but updating dataType solved the problem.
• Pramod S. Nikam: @FizerKhan - Thanks a lot for suggesting another alternative; was unaware of that.