AJAX/PHP - Accessing JSON object properties

Question

I'm attempting to access the properties of a JSON object. My ajax call is:

$.ajax({
  url: 'login.php',
  type: 'post',
  dataType: 'json',
  data: $('#frmLgn').serialize(),
  success: function(data) {
    console.log(data[0].message);
    console.log(data[1].message);
    console.log(data[2].message);
}

The PHP is:

for ($i = 0; $i < $queryMsgCntResults; $i++) {

  $queryGetNew = "SELECT message, msgID FROM $username WHERE isNew = 1;";
  try
  {
    $stmt = $db->prepare($queryGetNew);
    $stmt->execute();
    $message = $stmt->fetch(PDO::FETCH_ASSOC);
    $messageArray[] = $message;         
  } 
  catch(PDOException $ex)
  {
    die("Failed to run query: " . $ex->getMessage()); 
  }     
}
echo json_encode($messageArray);
}

I am expecting this to output:

    console.log(data[0].message); //contents of message1
    console.log(data[1].message); //contents of message2
    console.log(data[2].message); //contents of message3

But instead get:

    console.log(data[0].message); //contents of message1
    console.log(data[1].message); //contents of message1
    console.log(data[2].message); //contents of message1

What am I missing/messing up?

Please close this question. I'm going to re-organize, re-test, and quite likely re-post for clarity. I appreciate all of your assistance, and apologize for wasting anyone's time. Thank you.

Are you sure $messageArray is correct? Have you tried adding a print_r() to make sure? — Richard Deurwaarder
– Richard Deurwaarder, Commented Jun 26, 2013 at 16:49
In your for loop, you are running the same query over and over. Every time, you are getting the same results. — gen_Eric
– gen_Eric, Commented Jun 26, 2013 at 16:49
As your line "$message = $stmt->fetch(PDO::FETCH_ASSOC);" you are getting just the current row instead a rows array, first you must to iterate your result and store it on a array, and the sent this array to json — Carlos
– Carlos, Commented Jun 26, 2013 at 16:51
Where is $username set? Also, if you are using PDO, why are you concatenating the $username variable into the SQL string? — gen_Eric
– gen_Eric, Commented Jun 26, 2013 at 16:54
@RocketHazmat - I have additional PHP code within the same for loop that unsets the isNew flag, so once the first query is run, it won't return the same message. Sorry! — user2442072
– user2442072, Commented Jun 26, 2013 at 17:11

gen_Eric · Accepted Answer · 2013-06-26 16:53:16Z

1

$message = $stmt->fetch(PDO::FETCH_ASSOC);

This line gets one row at a time. You need to keep calling it over and over to get every row.

while($message = $stmt->fetch(PDO::FETCH_ASSOC)){
    $messageArray[] = $message;
}

answered Jun 26, 2013 at 16:53

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

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

3 Comments

Carlos Over a year ago

@user2442072 this is the code block that I have commented before

user2442072 Over a year ago

I have additional code that that unsets the isNew flag, so the first iteration of the for loop retrieves the message and sets the isNew flag to 0, so on the second iteration, that message is not returned. I tried adding the additional code, but SO said I had too much code.

Carlos Over a year ago

Then paste your code or something close for help you, cause as your post that your are requesting is a array results instead a simple row, and you need just a row, you just need "no iteration"

Collectives™ on Stack Overflow

AJAX/PHP - Accessing JSON object properties

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related