json problem in jquery

Question

I am using the following code :

$(document).ready(function() {
        $.ajax({
            url: "tiles/chartValue.php",
            datatype: 'json',
            type: 'POST',
            success: function(data){                
                $.each(data, function(key, value) { 
                  alert(key + ': ' + value); 
                });
                       });
                });

Here is chartValue.php

<?php
    include("../functions.php");
    $DAO=new DBUtil();
    $DAO->initDB("../db/connection.properties");
    $k=$DAO->getChart();
    echo json_encode($k);
?>

here is the getChart function of functions.php

public function getChart()
{
    $sql = "SELECT a.total, round( (b.active *100) / total ) active_user, round( (c.inactive *100) / total ) inactive_user
        FROM 
        (               
            SELECT IFNULL( count( * ) , 0 ) total FROM ashekan_info
        )a, 
        (               
            SELECT IFNULL( count( * ) , 0 ) active FROM ashekan_info WHERE is_active =1
        )b, 
        (               
            SELECT IFNULL( count( * ) , 0 ) inactive FROM ashekan_info  WHERE is_active =0
        )c";

        $result=mysql_query($sql,$this->connect()) or die(mysql_error());   
        $row = mysql_fetch_assoc($result);  
        $json = array('total'       =>$row['total'],
                  'active_user' =>$row['active_user'],
                  'inactive_user'   =>$row['inactive_user']
                 ); 
        return $json;

}

I get the result in firebug is {"total":"1","active_user":"0","inactive_user":"100"}

problem is it shows each character in alert box. i.e : {, ", t and so on.

how can i get 1, 0, 100 ? thanks in advance.

try alert(typeof(data)); ... is it object ?

Teneff
– Teneff

2011-05-13 14:07:17 +00:00
Commented May 13, 2011 at 14:07 — Teneff
– Teneff, Commented May 13, 2011 at 14:07

Tesserex · Accepted Answer · 2011-05-13 14:05:14Z

7

Just a guess...

You have datatype: 'json', but JS is case sensitive, and the correct parameter is dataType. So it's ignoring that, taking text, and your each call is iterating through characters of a string.

answered May 13, 2011 at 14:05

Tesserex

17.3k6 gold badges72 silver badges108 bronze badges

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

Comments

Timothy Groote · Accepted Answer · 2011-05-13 14:04:40Z

0

Because the answer you get from your AJAX call is still a string. Parse it first with JQuery.ParseJson, then iterate the parsed variable.

answered May 13, 2011 at 14:04

Timothy Groote

8,69229 silver badges53 bronze badges

1 Comment

Timothy Groote Over a year ago

Didn't occur to me, since the content type header isn't visibly set in the snippet either.

Teneff · Accepted Answer · 2011-05-13 14:09:19Z

0

what I think you need is :

header("Content-type: application/json");

right before

echo json_encode($k);

answered May 13, 2011 at 14:09

Teneff

32.3k13 gold badges76 silver badges107 bronze badges

Collectives™ on Stack Overflow

json problem in jquery

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related