weixin_33726313 2020-04-21 10:17 采纳率: 0%
浏览 17

无法更新表格(PHP,AJAX)[关闭]

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.
                </div>
            </div>
        </div>
                <hr class="my12 outline-none baw0 bb bc-powder-2">
            <div class="grid fw-nowrap fc-black-600">
                    <div class="grid--cell mr8">
                        <svg aria-hidden="true" class="svg-icon iconLightbulb" width="18" height="18" viewbox="0 0 18 18"><path d="M9.5.5a.5.5 0 0 0-1 0v.25a.5.5 0 0 0 1 0V.5zm5.6 2.1a.5.5 0 0 0-.7-.7l-.25.25a.5.5 0 0 0 .7.7l.25-.25zM1 7.5c0-.28.22-.5.5-.5H2a.5.5 0 0 1 0 1h-.5a.5.5 0 0 1-.5-.5zm14.5 0c0-.28.22-.5.5-.5h.5a.5.5 0 0 1 0 1H16a.5.5 0 0 1-.5-.5zM2.9 1.9c.2-.2.5-.2.7 0l.25.25a.5.5 0 1 1-.7.7L2.9 2.6a.5.5 0 0 1 0-.7z" fill-opacity=".4"></path><path opacity=".4" d="M7 16h4v1a1 1 0 0 1-1 1H8a1 1 0 0 1-1-1v-1z" fill="#3F3F3F"></path><path d="M15 8a6 6 0 0 1-3.5 5.46V14a1 1 0 0 1-1 1h-3a1 1 0 0 1-1-1v-.54A6 6 0 1 1 15 8zm-4.15-3.85a.5.5 0 0 0-.7.7l2 2a.5.5 0 0 0 .7-.7l-2-2z" fill="#FFC166"></path></svg>
                    </div>
                <div class="grid--cell lh-md">
                    <p class="mb0">
                        <b>Want to improve this question?</b> <a href="/posts/61341127/edit">Update the question</a> so it's <a href="/help/on-topic">on-topic</a> for Stack Overflow.
                    </p>
                    <p class="mb0 mt6">Closed <span title="2020-04-21 23:55:31Z" class="relativetime">5 days ago</span>.</p>
                </div>
            </div>
    </aside>

I have tried almost all options, but every time after I change value of table and then click anywhere, I get this warning:
Notice: Undefined index: id in C:\xampp\htdocs\edit.php on line 3

Function code:

function edit_data(id, text, column_name)  
    {  
        $.ajax({  
            url:"edit.php",  
            method:"POST",  
            data:{ID:id, text:text, column_name:column_name},  
            dataType:"text",  
            success:function(data){  
                alert(data);
                $('#result').html("<div class='alert alert-success'>"+data+"</div>");
            }  
        });  
    }  
    $(document).on('blur', '.Ime', function(){  
        var id = $(this).data("id1");  
        var Ime = $(this).text();  
        edit_data(id, Ime, "Ime");  
    });  
    $(document).on('blur', '.Prezime', function(){  
        var id = $(this).data("id2");  
        var Prezime = $(this).text();  
        edit_data(id,Prezime, "Prezime");  
    });
    $(document).on('blur', '.Email', function(){  
        var id = $(this).data("id3");  
        var Email = $(this).text();  
        edit_data(id,Email, "Email");  
    });
    $(document).on('blur', '.Adresa', function(){  
        var id = $(this).data("id4");  
        var Adresa = $(this).text();  
        edit_data(id,Adresa, "Adresa");  
    });
    $(document).on('blur', '.BrojKuce', function(){  
        var id = $(this).data("id5");  
        var BrojKuce = $(this).text();  
        edit_data(id,BrojKuce, "BrojKuce");  
    });
    $(document).on('blur', '.PostanskiBroj', function(){  
        var id = $(this).data("id6");  
        var PostanskiBroj = $(this).text();  
        edit_data(id,PostanskiBroj, "PostanskiBroj");  
    });

edit.php code:

<?php  
$connect = mysqli_connect("localhost", "root", "", "testbaza");
$id = $_POST['id'];  
$text = $_POST['text'];  
$column_name = $_POST['column_name'];
$sql = "UPDATE korisnicibrojeva SET '$column_name' = '$text'  WHERE ID= '$id'" ;  
if(mysqli_query($connect, $sql))  
{  
    echo 'Data Updated';  
} ?> 
</div>
  • 写回答

1条回答 默认 最新

  • weixin_33726943 2020-04-21 10:25
    关注

    POST variables are case sensitive. "ID" is different from "id".

    评论

报告相同问题?

悬赏问题

  • ¥15 对于相关问题的求解与代码
  • ¥15 ubuntu子系统密码忘记
  • ¥15 信号傅里叶变换在matlab上遇到的小问题请求帮助
  • ¥15 保护模式-系统加载-段寄存器
  • ¥15 电脑桌面设定一个区域禁止鼠标操作
  • ¥15 求NPF226060磁芯的详细资料
  • ¥15 使用R语言marginaleffects包进行边际效应图绘制
  • ¥20 usb设备兼容性问题
  • ¥15 错误(10048): “调用exui内部功能”库命令的参数“参数4”不能接受空数据。怎么解决啊
  • ¥15 安装svn网络有问题怎么办