Javascript and PHP ajax call with multiple return values returns undefined

Question

I have the following code with which I'm trying to do an AJAX call that can return multiple values

    // Make an ajax call to insert a new row.
    // Newer jquery uses done and fail instead of success and error.
    $.post("add_row_item.php", {
      work_order_id: 1
    }).done(function(data) {
      // Ajax request was successful.
      console.log(data);
      // Check if database query produced errors.
      if(data.error != "") {
        alert('Error trying to add a row - ' + data.error);
      }
    }).fail(function(xhr, status, error) {
      // Ajax request failed.
      var errorMessage = xhr.status + ': ' + xhr.statusText;
      alert('Error trying to add a row - ' + errorMessage);
    });

The PHP code encodes the return message as follows:

echo json_encode(array("error" => "Error: " . mysqli_error($con)));

I get the following on the browser console:

{"error":"Error: Table 'db.tutorials' doesn't exist"}

But the alert gives me an undefined in the message:

Error trying to add a row - undefined

Anybody know where I'm going wrong with the alert part?

Yes, that's where I got the {"error":"Error: Table 'db.tutorials' doesn't exist"} — Superdooperhero
– Superdooperhero, Commented Apr 16, 2019 at 11:58

Nick · Accepted Answer · 2019-04-16 12:00:03Z

3

data is actually a string, '{"error":"Error: Table 'db.tutorials' doesn't exist"}'. You can convert it to an object using JSON.parse:

data = JSON.parse(data);

or alternatively, specify

dataType : "json"

to your ajax call and it will be automatically converted on receipt (see the manual).

answered Apr 16, 2019 at 12:00

Nick

147k23 gold badges67 silver badges106 bronze badges

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

Collectives™ on Stack Overflow

Javascript and PHP ajax call with multiple return values returns undefined

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related