Encoding a JSON Array using PHP

Question

I am trying to use PHP to return tName from the database and then output it in the following way: {"tName":["Name1", "Name2"]}) So far it is returning ["Name1", "Name2", "Name3"] but that is not what I want.

Here is my current code

$q = mysql_query("SELECT tName FROM Template");
$result = array();
while($e=mysql_fetch_array($q, MYSQL_ASSOC)){
$result[]=$e['tName'];
}       
echo json_encode($result);

json_encode(array("tName" => $result))?

Marty
– Marty

2014-05-02 02:16:35 +00:00
Commented May 2, 2014 at 2:16 — Marty
– Marty, Commented May 2, 2014 at 2:16

Marty · Accepted Answer · 2014-05-02 02:18:44Z

1

you just need to add the key.

$result['tName'][]=$e['tName'];

or

json_encode(array("tName" => $result))

edited May 2, 2014 at 2:18

Marty

39.5k19 gold badges97 silver badges164 bronze badges

answered May 2, 2014 at 2:17

Yamiko

5,4635 gold badges33 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

Encoding a JSON Array using PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related