weixin_33692284 2016-03-19 19:25 采纳率: 0%
浏览 2

在ajax中编辑后发出警报

I am implementing a simple insert and edit using ajax however on the edit it is not displaying the alert and while insertion it is telling undefined index despite my field names are as in my database

edit.php

<?php
    $connect=mysqli_connect("localhost","root","") or die('Could not connect: '.mysqli_error()); mysqli_select_db($connect,'elearning') or die ('database not found: '.mysqli_error()); 
    $id = $_POST["pageID"]; 
    $text = $_POST["text"]; 
    $column_name = $_POST["column_name"];
    $sql = "UPDATE page SET ".$column_name."='".$text."' WHERE pageID='".$id."'"; 
    if(mysqli_query($connect, $sql)) { echo 'Data Updated'; } 
?>

page.php

<script>
  $(document).ready(function() {
    function fetch_data() {
      $.ajax({
        url: "select.php",
        method: "POST",
        success: function(data) {
          $('#live_data').html(data);
        }
      });
    }
    fetch_data();
    $(document).on('click', '#btn_add', function() {
      var cid = $('#cid').text();
      var name = $('#name').text();
      var icon = $('#icon').text();
      var src = $('#src').text();
      var hint = $('#hint').text();
      var category = $('#category').text();

      $.ajax({
        url: "insert.php",
        method: "POST",
        data: {
          cid: cid,
          name: name,
          icon: icon,
          src: src,
          hint: hint,
          category: category
        },
        dataType: "text",
        success: function(data) {
          alert(data);
          fetch_data();
        }
      })
    });

    function edit_data(id, text, column_name) {
      $.ajax({
        url: "edit.php",
        method: "POST",
        data: {
          pageID: id,
          text: text,
          column_name: column_name
        },
        dataType: "text",
        success: function(data) {
          alert(data);
        }
      });
    }

    $(document).on('click', '.btn_delete', function() {
      var id = $(this).data("id7");
      if (confirm("Are you sure you want to delete this?")) {
        $.ajax({
          url: "delete.php",
          method: "POST",
          data: {
            pageID: id
          },
          dataType: "text",
          success: function(data) {
            alert(data);
            fetch_data();
          }
        });
      }
    });
  });
</script>

</div>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 metadata提取的PDF元数据,如何转换为一个Excel
    • ¥15 关于arduino编程toCharArray()函数的使用
    • ¥100 vc++混合CEF采用CLR方式编译报错
    • ¥15 coze 的插件输入飞书多维表格 app_token 后一直显示错误,如何解决?
    • ¥15 vite+vue3+plyr播放本地public文件夹下视频无法加载
    • ¥15 c#逐行读取txt文本,但是每一行里面数据之间空格数量不同
    • ¥50 如何openEuler 22.03上安装配置drbd
    • ¥20 ING91680C BLE5.3 芯片怎么实现串口收发数据
    • ¥15 无线连接树莓派,无法执行update,如何解决?(相关搜索:软件下载)
    • ¥15 Windows11, backspace, enter, space键失灵