时间戳

首页 > 解决方案 > 查询从数据库中删除记录，但表行不淡出那一个

php - 查询从数据库中删除记录，但表行不淡出那一个

问题描述

控制器如下：

        public function deleteCategory()
         {
        if(adminLoggedIn())
        {
        if($this->input->is_ajax_request())
        {
            $data['cId'] = $this->input->post('id',true);
            $cId = $this->input->post('text',true);
            if(!empty($cId) && isset($cId))
            {
                $catId=$this->encryption->decrypt($cId);

                $old_Img = $this->AdminLogin->getCategoryImage($catId);
                if(!empty($old_Img) && count($old_Img) == 1)
                {
                    $reaImage = $old_Img[0]['cDp'];
                }
                $delCatId = $this->AdminLogin->categoryDelete($catId);
                if($delCatId)
                {

                    if(!empty($reaImage) && isset($reaImage))
                    {
                        if(file_exists('./upload/admin/category/'.$reaImage))
                        {
                            @unlink('./upload/admin/category/'.$reaImage);
                        }
                    }
                    $data['return'] = "true";
                    $data['message'] = "Successfully Deleted";
                    echo json_encode($data);
                    // set_flashdata('alert-danger','You have successfully deleted Category','admin/allcategories');

                }
                else
                {
                    $data['return'] = "true";
                    $data['message'] = "Not Successfully Deleted";
                    echo json_encode($data);
                    // set_flashdata('alert-danger','You cant allowed delete this category','admin/allcategories');

                }
            }
            else
            {
                set_flashdata('alert-danger','You cant allowed delete this category','admin/allcategories');
            }
        }
        else
        {
            set_flashdata('alert-danger','Something Went wrong . Please try again later','admin/allcategories');
        }
        

    }
    else
    {
        set_flashdata('alert-danger','Please login first and then try again later','admin/login');

    }

}

jquery如下：

  $(document).ready(function(){
       $('.delcat').click(function(){
          var id = $(this).data('id');
          var text = $(this).data('text');
          $.ajax({
              type: 'POST',
              url: burl+'admin/deleteCategory',
              data: {id:id,text:text},
              dataType: 'JSON',
              success: function(data) {
                // console.log(data);
                 var deleteData = $.parseJSON(data);;
                 // console.log(deleteData);
                 if($deleteData.return == "true")
                 {
                    console.log("hii");
                    $('.error').text(deleteData.message);
                    $('.cat'+id).fadeOut();
                 }
                 else if($deleteData.return == "false")
                 {
                    console.log("hii1");
                    $('.error').text(deleteData.message);
                 }
                 else
                 {
                    console.log("hii2");
                    $('.error').text("Something Went wrong");
                 }
              },

              error: function($data) {
                 $('.error').text("Something Went wrong");
              },
             
           });

}); });

html如下

  <tr class="cat<?php echo $value->cId; ?>">
                    <td><?php echo $key+1;?></td>
                    <td><?php echo $value->cName;?></td>
                    <td><?php echo $value->cDate;?></td>
                    <td><a href="<?php echo base_url('admin/editCategory/'.$value->cId)?>" class="btn btn-info">Edit</a></td>
                    <td><a href="javascript:void(0)" class="btn btn-danger delcat" data-id="<?php echo $value->cId;?>" data-text="<?php echo $this->encryption->encrypt($value->cId);?>">Delete</a></td>
                  </tr>

              <?php  

                }  
              }    

            ?>
              </tbody>
              </table>
            <p><?php echo $links; ?></p>
         </div>

我能尽快得到这个解决方案吗？我被这件事困住了。我在 Codeigniter 框架中使用此代码，以下代码从数据库中删除记录，但表行未删除或淡出...请检查代码，并告诉我如何修复此代码。

标签： phpjquerycodeigniter-3

解决方案

尝试这个：-

$(document).ready(function(){
       $('.delcat').click(function(){
          var id = $(this).data('id');
          var text = $(this).data('text');
         var $ele = $(this).parent().parent();    //add this line.

          $.ajax({
              type: 'POST',
              url: burl+'admin/deleteCategory',
              data: {id:id,text:text},
              dataType: 'JSON',
              success: function(data) {
                // console.log(data);
                 var deleteData = $.parseJSON(data);;
                 // console.log(deleteData);
                 if($deleteData.return == "true")
                 {
                    console.log("hii");
                    $('.error').text(deleteData.message);
                  $ele.fadeOut().remove();           //add this line.
                 }
                 }
                 })
                 }
                 });

推荐阅读