PHP: json_encode format

Question

I have a table with a list of businesses. Each row has details such as the business name, ID, area,number just to mention a few.

I am querying the mysql database and currently i'm only retrieving the business name and ID. I am then using the json_encode function to get an output like: {"BusinessA":"business_A_ID","BusinessB":"business_B_ID"}

I would like to be able to retrieve all of the business details and use the json encode function to get an output like:

[
    {
        "businessName": "BusinessA",
        "businessID": "business_A_ID"
    },
    {
        "businessName": "BusinessB",
        "businessID": "businees_B_ID"
    }
]

Here is the current code i'm using:

$businessRow = array();
        $businessResult = mysql_query("SELECT * FROM businessTable");
        while($row = mysql_fetch_assoc($businessResult)) {
            $businessRow[$row['businessName']] = $row['businessID'];
            }
            $result = json_encode($businessRow);
            echo $result;

So my question is what do I need to change this line to :

$businessRow[$row['businessName']] = $row['businessID'];

in order to get the above JSON output?

Thanks

What is the problem what doesn't work?

Pekka
– Pekka

2011-11-05 11:58:33 +00:00
Commented Nov 5, 2011 at 11:58 — Pekka
– Pekka, Commented Nov 5, 2011 at 11:58
Have you tried json_encode($businessResult);

John
– John

2011-11-05 12:04:38 +00:00
Commented Nov 5, 2011 at 12:04 — John
– John, Commented Nov 5, 2011 at 12:04

Alessandro Desantis · Accepted Answer · 2011-11-05 12:05:09Z

5

Change your script like this:

$businessRow[] = array(
    'businessName' => $row['businessName'],
    'businessID'   => $row['businessID']
);

answered Nov 5, 2011 at 12:05

Alessandro Desantis

14.4k1 gold badge29 silver badges33 bronze badges

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

Comments

Felix Kling · Accepted Answer · 2011-11-05 12:07:06Z

1

It seems you want:

$rows = array();

$result = mysql_query("SELECT businessName, businessID FROM businessTable");
while($row = mysql_fetch_assoc($result)) {
   $rows[] = $row;
}

echo json_encode($rows);

$row will already be of the form array('businessName' => '...', 'businessID' => '...'), so all you have to do is to add it to your final array and encode it.

answered Nov 5, 2011 at 12:07

Felix Kling

820k181 gold badges1.1k silver badges1.2k bronze badges

Collectives™ on Stack Overflow

PHP: json_encode format

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related