从android向php发送数据并检索数据

// 创建一个异步任务来发送HTTP请求
private class SendDataToPhpTask extends AsyncTask<String, Void, String> {
    protected String doInBackground(String... params) {
        String url = "http://your-php-server.com/your-php-script.php";
        String data = params[0]; // 需要发送的数据

        try {
            // 创建URL对象
            URL urlObj = new URL(url);
            // 创建HttpURLConnection对象
            HttpURLConnection conn = (HttpURLConnection) urlObj.openConnection();
            // 设置请求方法为POST
            conn.setRequestMethod("POST");
            // 设置请求参数
            conn.setDoOutput(true);
            OutputStream os = conn.getOutputStream();
            os.write(data.getBytes());
            os.flush();
            os.close();

            // 获取响应结果
            int responseCode = conn.getResponseCode();
            if (responseCode == HttpURLConnection.HTTP_OK) {
                // 读取响应数据
                BufferedReader in = new BufferedReader(new InputStreamReader(conn.getInputStream()));
                String inputLine;
                StringBuilder response = new StringBuilder();
                while ((inputLine = in.readLine()) != null) {
                    response.append(inputLine);
                }
                in.close();
                return response.toString();
            } else {
                return "Error: " + responseCode;
            }
        } catch (Exception e) {
            e.printStackTrace();
            return "Error: " + e.getMessage();
        }
    }

    protected void onPostExecute(String result) {
        // 处理响应结果
        // 可以在这里解析返回的JSON数据或者进行其他操作
    }
}

// 在需要发送数据的地方调用异步任务
String dataToSend = "key1=value1&key2=value2"; // 需要发送的数据
new SendDataToPhpTask().execute(dataToSend);

<?php
// 获取Android发送的数据
$data = $_POST['key1']; // 假设Android发送了一个名为key1的参数

// 连接数据库
$servername = "your-db-server";
$username = "your-username";
$password = "your-password";
$dbname = "your-db-name";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// 执行数据库操作
$sql = "SELECT * FROM your-table WHERE column = '$data'";
$result = $conn->query($sql);

// 处理查询结果
if ($result->num_rows > 0) {
    // 将查询结果转换为JSON格式
    $rows = array();
    while ($row = $result->fetch_assoc()) {
        $rows[] = $row;
    }
    $jsonResponse = json_encode($rows);
    echo $jsonResponse;
} else {
    echo "No results found";
}

$conn->close();
?>