从数据库中添加或减去 onclick - add or subtract onclick from database

add or subtract onclick from database

本文关键字：onclick 添加数据库 | 更新日期: 2023-11-18

我想在数据库中加减onClick()加或减Button一。

我的代码

$.ajax({
        type:'POST',
        dataType: 'json',
        url:'storage.php',
        data:{search: $("#s_inven").val()},
        success:function(rows){
            for (var i = 0, len = rows.length; i < len; i++) {
                $('#inven').append('<tr><td>'+ rows[i].G_Name +'</td><td>'+
                        '<button data-icon="plus" data-iconpos="notext" id="'+ 
                        rows[i].Id + 'plus" value="'+ rows[i].Id + '">+</button>' +
                        '</td><td>'+ '<label id="">'+ rows[i].quant +'</label></td><td>'+ 
                        '<button data-icon="minus" data-iconpos="notext" id="'+
                        rows[i].G_Name +'minus" value="'+ rows[i].G_Name +
                        '">-</button>' +'</td></tr>'        
            }
    );

当用户单击">添加Button我想更新 rows[i].quant到rows[i].quant+1 .

像这样：

$.ajax({
    type:'POST',
    dataType: 'json',
    url:'storage.php',
    data:{search: $("#s_inven").val()},
    success:function(rows){
        for (var i = 0, len = rows.length; i < len; i++) {
            $('#inven').append('<tr><td>'+ rows[i].G_Name +'</td><td>'+
                    '<button data-icon="plus" data-iconpos="notext" id="'+ 
                    rows[i].Id + 'plus" value="' + rows[i].Id + '" onclick="addVal(' + rows[i].Id + ')">+</button>' +
                    '</td><td>'+ '<label id="quant' + rows[i].Id + '">'+ rows[i].quant +'</label></td><td>'+ 
                    '<button data-icon="minus" data-iconpos="notext" id="'+
                    rows[i].G_Name +'minus" value="'+ rows[i].G_Name +
                    '">-</button>' +'</td></tr>'        
        }
);
function addVal(id)
{
    var labelId = 'quant' + id;
    var label = document.getElementById(labelId);
    if (label)
    {
        var oldVal = label.innerHTML;
        var newVal = parseInt(oldVal) + 1;
        label.innerHTML = newVal;
        // + ajax call to update the db
    }
}