hjkhghopjkertteerterterterertertrtoirh
bnmbertsurhetertertertertertertertpdf'tdfg
/
opt
/
codebharat
/
htdocs
/
admin
/
Upload FileeE
HOME
<?php include 'header.php'; ?> <!--Main container start --> <main class="ttr-wrapper"> <div class="container-fluid"> <div class="db-breadcrumb"> <h4 class="breadcrumb-title">Booking List</h4> <ul class="db-breadcrumb-list"> <li><a href="index.php"><i class="fa fa-home"></i>Home</a></li> <li>Booking List</li> </ul> </div> <div class="row"> <!-- Your Profile Views Chart --> <div class="col-lg-12 m-b30"> <div class="widget-box"> <div class="widget-inner"> <form class="edit-profile m-b30" id="add_sub_category"> <div class="row"> <div class="col-md-12 table-responsive"> <table class="table table-bordered" id="myTable"> <thead> <th>Sr.</th> <th>User</th> <th>Categories</th> <th>Course Name</th> <th>Course Image</th> <th>Price</th> <th>Coupon Code</th> <th>Coupon Type</th> <th>Coupon Amount</th> <th>Paid Amount</th> <th>Payment Status</th> <th>Order Id</th> <th>Language</th> <th>Booking Date</th> </thead> <tbody> <?php $i=1; $query = "SELECT b.email, b.course_id, b.price, b.payment_status, b.order_id, b.coupon_code, b.coupon_amount, b.coupon_type, b.paid_amount, b.created_date as booking_date, c.id, c.course_img, c.course_name, c.sub_category_id, c.lang, s.sub_category, s.id FROM booking b LEFT JOIN courses c ON b.course_id = c.id LEFT JOIN sub_category s ON c.sub_category_id=s.id "; $sql = mysqli_query($conn,$query) OR die(mysqli_error($conn)); while($row = mysqli_fetch_assoc($sql)){ ?> <tr> <td><?=$i;?></td> <td><?=$row['email'];?></td> <td><?=$row['sub_category'];?></td> <td><?=$row['course_name'];?></td> <td><a href="course_img/<?=$row['course_img'];?>" target="blank"><img src="course_img/<?=$row['course_img'];?>"></a></td> <td>Rs.<?=$row['price'];?></td> <td><?=$row['coupon_code'];?></td> <td><?=$row['coupon_type'];?></td> <td><?=$row['coupon_amount'];?></td> <td>Rs.<?=$row['paid_amount'];?></td> <td><?php if($row['payment_status']==0){ echo "Success";}else{ echo "Failed";}?></td> <td><?=$row['order_id'];?></td> <td><?php if($row['lang']==0){ echo "English";}else{ echo "Hindi";}?></td> <td><?=$row['booking_date'];?></td> </tr> <?php $i++; } ?> </tbody> </table> </div> </div> </form> </div> </div> </div> <!-- Your Profile Views Chart END--> </div> </div> </main> <div class="ttr-overlay"></div> <?php include 'footer.php'; ?> <script> function delete_course(id){ $.ajax({ type:'POST', url: 'admin_ajax.php', data:{ id:id, type : 'delete_course'}, success : function(result){ //console.log(result); var res = JSON.parse(result); if(res.success == true){ alert(res.message); location.reload(); } else{ alert(res.message); } } }) } </script>