javascript - 在我的 js 中发帖是行不通的

Question

JS : Fixed by godot!

/* Data Delete Starts Here */
$(".delete-file").click(function()
{
  var name = $(this).attr("name");
  var file_id = $(this).attr("id");
  var active_user = document.getElementById("username").value;
  if(confirm('Sure to Delete ' +name+ '?'))
  {
    $.ajax({
        url: 'suf-delete.php',
        type: 'post',
        async: false,
        data: {'file_id':file_id ,'active_user':active_user},
        success: function(response){
           $("#file_table"+file_id).fadeOut('slow');
        },
        error: function(error){
              console.log(error.responseText);
         //you could debug your php code if some error raises
         }

    });
  }
  return false;
});
/* Data Delete Ends Here */

PHP: Working Fine (suf-delete.php)

elseif($_POST['file_id'] && $_POST['active_user'])
{
	$file_id = $_POST['file_id'];
	$active_user = $_POST['active_user'];
	$crud->filesDelete($file_id,$active_user);
}

我现在遇到了类问题。

我认为这只是我的查询。我正在尝试使用下面提供的代码制作事件日志、删除、选择和取消链接项目。

请检查:

Class Crud

    public function filesDelete($file_id,$active_user)
    {
      $stmtFiles = $this->conn->prepare('SELECT * FROM tbl_files WHERE file_id=:file_id');
      $stmtFiles->execute(array(":file_id"=>$file_id));
      $unFile=$stmtFiles->fetch(PDO::FETCH_ASSOC);

      $userStmt = $this->conn->prepare('SELECT * FROM tbl_login WHERE username=:username');
      $userStmt->execute(array(":username"=>$active_user));
      $fetch = $userStmt->fetch(PDO::FETCH_ASSOC);

      $activity = "Deleted the file ".$unFile['file_name'];
      if($fetch['access_type']=="Design2K18ADMIN") {
        $type = "Administrator";
      }
      elseif ($fetch['access_type']=="Design2K18MANAGER") {
        $type = "Manager";
      }
      elseif ($fetch['access_type']=="Design2K18MODERATOR") {
        $type = "Moderator";
      }
      elseif ($fetch['access_type']=="Design2K18SIMPLE") {
        $type = "Simple";
      }

      $actLog = $this->conn->prepare("INSERT INTO activity_log(username, activity, type) VALUES(:username, :activity, :type)");
      $actLog->execute(array(":username"=>$active_user, ":activity"=>$activity, ":type"=>$type));

      $stmtSelFol = $this->conn->prepare('SELECT * FROM tbl_section WHERE sec_id=:sec_id');
      $stmtSelFol->execute(array(":sec_id"=>$unFile['sec_id']));
      $unFol=$stmtSelFol->fetch(PDO::FETCH_ASSOC);

      unlink("../Files/".$unFol['sec_folder']."/".$unFile['file_name']);

      $stmtDelFile = $this->conn->prepare('DELETE FROM tbl_files WHERE file_id=:file_id');
      $stmtDelFile->execute(array(":file_id"=>$file_id));

      return true;
    }

我已通过将日志保存在 error.php 中确认我的 js 和 php 工作正常

我将 file_id 和 active_user 的值保存在我的 error.txt 文件中。

9Daren出现，是Item的value(id)，当前session用户是Daren。

请帮我检查一下我的公共(public)函数为什么它什么都不做。

Answer 1

我会使用ajax:

/* Data Delete Starts Here */
$(".delete-file").click(function()
{
  var name = $(this).attr("name");
  var file_id = $(this).attr("id");
  var active_user = document.getElementById("username").value;
  if(confirm('Sure to Delete ' +name+ '?'))
  {

    $.ajax({
        url: 'suf-delete.php',
        type: 'post',
        async: false,
        data: {'file_id':file_id ,'active_user':active_user},
        success: function(response){
           $("#file_table"+file_id).fadeOut('slow');
        },
        error: function(error){
              console.log(error.responseText);
         //you could debug your php code if some error raises
         }

    });
  }
  return false;
});
/* Data Delete Ends Here */