Json Encode Multi dimension array format

Question

im retrieving some data in my database table and than convert to json, but i need to create a array with this structire in my php loop

["postcode"=>"townName"...]

but instead is giving me

["postcode=>townName"...]

My code:

$sql = "SELECT * FROM uk_postcodes";
    $result = mysqli_query($connection, $sql) or die("Error " . mysqli_error($connection));

    $dname_list = array();
    while($row = mysqli_fetch_array($result))
    {

        $dname_list[] = $row['postcode']."=>".$row['town'];
    }
    echo json_encode($dname_list);

mishunika · Accepted Answer · 2015-11-30 15:32:43Z

1

In that line:

$dname_list[] = $row['postcode']."=>".$row['town'];

You're creating a string with "=>" in the middle (see string concatenation). You should specify the key of the array to be the postcode field, and the value - town field. Just change that line to:

$dname_list[$row['postcode']] = $row['town'];

http://php.net/manual/en/language.types.array.php

answered Nov 30, 2015 at 15:32

mishunika

1,9161 gold badge16 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Json Encode Multi dimension array format

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