/
var
/
www
/
html
/
stengineers
/
admin
/
Upload FileeE
HOME
<?php header('Access-Control-Allow-Origin: *'); require_once('dbconnection.php'); error_reporting(0); $blog_id = $_GET['id']; include 'header.php'; ?> <!-- Begin Page Content --> <div class="container-fluid"> <!-- Page Heading --> <!-- <h1 class="h3 mb-2 text-gray-800">Job List</h1> <p> <a href="job-add.php" class="btn btn-success btn-icon-split"> <span class="icon text-white-50"> <i class="fas fa-check"></i> </span> <span class="text">Add Job</span> </a> </p> --> <!-- DataTales Example --> <div class="card shadow mb-4"> <div class="card-header py-3"> <!-- <h6 class="m-0 font-weight-bold text-primary">DataTables Example</h6> --> </div> <div class="card-body"> <div class="table-responsive"> <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0"> <thead> <tr> <th>Username</th> <th>Email</th> <th>Url</th> <th>Comments</th> <th>status</th> </tr> </thead> <tfoot> <tr> <th>Username</th> <th>Email</th> <th>Url</th> <th>Comments</th> <th>status</th> </tr> </tfoot> <tbody id="table_id"> <?php $s = "select * from blog_comments where blog_id = '$blog_id'"; $res = mysqli_query($con, $s); $num = mysqli_num_rows($res); if ($num == 0) { echo '<tr> <td colspan="5">No Datas Found</td> </tr>'; } else { $carr = array(); $sql = "SELECT id,username, email, comments, url, DATE_FORMAT(created_at, '%d-%m-%Y') as created_at , status FROM blog_comments where blog_id = '$blog_id' ORDER BY id DESC"; $selected = mysqli_query($con, $sql); while($row = mysqli_fetch_array($selected)) { $id = $row['id']; $username = $row['username']; $email = $row['email']; $comments = $row['comments']; $url = $row['url']; $status = $row['status']; ?> <tr> <td><?php echo $username ?></td> <td><?php echo $email ?></td> <td><?php echo $url ?></td> <td><?php echo $comments ?></td> <td style='white-space: nowrap;'> <select class="form-control form-control-solid" name="status" id="status" onchange="showEditor(<?php echo $id?>,this,<?php echo $blog_id?>)"> <!-- <option value="">Select</option> --> <option value="approved" <?php if($status == 'approved') { ?> selected="selected"<?php } ?>>Approved</option> <option value="pending" <?php if($status == 'pending') { ?> selected="selected"<?php } ?>>Pending</option> <option value="rejected" <?php if($status == 'rejected') { ?> selected="selected"<?php } ?>>Rejected</option> </select> <div id="succ-client-alert-<?php echo $id?>" style='color: green;'></div> <div id="fail-client-alert-<?php echo $id?>" style='color: red;'></div> </td> </tr> <?php } } ?> </tbody> </table> </div> </div> </div> </div> <!-- /.container-fluid --> <script type="text/javascript"> function refreshData(){ $("#table_id").load(window.location + " #table_id"); } function deleteData(id){ var id = id; var getData; $.ajax({ url: 'api/career.php', type: 'POST', data:{id:id,action:"delete", referer:"ezioaws"}, success: function (response) { var responseObject = JSON.parse(response); // console.log(responseObject.name,"response"); console.log(response,"response"); refreshData(); } }); } </script> <script type="text/javascript"> function showEditor(divId, element,blogid) { var id = divId; var val = element.value; var css = 'succ-client-alert-'.concat(id); console.log(element.value, divId,blogid,css); // return false; $.ajax({ url: 'api/admin-blog.php', type: 'POST', data:{status:val, id:id, referer:"ezioaws", action:"updatecommentstatus"}, success: function(data) { console.log(data.status,'data'); var data = JSON.parse(data); if(data.status=="success") { $('#succ-client-alert-'.concat(id)).html(data.message); $('#fail-client-alert-'.concat(id)).html(''); setTimeout(function() { window.location.href="blog-comments.php?id=".concat(blogid); }, 1000); } else { $('#succ-client-alert-'.concat(id)).html(''); $('#fail-client-alert-'.concat(id)).html(data.message); } } }); } </script> <?php include 'footer.php'?>