dongzhong1929 2014-12-30 13:56
浏览 46
已采纳

如何使用phonegap中的json从php获取数据

How to fetch the data from the php using json in phonegap, On server xampp, I just write the following code replay.php. I have taken these example from this line and and I want to mention this question from stackover flow, try to make according to it but my android emulator is not resounding, please help me on this topic, I am new in phonegap and android,

replay.php

<?php
header('Content-Type: application/json');
$choice =$_POST["button"];
$cars = array("Honde", "BMW" , "Ferrari");
$bikes = array("Ducaite", "Royal Enfield", "Harley Davidson");
if($choice == "cars") print json_encode($cars);
    else 
print json_encode($bikes);
?>

In eclipse I write the following code in index.html

<!DOCTYPE html>
<html>
<head>
    <script charset="utf&minus;8" type="text/javascript">
    function connect(e)
    {
        var term= {button:e};
        $.ajax({
        url:'http://localhost/Experiements/webservices/reply.php',
        type:'POST',
        data:term,
        dataType:'json',
        error:function(jqXHR,text_status,strError){
        alert("no connection");},
        timeout:60000,
        success:function(data){
            $("#result").html("");
                for(var i in data){
                    $("#result").append("<li>"+data[i]+"</li>");
                }
            }
        });
    }
    </script>
</head>
<body>
    <center><b>Bikes or Cars</b></center>
    <center><input onclick="connect(this.value)" type="button" value="cars" /></center>
    <center><input onclick="connect(this.value)" type="button" value="bikes" /></center>
    <center><b>Results</b></center>
    <ul id="result"></ul>
</body>
</html>
  • 写回答

1条回答 默认 最新

  • duancheng3342 2014-12-30 21:20
    关注

    Correct me if I am wrong but you are just asking HOW to perform this process, correct? Your question sounds like that code is from a "tutorial" and not your application? Below is how I have performed this function in one of my own private apps using PhoneGap.

    My AJAX call looks like this, minus custom data manipulations:

    $.ajax({
    url: "http://www.mywebsite.com/myscript.php",    // path to remote script
    dataType: "JSON",                                // data set to retrieve JSON
    success: function (data) {                       // on success, do something...
        // grabbing my JSON data and saving it
        // to localStorage for future use.
        localStorage.setItem('myData', JSON.stringify(data));
    }
});

    My PHP script functions like so:

    // PHP headers (at the top)
header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json");

// connect to your database and perform your query    

// then build your output...
while($row = mysqli_fetch_array($result)) {
    $output[] = array (
        "id" => $row['id'],
        "firstname" => $row['firstname'],
        "lastname" => $row['lastname']
    );
}

echo json_encode($output);

    This process above will give you a saved localStorage file of the data from the PHP Script (your database). You can then use the localStorage to output your data without having to continually perform AJAX requests.

    For example:

    var myData = JSON.parse(localStorage.getItem('myData'));
var i;

for (i = 0; i < myData.length; i = i + 1) {
   console.log(myData[i].firstname);      // this should output the firstnames.
}
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题？