how to have access to 2d array elements using JSON.stringify?

Question

I have posted a question about How to alert a php array in ajax success function in this post: How to alert a php array in ajax success function

I got the answer to use alert(JSON.stringify(result[0])); but this will give me access to the first row of the array while i need to have access to each element of each row. imagine that my array is like this now

 [0]1>>>>2>>>>>3>>>>>5>>>>>6
 [1]1>>>>2>>>>>3>>>>>5>>>>>6
 [2]1>>>>2>>>>>3>>>>>5>>>>>6
 [3]1>>>>2>>>>>3>>>>>5>>>>>6
 [4]1>>>>2>>>>>3>>>>>5>>>>>6
 [5]1>>>>2>>>>>3>>>>>5>>>>>6

alert(JSON.stringify(result[0])) will give me only [0]1>>>>2>>>>>3>>>>>5>>>>>6 but I want to alert 5 only, I have tried alert(JSON.stringify(result[0][3])) but no luck.

Could you tell me how to have access to 2d array elements using JSON.stringify? Or is there any other way than JSON.stringify(result[0]

Here is the ajax function :

  $.ajax({
  type: 'POST',
  url: "profile/ajax/getorder.php",
  data: {id:gotid},
  dataType: 'json',
  cache: false,
  success: function(result) {
  alert(JSON.stringify(result[0]))

      },
  });

here is the php

$ent = $_POST['id'];
$column = array();
$gtord = mysql_query("SELECT * FROM order WHERE oId = '$ent' ");

while($rowmnu2=mysql_fetch_array($gtord))
{
 $column[] =  $rowmnu2;             
}
echo json_encode($column);

Appreciated.

rynhe · Accepted Answer · 2014-01-01 11:13:26Z

0

The json.stringify method simply gets the array in a text format that can be sent to alert. If you are only looking at a single value that isn't an array, you don't need it. Just alert(result[0][3]).

After getting more info:

To access a whole row, use JSON.stringify(result[0]), to look at a specific element use result[0]['user_id']. If you want to use numbers to look at the specific elements, use mysql_fetch_row instead of mysql_fetch_assoc. Hope that helps.

edited Jan 1, 2014 at 11:13

rynhe

2,5291 gold badge22 silver badges27 bronze badges

answered Jan 1, 2014 at 7:57

Damien Black

5,65720 silver badges25 bronze badges

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

10 Comments

Kissa Mia Over a year ago

thanks but that alerts undefined :( here is how i get the result while($rowmnu2=mysql_fetch_assoc($gtord)) { $column[] = array($rowmnu2); } echo json_encode($column);

Damien Black Over a year ago

Are you sure that the getorder.php file is really giving you a two dimensional array? It seems to me that it is a single dimensional array. Perhaps you should check that.

Damien Black Over a year ago

Can you post what is printed on the page if you go to "profile/ajax/getorder.php" directly, I would guess json is not formated right.

Damien Black Over a year ago

are you trying to sent all of those values to alert, or just one element, like the user_id?

Damien Black Over a year ago

also you seem to have an extra [ at the start of your second element, this means that you might be parsing the data incorrectly, and the later elements are more deeply nested then they should be. It looks like your structure is {{}{{}{{}{{}}}} instead of {{}{}{}}{{}{}{}}{{}{}{}}

|

Collectives™ on Stack Overflow

how to have access to 2d array elements using JSON.stringify?

1 Answer 1

10 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related