title: Android PHP Mysql get Data by params
body: <p>I'm making android app with communication to PHP MySQL
  there is PHP files</p>
  
  <pre><code>create_order.php
  get_all_orders.php
  get_order_status.php
  </code></pre>
  
  <p>create_order.php works
  get_all_orders.php also
  but example in browser I'm typing get_order_status.php?oid=102 it gives me response but it contains an error 
  <code>{"success":0,"message":"Required field(s) is missing get status"}</code> when  trying it from android by POST method</p>
  
  <pre><code>RequestQueue queue = MyVolley.getRequestQueue();
  
          String num1 = "1";
  
          if (num1 != null &amp;&amp; !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);
          }
  </code></pre>
  
  <p>get_order_status.php
      
  
  <pre><code>/*
   * 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-&gt;query("SELECT * FROM orders WHERE oid = $pid")); 
       //echo($result["status"]);
      if (count($result)&gt;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);
  }
  ?&gt;  
  </code></pre>