JSON Retrieve Data NEW

<?php

    //view list of persons in db

    $user = 'username';
    $password = 'password';
    $db = 'dbname';
    $host = 'localhost';


    //open connection to mysql db
    $connection = mysqli_connect($host,$user,$password,$db) or die("Error " . mysqli_error($connection));

    //fetch table rows from mysql db

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

    //create an array
    $emparray = array();
    while($row =mysqli_fetch_assoc($result))
    {
        $emparray['person'][] = $row;
    }
    echo json_encode($emparray);

    //close the db connection
    mysqli_close($connection);

?>