如何使用Volley Android Studio在MySQL中插入数组

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

RequestQueue requestQueue = Volley.newRequestQueue(getApplicationContext());

String url = "http://your_server_url/insert_array.php";
StringRequest request = 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<>();
        // 将数组数据作为参数传递给服务器
        String[] array = {"value1", "value2", "value3"};
        for (int i = 0; i < array.length; i++) {
            params.put("array[" + i + "]", array[i]);
        }
        return params;
    }
};

requestQueue.add(request);

<?php
// 连接到MySQL数据库
$servername = "your_servername";
$username = "your_username";
$password = "your_password";
$dbname = "your_dbname";
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 获取POST请求中的数组数据
$array = $_POST['array'];

// 将数组数据插入到MySQL数据库中
$sql = "INSERT INTO your_table (column_name) VALUES ('" . implode("'),('", $array) . "')";
if ($conn->query($sql) === TRUE) {
    echo "数据插入成功";
} else {
    echo "数据插入失败: " . $conn->error;
}

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