D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
buildteksolution
/
public_html
/
superadmin
/
Filename :
products.php
back
Copy
<?php include 'cn.php'; session_start(); if(isset($_SESSION['username'])) { } else { header("location:login.php"); } ?> <!DOCTYPE html> <html lang="en"> <head> <!-- Required meta tags --> <meta charset="utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" /> <link rel="stylesheet" href="https://cdn.datatables.net/1.11.3/css/dataTables.bootstrap4.min.css" crossorigin="anonymous"> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.5.2/css/bootstrap.css" crossorigin="anonymous"> <title>Golden Sparrow Web Designers</title> <link rel="icon" href="https://www.goldensparrow.com.au/lo.png"> <style> .scrollbar{ overflow:auto ; white-space: nowrap; } </style> </head> <body> <div class="container-scroller"> <?php include 'header.php'; ?> <!-- partial --> <div class="main-panel"> <div class="content-wrapper pb-0"> <div class="col-12 grid-margin stretch-card"> <div class="card"> <div class="container"> <div> <h2 style="text-align:center;margin-top:8px;">All Products</h2> <a href="add-product.php"><button type="button" class="deleteRecord btn btn-danger" >Add Product</button></a> </div> <div class="scrollbar"> <table id="example" class="table table-striped table-bordered" style="width:100%"> <thead> <tr> <th>Sno</th> <th>Name</th> <th>Category</th> <th>Price</th> <th>Action</th> </tr> </thead> <tbody> <?php $sql ="SELECT * FROM `products`"; $run =mysqli_query($con,$sql); $i=1; while($row = $run->fetch_assoc()) { ?> <tr> <td><?php echo $i; ?> </td> <td><?php echo $row['name']; ?> </td> <td><?php echo $row['category']; ?> </td> <td>AUD $<?php echo $row['price']; ?> </td> <td> <a href="edit-product.php?id=<?php echo $row['id']; ?>"><button type="button" class="deleteRecord btn btn-danger" data-bs-target="#exampleWarningModal" data-id="<?php echo $row['id']; ?>">Edit</button></a> <a href="deleteproduct.php?id=<?php echo $row['id']; ?>"><button type="button" class="deleteRecord btn btn-danger" data-bs-target="#exampleWarningModal" data-id="<?php echo $row['id']; ?>">Delete</button></a> </td> </tr> <?php $i++; }?> </tfoot> </table> </div> </div> </div> </div> </div> <!-- content-wrapper ends --> <!-- partial:partials/_footer.html --> <?php include'footer.php'; ?> <!-- partial --> </div> <!-- main-panel ends --> </div> <!-- page-body-wrapper ends --> </div> <!-- container-scroller --> <script src="https://code.jquery.com/jquery-3.5.1.js"></script> <script src="https://cdn.datatables.net/1.11.3/js/jquery.dataTables.min.js"></script> <script src="https://cdn.datatables.net/1.11.3/js/dataTables.bootstrap4.min.js"></script> <script> $(document).ready(function() { $('#example').DataTable(); } ); </script> <script> // $(".deleteRecord").click(function(e) { // var e_id = $(this).data("id"); // $.ajax({ // url: "new-action.php", // type: 'post', // data: { 'e_id':e_id }, // success: function(response) { // // console.log(response); // if(response == 1) { // alert(\"Deleted Successfully!.\") // location.href='index.php'; // // $('#mytablerow').remove(); // }else if(response == 0){ // // swal("Great","Item added To your Cart", "success"); // } // } // }); // }); </script> </body> </html>