product_display.php

<?php
include 'includes/db.php';
include 'includes/header.php';
include 'includes/navbar.php';

$sql= "SELECT * FROM users WHERE email = '$username'";
        $sql_run = mysqli_query($con, $sql);
        $row_a = mysqli_fetch_assoc($sql_run);
        $user_id= $row_a['id'];
        $type = $row_a['type'];
?>

<div class="app-main__outer">
 <div class="app-main__inner">
    <div class="app-page-title">
        <div class="page-title-wrapper">
           <div class="page-title-heading">
                <div class="page-title-icon">
                    <i class="pe-7s-global text-success">
                    </i>
                </div>
                <div>Products/Services
                    <div class="page-title-subheading">Add, Edit, Delete products/services here
                    </div>
                </div>
            </div>
            <div class="page-title-actions">
             <button style="font-size:14px;" type="button" class="btn mr-3 mb-3 btn-primary" data-toggle="modal" data-target="#addproduct">
                                          <i class="fa fa-plus"></i>&nbsp;&nbsp;  Add item
                                        </button> 
              
            </div>
         </div>
    </div>        
                            
    <div class="tab-content">
        <div class="tab-pane tabs-animation fade show active" id="tab-content-0" role="tabpanel">
        <?php            
        if(isset($_SESSION['SUCCESS']) && $_SESSION['SUCCESS'] !=''){
            echo '<div class="alert alert-success" role="alert"> '.$_SESSION['SUCCESS']. '</div>';
            unset($_SESSION['SUCCESS']);
        }
        if(isset($_SESSION['Failure']) && $_SESSION['Failure'] !=''){
            echo '<div class="alert alert-danger" role="alert"> '.$_SESSION['Failure']. '</div>';
            unset($_SESSION['Failure']);
        }
        ?>
            <div class="main-card mb-3 card">
                <div class="card-body">

<?php
        
              

        $query = "SELECT * FROM product WHERE user_id='$user_id' ";
        $query_run = mysqli_query($con, $query);
        
        
    ?>
      <table class="table table-striped table-bordered " id="table" >
        <thead align="center">
          <tr>
              <th> ID </th>
              <th>Product/Service Name</th>
              <th>HSN/SAC Code </th>
              <th>Rate per Unit</th>
              
              <th>Edit</th>
              <th>Delete</th>
          </tr>
        </thead>
        <tbody align="center">
        <?php
        
            while($row = mysqli_fetch_assoc($query_run))
            {
               ?>
          <tr>
            <td><?php  echo $row['product_id'] ?></td>
            <td><?php  echo $row['product_description']; ?></td>
            <td><?php  echo $row['sac']; ?></td>
            <td><?php  echo $row['rate']; ?></td>
            <td>
                <form action="product_edit.php" method="post">
                    <input type="hidden" name="edit_id" value="<?php echo $row['product_id']; ?>">
                    <button  type="submit" name="edit_btn" class="btn btn-success"> <i class="fa fa-pen"></i></button>
                </form>
            </td>
            <td>
            <button type="button" data-id1="<?php echo $row['product_id']; ?>" id="deleteproduct" class="btn btn-danger"><i class="fa fa-trash"></i></button>
            </td>
          </tr>
          <?php
      
            } 
      
        ?>
        </tbody>
      </table>



      </div>
             </div>
         </div>
     </div>   
</div>  


<?php
include 'includes/footer.php';
?>

<script>
     $(document).ready(function() {
    $('#table').DataTable({
        "lengthMenu": [[25, 200, 300, -1], [25, 200, 300, "All"]],
        "order": [[ 0, "desc" ]],
        "columnDefs": [
            {
                "targets": [ 0 ],
                "visible": false,
                "searchable": false
            },
        ]
    });
});

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