php - I am trying to get my table from database in JSON, Help me out -


my php code.

<?php //open connection mysql db $connection = mysqli_connect("host_name","user_name","my_password","database_name") or die("error " . mysqli_error($connection));  //fetch table rows mysql db $sql = "select * mytable"; $result = mysqli_query($connection, $sql) or die("error in selecting " . mysqli_error($connection));  //create array $emparray[] = array(); while($row =mysqli_fetch_assoc($result)) {     $emparray[] = $row; } echo json_encode($emparray);  //close db connection mysqli_close($connection); ?> 

it gives output as:`

[[],{"id":"1","name":"vikash","rollno":"39"},{"id":"2","name":"tausif","rollno":"35"},{"id":"3","name":"sharma","rollno":"30"}] 

there array coming in output, not suppose there. can't find reason.

replace following line:

$emparray[] = array();

with this:

$emparray = array();


Comments