Подтверждение Sweetalert не работает

Здравствуйте, так что в основном моя проблема заключается в том, что когда я нажимаю на кнопку удаления, подсвечиватель всплывает отлично, но после того, как я нажимаю на кнопку подтверждения "Да, удалить его", ничего не выполняется. Ниже приведен мой файл index.php & delete.php.

**index.php**



     <?php include("dbConfig.php");
    error_reporting(0);
     ?>
    <?php 
    session_start();
    $companyname=$_SESSION['companyName'];
    $tablename=$_SESSION['tableName'];
    $ids = $_SESSION["user_id"];
    $name=$_GET['name'];
    $id = $_GET["id"];


       if($_SESSION["user_id"]=="")
     {
      header("Location:index.php");
     }
     ?>


     <link href="css/lib/sweetalert/sweetalert.css" rel="stylesheet">
    <link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.0.0/css/bootstrap.css" rel="stylesheet">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>


    <?php include("links.php");?>



    <?php include("header.php");?>

            <!-- End header header -->
            <!-- Left Sidebar  -->
            <?php include("sidebar.php"); ?>
            <!-- End Left Sidebar  -->
            <!-- Page wrapper  -->
            <div class="page-wrapper">
                <!-- Bread crumb -->
                <div class="row page-titles">
                    <div class="col-md-5 align-self-center">
                        <h3 class="headtext">Select CSV</h3> </div>
                    <div class="col-md-7 align-self-center">
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item active">Select CSV</li>
                        </ol>
                    </div>
                </div>
                <!-- End Bread crumb -->
                <!-- Container fluid  -->
                <div class="container-fluid">
                    <!-- Start Page Content -->
        <?php
        $sqllink=mysqli_query($conn,"SELECT * FROM `Table_Test_CSV_ramanora` WHERE `CompanyName`='".$companyname."'");
     $blink=mysqli_fetch_array($sqllink);
     $idlink = $blink['id'];
        ?>



                    <div class="row">
    <?php $select = mysqli_query($conn,"SELECT u.Id, u.Name, u.Mobile, u.email, u.Organization, u.Designation, u.CompanyKey, ac.CompanyId, ac.Facility, ac.CompanyKey
    FROM ProductDetails u LEFT JOIN CompanyKeys ac ON ac.CompanyKey = u.CompanyKey WHERE CompanyId ='$companyname' ");

            while($row = mysqli_fetch_array($select)){
            // $editid = $row['u.Id'];

            ?>
    <?php  

    $select=mysqli_query($conn,"SELECT * FROM  `csvname` WHERE  `CompanyName` ='".$companyname."' ORDER BY  `csvname`.`Id` DESC ");
    while($rownew = mysqli_fetch_array($select)){

    ?>
                        <div class="col-lg-4">
                            <div class="card">
                                <div class="card-body">

                                    <h4 class="card-title text-center"><?php echo $rownew['CsvName'];   ?></h4>

                                    <div class="card-content">
                                        <div class="toastr m-t-15">
                                            <div class="text-left text-center">
                                                 <a href="assigncallr.php?id=<?php echo $id;?>&&key=<?php echo $name;?>&&name=<?php echo $rownew['CsvName'];?>"><button type="button" class="btn btn-success m-b-10 m-l-5"><i class="fa fa-eye"></i> View CSV</button></a>

                                                <button class="btn btn-danger btn btn m-b-10" id="<?php echo $rownew['CsvName'];?>" data-id="<?php echo $rownew['CsvName'];?>row" href="javascript:void(0)">Delete CSV<i class="fa fa-trash"></i> </button>

                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <!-- /# card -->
                        </div>
    <?php } ?>
    <?php } ?>
                        <!-- /# column -->
                      </div>

                    <!-- End PAge Content -->
                </div>
                <!-- End Container fluid  -->


    <?php  

    $selectdatarow=mysqli_query($conn,"SELECT * FROM  `csvname` WHERE  `CompanyName` ='".$companyname."' ORDER BY  `csvname`.`Id` DESC ");
    while($rownewdatarow = mysqli_fetch_array($selectdatarow)){

    ?>

    <script>
    $(document).ready(function(){

      readProducts(); /* it will load products when document loads */

      $(document).on('click', '#<?php echo $rownewdatarow['CsvName'];?>', function(e){

       var productId = $(this).data('id');
       SwalDelete(productId);
       e.preventDefault();
      });

     });

     function SwalDelete(productId){

      swal({
       title: 'Are you sure?',
       text: "You won't be able to revert this!",
       type: 'warning',
       showCancelButton: true,
       confirmButtonColor: '#3085d6',
       cancelButtonColor: '#d33',
       confirmButtonText: 'Yes, delete it!',
       showLoaderOnConfirm: true,

       preConfirm: function() {
         return new Promise(function(resolve) {

            $.ajax({
            url: 'delete.php',
            type: 'POST',
               data: 'delete='+productId,
               dataType: 'json'
            })
            .done(function(response){
             swal('Deleted!', response.message, response.status);
         readProducts();
            })
            .fail(function(){
             swal('Oops...', 'Something went wrong with ajax !', 'error');
            });
         });
          },
       allowOutsideClick: false     
      }); 

     }

     function readProducts(){
      $('#load-products').load('read.php'); 
     }

    </script>
    <?php } ?>
    <script src="js/lib/sweetalert/sweetalert.min.js"></script>
        <!-- scripit init-->

    <?php include("footer.php"); ?> 

Это файл delete.php. Я думаю, что проблема в этом файле в основном!

**delete.php**
<?php
header('Content-type: application/json; charset=UTF-8');
$response = array();

if ($_POST['delete']) {

    require_once 'dbConfig.php';

    $pid = intval($_POST['delete']);
    $query = "DELETE w,e
FROM Table_Test_CSV_ramanora w
INNER JOIN `csvname` e
  ON w.CsvName=e.Csvname
WHERE w.CsvName =:pid";
    $stmt = $DBcon->prepare( $query );
    $stmt->execute(array(':pid'=>$pid));

    if ($stmt) {
        $response['status']  = 'success';
 $response['message'] = 'Product Deleted Successfully ...';
    } else {
        $response['status']  = 'error';
 $response['message'] = 'Unable to delete product ...';
    }
    echo json_encode($response);
}

Пожалуйста, помогите мне здесь.

0 ответов

Другие вопросы по тегам