Json output shows empty array

Question

I am using php to retrieve data from localhost wampserver. The script is below:

$sql = "select * from topic";
$result = mysqli_query($connection, $sql) or die("Error in Selecting " . mysqli_error($connection));

$topicarray[] = array();
while($row =mysqli_fetch_assoc($result))
{
    $topicarray['topic'][] = $row;
}

print(json_encode($topicarray));

?>

the json output contains all the data but also includes one extra element in starting.I am not able to figure out what is that and how to remove that. the o/p is shown below:

{"0":[],"topic":[{"Topic_id":"1","Subject":"Computer Science","Details":"Consist of various subjects","Parent_id":null},{"Topic_id":"2","Subject":"Electronics","Details":"Subjects related to electronics","Parent_id":null},{"Topic_id":"3","Subject":"databases","Details":"Will talk about sql","Parent_id":"1"},{"Topic_id":"4","Subject":"languages","Details":"c and java","Parent_id":"1"}]}

"0":[]--From where does this comes from?

$topicarray[] = array(); try removing [] after $topicarray — aldrin27
– aldrin27, Commented Sep 7, 2015 at 8:00

Sougata Bose · Accepted Answer · 2015-09-07 08:00:09Z

2

You are defining an empty array in array. Try with -

$topicarray = array();

answered Sep 7, 2015 at 8:00

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

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

Collectives™ on Stack Overflow

Json output shows empty array

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