dream890110 2017-06-20 18:45
浏览 40

从MySQL获取数组

I am querying MySQL to perform an operation and return an array. To do this I am using the following code:

$return_array = array(
        "title" => "nearby media",
        "nearby_media_list" => array()
    );

$my_query = "select * from `Media`";
$result = $conn->query($my_query);

while($row = $result->fetch_assoc()) {
    $mediaLat = $row["lat"];
    $mediaLon = $row["lon"];

    $calculated_distance = distance( $userLat, $userLon, $mediaLat, $mediaLon, "M");

    if( $calculated_distance <= $distance_limit ) {
        // Build array
        $return_array["nearby_media_list"][] = array(
                                               'uid' => $row['uid']   
                                            );
    }
}

echo json_encode($return_array);

$conn->close();
?>

and my output looks like this:

{"title":"nearby media","nearby_media_list":[{"uid":"-Kn1f0jo_36qnQBCqjCq"}]}

Since the array only contains one type of data I don't need to store a key and don't need JSON. What I want is a simple array of the values separated by a token so I can take it apart more easily. desired outcome is something like

[value1@#$%value2@#$%]

Can anyone instruct me how to do this? I haven't had any luck

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 关于#Java#的问题,如何解决?
    • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算
    • ¥15 想问一下树莓派接上显示屏后出现如图所示画面,是什么问题导致的
    • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
    • ¥15 cmd cl 0x000007b
    • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line
    • ¥500 火焰左右视图、视差(基于双目相机)
    • ¥100 set_link_state
    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化