如何使用Volley向Mysql数据库插入数据

dependencies {
    implementation 'com.android.volley:volley:1.2.1'
}

RequestQueue requestQueue = Volley.newRequestQueue(context);

String url = "http://your-server-url.com/insert_data.php";
StringRequest stringRequest = new StringRequest(Request.Method.POST, url,
        new Response.Listener<String>() {
            @Override
            public void onResponse(String response) {
                // 请求成功的回调处理
            }
        },
        new Response.ErrorListener() {
            @Override
            public void onErrorResponse(VolleyError error) {
                // 请求失败的回调处理
            }
        }) {
    @Override
    protected Map<String, String> getParams() {
        Map<String, String> params = new HashMap<>();
        params.put("param1", "value1");
        params.put("param2", "value2");
        // 添加更多参数
        return params;
    }
};

requestQueue.add(stringRequest);

<?php
$servername = "your-server-name";
$username = "your-username";
$password = "your-password";
$dbname = "your-database-name";

// 创建数据库连接
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 解析POST请求参数
$param1 = $_POST["param1"];
$param2 = $_POST["param2"];
// 解析更多参数

// 执行插入数据的SQL语句
$sql = "INSERT INTO your_table_name (column1, column2) VALUES ('$param1', '$param2')";
if ($conn->query($sql) === TRUE) {
    echo "数据插入成功";
} else {
    echo "数据插入失败: " . $conn->error;
}

// 关闭数据库连接
$conn->close();
?>