问Php服务以json格式获取数据

EN

select * from sub_menu where item_name="Cafe"

    <?php
    $response = array();

    // include db connect class
    require_once __DIR__ . '/db_connect.php';

   // connecting to db
    $db = new DB_CONNECT();

    // check for post data
   if (isset($_GET["item_name"])) {


// get a product from products table
$result = mysql_query("SELECT * FROM sub_menu WHERE item_name ='".$_GET["item_name"]."'");
echo $result;
if (!empty($result)) {
    // check for empty result

    if (mysql_num_rows($result) > 0) {

        $result = mysql_fetch_array($result);
        $sub_menu = array();
        $sub_menu["id"] = $result["id"];
        $sub_menu["item_name"] = $result["item_name"];
        $sub_menu["sub_item_name"] = $result["sub_item_name"];
        $sub_menu["add_price"] = $result["add_price"];
        $sub_menu["img"] = $result["img"];
        // success
        $response["success"] = 1;

        // user node
        $response["sub_menu"] = array();

        array_push($response["sub_menu"], $sub_menu);

        // echoing JSON response
        echo json_encode($response);
    } else {
        // no product found
        $response["success"] = 0;
        $response["message"] = "No sub menu found";

        // echo no users JSON
        echo json_encode($response);
    }
} else {
    // no product found
    $response["success"] = 0;
    $response["message"] = "No menu found";

    // echo no users JSON
    echo json_encode($response);
}
    } else {
// required field is missing
$response["success"] = 0;
$response["message"] = "Required field(s) is missing";

// echoing JSON response
echo json_encode($response);
    }
    ?>