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
Post a Comment