select控件 mysql

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>SELECT 控件示例</title>
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
</head>
<body>
    <select id="mySelect">
        <!-- 数据将通过 JavaScript 动态加载 -->
    </select>

    <script>
        $(document).ready(function() {
            $.ajax({
                url: '/api/getData', // 假设这是后端 API 地址
                method: 'GET',
                success: function(data) {
                    var options = '';
                    $.each(data, function(index, item) {
                        options += '<option value="' + item.id + '">' + item.name + '</option>';
                    });
                    $('#mySelect').html(options);
                },
                error: function(xhr, status, error) {
                    console.error('Error:', error);
                }
            });
        });
    </script>
</body>
</html>