假设您使用php作为服务器语言。首先，我们将创建ajax函数来调用php脚本。您将创建一个文件，用于在数据库中插入值。我将把它命名为addcolor.php

function mark_complete(i){
         if(confirm('Are you sure you want to proceed with this action?')){
            $('tr').click(function () {
                if(this.style.background == "" || this.style.background =="white") {
                    $(this).css('background', 'yellow');
                    $.ajax({     
                        type: "POST",
                        url: 'addColor.php',
                        data: {color:'yellow'},
                        success: function (data) {
                            console.log(data);   
                        },
                    });
                }
                else {
                    $(this).css('background', 'white');
                    $.ajax({     
                        type: "POST",
                        url: 'addColor.php',
                        data: {color:'white'},
                        success: function (data) {
                            console.log(data);   
                        },
                    });
                }
            });
         }
}

添加颜色.php

if(isset($_POST['color'])){
    $color = $_POST['color'];
    $con = new mysqli($db_hostname, $db_username, $db_password, $db_databasename);
    $stmt = $con->prepare("UPDATE `color_tbl` SET `color` = ?");
    $stmt->bind_param("s", $color);
    $stmt->execute();
    $stmt->close();
}

希望这对你有所帮助，给你一些想法