Getting the word 'Array' inserted when passing an array in php using JSON

Question

I have created a webpage which includes the following php code...

$brandArray = JSON_decode(DatabaseInterface::getBrands(), true);
sort($brandArray);
for ($loop=0; $loop < sizeof($brandArray); $loop++) {
    echo "<option>$brandArray[$loop]</option>";
}

the relevant bits of the function DatabaseInterface::getBrands are here...

$query = "SELECT psBrandName from brands";
$result = mysqli_query($con, $query) or die ("Couldn't execute query. ".mysqli_error($con));

$resultArray[] = array();

while ($row = mysqli_fetch_assoc($result)) {

    extract($row);
    $resultArray[] = $psBrandName;

}

return json_Encode($resultArray);

Everything is working fine, except, bizarrely, when I look at the outputs on the webpage, the first item in the list is the word 'Array' (which isnt in the database. Any ideas?

because I call the same fucntion with javascript in other places so needed the output to be a universal format — Ben Thompson
– Ben Thompson, Commented Jun 29, 2013 at 17:43

Niet the Dark Absol · Accepted Answer · 2013-06-29 16:56:41Z

3

$resultArray[] = array() means to push an empty array onto the $resultArray array. Remove the square brackets.

answered Jun 29, 2013 at 16:56

Niet the Dark Absol

326k86 gold badges480 silver badges604 bronze badges

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

Collectives™ on Stack Overflow

Getting the word 'Array' inserted when passing an array in php using JSON

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