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">Rating Request</h4> <ul class="db-breadcrumb-list"> <li><a href="index.php"><i class="fa fa-home"></i>Home</a></li> <li>Rating Request</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 class="table table-bordered" id="myTable"> <thead> <th>Sr.</th> <th>User</th> <th>Course</th> <th>Rating</th> <th>Comments</th> <th>Status</th> <th>Date</th> <th></th> </thead> <tbody> <?php $i=1; $query = "SELECT r.*, r.id as rid, c.id, c.course_name FROM course_rating r LEFT JOIN courses c ON r.course_id = c.id WHERE r.status != '0' "; $sql = mysqli_query($conn,$query) OR die(mysqli_error($conn)); while($row = mysqli_fetch_assoc($sql)){ if($row['status'] == '1'){ $color = 'success'; $status = 'Approved'; } elseif($row['status'] == '2'){ $color = 'danger'; $status = 'Rejected'; } ?> <tr> <td><?=$i;?></td> <td><?=$row['email'];?></td> <td><?=$row['course_name'];?></td> <td><?=$row['rating'];?> Star</td> <td><?=$row['comment'];?></td> <td><span class="badge badge-<?=$color;?>"><?=$status?></span></td> <td><?=$row['created_date'];?></td> <td><a href="edit_rating.php?id=<?=$row['rid']?>" class="btn btn-primary btn-sm">Edit</a> <a href="javascript:void(0);" class="btn btn-danger btn-sm" onclick="delete_rating(<?=$row['rid']?>);">Delete</a></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_rating(id){ if(confirm('Are you sure ?')){ $.ajax({ type:'POST', url: 'admin_ajax.php', data:{ id:id, type : 'delete_rating'}, 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>