CODEWITHSUNDEEP
phpjson
hadenp
hadenp

Reputation: 445

JSON Data is Enclosed in Brackets Why?

my JSON data comes back enclosed in brackets for example: [{"cust_id":"109"}]. Why is that? I've tried mysql_fetch_row and mysql_fetch_object. Do I need to substring to remove the brackets?

Also, how can I display a JSON object in javaScript? In Firebug, if I hard-code the JSON data, I see a value as JSON, but alert() won't show it.

Thank you.

 $rows = array();
  while($r = mysql_fetch_assoc($rs)) {
    $rows[] = $r;
  }
  echo json_encode($rows);

Upvotes: 5

Views: 8911

Answers (3)

bensiu
bensiu

Reputation: 25604

Because it is JSON format syntax. More about it on: http://www.json.org/

Upvotes: 3

Daff
Daff

Reputation: 44215

The brackets indicate an array in JavaScript. If you only want one item you have to encode the first (and single) entry of your array specifically:

$rows = array();
while($r = mysql_fetch_assoc($rs)) 
{
    $rows[] = $r;
}
echo json_encode($rows[0]);

Upvotes: 4

kohlehydrat
kohlehydrat

Reputation: 505

That means an array consisting of excactly one element.

Upvotes: 5

Related Questions