How to read data from json array in jquery?

Question

I have to retrieve many rows from MySQL and send by encoding with ajax and I done this. but the problem is I am not able to handle the output array data in ajax. can anyone help me please?

1>one.php

<?php   



  $host = "localhost";
  $user = "root";
  $pass = "";

  $databaseName = "elearning";
  $tableName = "users";



    $con = mysql_connect($host,$user,$pass);
    $dbs = mysql_select_db($databaseName, $con);
    if(isset($_POST)){

                $exam_id=$_POST['exam_id'];
                $sql="select * from exam_to_question where exam_id=$exam_id";
                $result = mysql_query($sql);

                $dataArray = array();

                while($array = mysql_fetch_assoc($result)){
                    $dataArray[] = $array;
                } 

                echo json_encode($dataArray);
    }

?>

2> and ajax code is:

   $.ajax({    
      type: 'POST',
      url: '../functions/one.php',                          
      data: "exam_id="+exam_id,         
      dataType: 'json',
      success: function(data){


             //alert(data[0]['question_id']);
            // i have to handle data here 

            },
      error:function(){
    alert("AJAX failure");
        }   
    });

Can you post your JSON data? You may look into api.jquery.com/jQuery.each. Also a good read learn.jquery.com/using-jquery-core/iterating — Satpal
– Satpal, Commented Apr 8, 2014 at 8:12
alert(data); gives me output [object Object],[object Object],[object Object],[object Object],[object Object] . — Code_Crash
– Code_Crash, Commented Apr 8, 2014 at 8:14
Learn to use console.log read stackoverflow.com/questions/4539253/what-is-console-log. — Satpal
– Satpal, Commented Apr 8, 2014 at 8:14

Jai · Accepted Answer · 2014-04-08 08:13:42Z

1

If that is an array then you have to use .each() method of jQuery:

$.each(data, function(i, resp){
    console.log(resp);
});

answered Apr 8, 2014 at 8:13

Jai

74.8k12 gold badges77 silver badges104 bronze badges

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

3 Comments

Code_Crash Over a year ago

It gives me [object Object] when i alert 'alert(resp);'

Regent Over a year ago

@Code_Crash Try to alert resp.exam_id or other fields from row

Code_Crash Over a year ago

Thanks sir.I try alert(resp['question_id']); and its done! :) Thanks again!

kot-6eremot · Accepted Answer · 2014-04-08 08:15:36Z

0

You will get jquery object with ajax response. So, you can process it with any of these functions: http://api.jquery.com/each/ http://api.jquery.com/jQuery.each/

answered Apr 8, 2014 at 8:15

kot-6eremot

718 bronze badges

Comments

Jaimin MosLake · Accepted Answer · 2014-04-08 08:15:53Z

0

if you have used dataType: json then you can dirctly use

//if it is not a multidimensional array then you can dirctly
 data.keyName 

//if it is multidimensional array 
$(data).each(function(index,element){
        console.log(element);
})

answered Apr 8, 2014 at 8:15

Jaimin MosLake

6751 gold badge13 silver badges31 bronze badges

Collectives™ on Stack Overflow

How to read data from json array in jquery?

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related