Formatting JSON output in PHP MYSQL

Question

I am trying to get the Devbridge Autocomplete jQuery script to work, and I am oh so very close. I can get it to give me suggestions (dropdown values) however I need to use it's data attribute.

The suggested JSON formatting as as follows:

{
    suggestions: [
        { value: "United Arab Emirates", data: "AE" },
        { value: "United Kingdom",       data: "UK" },
        { value: "United States",        data: "US" }
]
}

So far, I have managed this:

{
"suggestions": [
    "Show Name 1",
    "Show Name 2"
],
"data": [
    "1",
    "2"
]
}

The code producing that output is as follows:

$reply = array();
$reply['suggestions'] = array();
$reply['data'] = array();

while ($row = $result->fetch_array(MYSQLI_ASSOC))//loop through the retrieved values
{
    //Add this row to the reply
    $reply['suggestions'][]=$row['SHOW_NAME'];
    $reply['data'][]=$row['SHOW_ID'];
}

//format the array into json data
echo json_encode($reply);

Any suggestions? I can't figure out how to combine the two data elements into one array, let alone prepend them with 'value' or 'data'...

Take a look at this question: stackoverflow.com/questions/6054033/… — carl-lopez
– carl-lopez, Commented Jul 22, 2013 at 1:56

Bob Arezina · Accepted Answer · 2013-07-22 03:02:50Z

1

while($row = $result->fetch_array(MYSQLI_ASSOC))
{

$rec = array();

$rec['value'] = $row['SHOW_NAME'];
$rec['data'] = $row['SHOW_ID'];

$payload['suggestions'][] = $rec;

}

echo json_encode($payload);

edited Jul 22, 2013 at 3:02

answered Jul 22, 2013 at 2:00

Bob Arezina

845 silver badges20 bronze badges

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

1 Comment

DevlshOne Over a year ago

$payload is never initialized and will result in a PHP Warning. Also, the use of JSON_PRETTY_PRINT is recommended when returning the variable back to a Javascript function for improved debugging.

DevlshOne · Accepted Answer · 2013-07-22 01:59:17Z

1

$response = array();
$reply = array();
while ($row = $result->fetch_array(MYSQLI_NUM))//loop through the retrieved values
{
    //Add this row to the reply
    $reply['value'] = $row[0];
    $reply['data'] = $row[1];
    $response['suggestions'][] = $reply;
}
//format the array into json data
echo json_encode($response, JSON_PRETTY_PRINT);

answered Jul 22, 2013 at 1:59

DevlshOne

8,4671 gold badge31 silver badges38 bronze badges

Comments

munzx · Accepted Answer · 2013-07-22 02:00:49Z

0

Not sure if i have got you correctly but if you mean to get both values in one array then use :

$replay[][array('country' => $row['SHOW_NAME'],'data' => $row['SHOW_ID'])];

answered Jul 22, 2013 at 2:00

munzx

3735 silver badges13 bronze badges

Collectives™ on Stack Overflow

Formatting JSON output in PHP MYSQL

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related