Extracting mySQL query result from PHP object in JavaScript

Question

I apologize if this question has been asked before, but I can't seem to get on of them to work for me. The PHP script passes database results to JavaScript like this:

$queryResult =  mysqli_query($dbase, $query);

if ($queryResult) {
  $result = array();
  while($row = mysqli_fetch_array($queryResult)) {
      $result[] = $row;
  }
}

echo json_encode($result);

JavaScript then receives this through AJAX (result of console.log):

[{"id":"1","name":"Babe Ruth","loginID":"babe","loginPW":"babe123"}]

I've tried JSON.stringify, Object.keys(arr), foreach ($arr as $key => $value), for(i in arr), but all to no success.

How can I read this as key-value pairs?

TIA.

try Json.parse() as described here: w3schools.com/js/js_json_parse.asp — ju_
– ju_, Commented Oct 11, 2017 at 20:11
Thanks ju. Apparently that was the right method, although it had to be accessed with id keys, as Vasya had indicated (the marked answer). — iSofia
– iSofia, Commented Oct 11, 2017 at 20:42

Vasyl Zhuryk · Accepted Answer · 2017-10-11 20:24:34Z

2

You response is array of objects, You can use next code:

var users = JSON.parse(response);

for(var objId in users) {
    // here you can use construction users[objId].your_key

    console.log('id', users[objId].id);
    console.log('name', users[objId].name);
    console.log('loginID', users[objId].loginID);        
    console.log('loginPW', users[objId].loginPW);
}

answered Oct 11, 2017 at 20:24

Vasyl Zhuryk

1,25810 silver badges24 bronze badges

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

1 Comment

iSofia Over a year ago

Thank you very much, Vasya Zhuryk! It worked perfectly, finally.

Ryan Tuosto · Accepted Answer · 2017-10-11 20:11:37Z

1

What you've copied looks like a JS array containing one object.

Assuming your array is arr then:

var obj = arr[0];

console.log(obj.id);

If what you pasted was actually a string, then you'll need to parse that JSON string with var arr = JSON.parse(response); and continue as mentioned above.

answered Oct 11, 2017 at 20:11

Ryan Tuosto

1,95115 silver badges23 bronze badges

1 Comment

iSofia Over a year ago

Thank you for your suggestion, but it just returned undefined.

J0sh0nat0r · Accepted Answer · 2017-10-11 20:19:44Z

1

I think you're looking for JSON.parse, e.g

var user = JSON.parse(response)[0];

// Should print "Babe Ruth"
console.log(user.name);

edited Oct 11, 2017 at 20:19

answered Oct 11, 2017 at 20:10

J0sh0nat0r

2112 silver badges8 bronze badges

2 Comments

iSofia Over a year ago

Thank you for your suggestion, but it just returned undefined.

iSofia Over a year ago

I tried your original posted code, but must have missed your edit. This works too. Thank you, J0sh0nat0r.

Mateo Guzmán · Accepted Answer · 2017-10-11 20:14:01Z

0

You should get the index 0 of your response, then you can manipulate your object.

var response = [{"id":"1","name":"Babe Ruth","loginID":"babe","loginPW":"babe123"}];
response = response[0];

console.log(response.id);

answered Oct 11, 2017 at 20:14

Mateo Guzmán

1,3562 gold badges16 silver badges28 bronze badges

1 Comment

iSofia Over a year ago

Thank you for your suggestion, but it just returned undefined.

Collectives™ on Stack Overflow

Extracting mySQL query result from PHP object in JavaScript

4 Answers 4

1 Comment

1 Comment

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related