problem in the output of query - php+json

Question

function tableOne() {

        $query = mysql_query("SELECT valor FROM grafico") or die(mysql_error());
        $i = 0;
        while($row = mysql_fetch_assoc($query)) {
            $arr[] = array($row[valor]);
            ++$i;
        }
        echo json_encode($arr);
    }
}

the output will be

[["15573"],["31978"],["11227"],["5752"],["20817"],["32182"]]

i need something like:

["15573","31978","11227","5752","20817","32182","10935"]

i tried some changes in the code but the output is not what i want.

thanks

mellamokb · Accepted Answer · 2011-05-17 03:26:56Z

2

You are placing sub-arrays in each element of your array. You should replace

$arr[] = array($row[valor]);

with

$arr[] = $row[valor];

The [] in $arr[] already adds each entry as an element of the array.

answered May 17, 2011 at 3:26

mellamokb

56.8k12 gold badges111 silver badges138 bronze badges

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

3 Comments

deceze Over a year ago

Also, please quote your array indices ('valor').

user455318 Over a year ago

it is possible an output without quotes [15573,1978, 200]?

mellamokb Over a year ago

Try casting the values to an int: (int)$row[valor];

deceze · Accepted Answer · 2011-05-17 03:28:14Z

1

$query = mysql_query("SELECT valor FROM grafico") or die(mysql_error());

$arr = array();
while ($row = mysql_fetch_assoc($query)) {
    $arr[] = $row['valor'];  // get rid of the array() wrapper
}

echo json_encode($arr);

answered May 17, 2011 at 3:28

deceze♦

525k89 gold badges806 silver badges954 bronze badges

Collectives™ on Stack Overflow

problem in the output of query - php+json

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related