安卓PHP Mysql通过params获取数据


Android PHP Mysql get Data by params

我正在制作与PHP MySQL通信的android应用程序有PHP文件

create_order.php
get_all_orders.php
get_order_status.php

create_order.php工作get_all_orders.php但在浏览器中输入get_order_status.php的示例?oid=102它给了我响应,但它包含一个错误{"success":0,"message":"Required field(s) is missing get status"}通过POST方法从android尝试时

RequestQueue queue = MyVolley.getRequestQueue();
        String num1 = "1";
        if (num1 != null && !num1.equals("")) {
            String uri = String
                    .format("http://192.168.0.101/android_connect/get_order_status.php?param1=%1$s",
                            num1);
            StringRequest myReq = new StringRequest(Request.Method.GET,
                    uri,
                    createMyReqSuccessListener(),
                    createMyReqErrorListener());
            queue.add(myReq);
        }

get_order_status.php

/*
 * Following code will get single product details
 * A product is identified by product id (pid)
 */
// array for JSON response
$response = array();
// include db connect class
//require_once __DIR__ . '/db_connect.php';
// connecting to db
//$db = new DB_CONNECT();
// check for post data
//echo("post data - ".$_GET['oid']);
if (isset($_GET['oid'])) {
    $pid = $_GET['oid'];
    // get a order from orders table
 $mysqli = new mysqli('localhost','root','rootpass','testdb');
 $result = mysqli_fetch_array($mysqli->query("SELECT * FROM orders WHERE oid = $pid")); 
     //echo($result["status"]);
    if (count($result)>0) {
        // check for empty result

            $order = array();
            $order ["status"] = $result["status"];
            // success
            $response["success"] = 1;
            // user node
            $response["order"] = array();
            array_push($response["order"], $order);
            // echoing JSON response
            echo json_encode($response);
        } else {
            // no product found
            $response["success"] = 0;
            $response["message"] = "No order found";
            // echo no users JSON
            echo json_encode($response);
        }
} else {
    // required field is missing
    $response["success"] = 0;
   $response["message"] = "Required field(s) is missing get status";
    // echoing JSON response
    echo json_encode($response);
}
?>  

将此行中的param1更改为oid(安卓代码)

String uri = String.format("http://192.168.0.101/android_connect/get_order_status.php?param1=%1$s",num1);

应该是这样的:

String uri = String.format("http://192.168.0.101/android_connect/get_order_status.php?oid=%1$s",num1);

在您的PHP文件中,您正在读取名为oid 的参数

$pid = $_GET['oid'];