1#@!#!123s

: / home / epksuofuukz9 / www / admin /
Filename : view_all_comments.php
back
<?php include("includes/header.php"); ?>
<body class="hold-transition sidebar-mini">
<div class="wrapper">
  <!-- Navbar -->
  <?php include("includes/top_nav.php");?>
  <!-- /.navbar -->
  <!-- Main Sidebar Container -->
  <?php include("includes/side_nav.php");?>
  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1>Blog Comments</h1>
          </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="dashboard.php" style="color:#111;">Dashboard</a></li>
              <li class="breadcrumb-item active">View All Comments</li>
            </ol>
          </div>
        </div>
      </div><!-- /.container-fluid -->
    </section>
	<!-- Main content -->
    <section class="content">
      <div class="row">
        <div class="col-12">
          <div class="card">
            <div class="card-header">
              <h3 class="card-title">View All Comments</h3>
            </div>
            <!-- /.card-header -->
            <div class="card-body table-responsive">
              <table id="example1" class="table table-bordered table-striped">
                <thead>
                <tr>
                  <th>S.N.</th>
                  <th>Blog Title</th>
                  <th>Name</th>
                  <th>Email</th>
                  <th>Status</th>
                  <th>Date</th>
				          <th>Action</th>
                </tr>
                </thead>
                <tbody>
				<?php
				$i=0;
				$get_all="SELECT * FROM blogs_comment JOIN blogs ON blogs_comment.blog_id=blogs.blogs_id  ORDER BY c_id DESC";
				$run_all=query($get_all);
				while($row_all=fetch($run_all))
				{
          $c_id =$row_all['c_id'];
          $title=$row_all['title'];
          $slug_url=$row_all['slug_url'];
					$blogs_id =$row_all['blogs_id'];					
					$c_name =$row_all['c_name'];
					$c_email =$row_all['c_email'];
					$c_message =$row_all['c_message'];
					$c_date =$row_all['c_date'];
					$status =$row_all['c_status'];
          $c_reply_by=$row_all['c_reply_by'];
          $c_reply=$row_all['c_reply'];
          $c_reply_date=$row_all['c_reply_date'];
					$created_date =$row_all['created_date'];	
					$i++;
				?>
                <tr>
                  <td><?php echo $i;?></td>
                  <td><?php echo $title;?></td>
                  <td><?php echo $c_name;?></td>
                  <td><?php echo $c_email;?></td>
                  <td><?php echo $status=='0'?'Pending':'Approved'; ?></td>
                  <td><?php echo $c_date; ?></td>
				  <td><a href="view_all_comments.php?status=<?php echo $c_id; ?>" onclick="return confirm('Are you sure you want to change this status?');"><button type="button" class="btn btn-block btn-primary btn-sm"><?php echo $status=='0'?'Approve':'Disapprove'; ?></button>
            <a href="../blog/<?php echo $slug_url; ?>" target="_blank"><button type="button" class="btn btn-block btn-dark btn-sm">View</button></a>


            <button type="button" class="btn btn-block btn-secondary btn-sm" data-toggle="modal" data-target="#modal-default<?php echo $c_id; ?>">
                Edit
              </button>
        <div class="modal fade" id="modal-default<?php echo $c_id; ?>" style="display: none;" aria-hidden="true">
        <div class="modal-dialog">
          <div class="modal-content">
            <div class="modal-header">
              <h4 class="modal-title">Reply</h4>
            </div>
      <form role="form" method="POST" action="php/blog_comment.php" enctype="multipart/form-data">
                
            <div class="modal-body">
              <div class="form-group">
                    <label for="exampleInputEmail1">Blog Title </label>:  <?php echo $title; ?>
                      <input type="hidden" name="comment_id" value="<?php echo $c_id; ?>">
              </div>
              <div class="form-group">
                    <label for="exampleInputEmail1">Name</label>:  <?php echo $c_name; ?>
              </div>
              <div class="form-group">
                    <label for="exampleInputEmail1">Email</label>: <?php echo $c_email; ?>
              </div>
              <div class="form-group">
                    <label for="exampleInputEmail1">Comment</label>
                    <textarea class="form-control" name="comment" id="exampleInputEmail1" placeholder="Reply" required><?php echo $c_message; ?></textarea>
              </div>
              <div class="form-group">
                    <label for="exampleInputEmail1">Reply Date</label>: <?php echo $c_reply_date; ?>
              </div>
              <div class="form-group">
                    <label for="exampleInputEmail1">Reply</label>
                     <textarea class="form-control" name="reply" id="exampleInputEmail1" placeholder="Reply" required><?php echo $c_reply; ?></textarea>
              </div>
            <div class="modal-footer justify-content-between">
              <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
              <button type="submit" class="btn btn-primary" name="submit">Save changes</button>
            </div>
      </form>
          </div>
          <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
      </div>
    </div>
				  <a href="view_all_comments.php?delete=<?php echo $c_id;?>"><button type="button" class="btn btn-block btn-danger btn-sm" onclick="return confirm('Are you sure you want to delete this comment?');">Delete</button></a></td>
                </tr>
				<?php
				}
				?>
                </tbody>
                <tfoot>
                <tr>
                  <th>S.N.</th>
                  <th>Meta Title</th>
                  <th>Course Name</th>
                  <th>Cover Image</th>
                  <th>Status</th>
                  <th>Date</th>
                  <th>Action</th>
                </tr>
                </tfoot>
              </table>
            </div>
            <!-- /.card-body -->
          </div>
          <!-- /.card -->
        </div>
        <!-- /.col -->
      </div>
      <!-- /.row -->
    </section>
    <!-- /.content -->
	<?php
	if(isset($_GET['delete']))
	{
		$the_id=$_GET['delete'];
		$delete="DELETE FROM blogs_comment WHERE c_id='$the_id'";
		$run_delete=query($delete);
		confirm($run_delete);
		if($run_delete)
		{
			echo "<script>alert('Comment has been deleted');</script>";
			echo "<script>window.open('view_all_comments.php','_self');</script>";
		}
	}

  if(isset($_GET['status']))
  {
    $the_id=$_GET['status'];
    $get_status="SELECT * FROM blogs_comment WHERE c_id='$the_id'";
    $run_status=query($get_status);
    $row_status=fetch($run_status);
    $comment_status=$row_status['c_status'];
    $new_status=$comment_status=='0'?'1':'0';
    $update="UPDATE blogs_comment SET `c_status`='$new_status' WHERE c_id='$the_id'";
    $run=query($update);
    confirm($run);
    if($run)
    {
      echo "<script>alert('Your Status has been succesufully changed');</script>";
      echo "<script>window.open('view_all_comments.php','_self');</script>";
    }
  }
	?>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->
  <?php include("includes/footer.php");?>

  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->
<?php include("includes/scripts.php"); ?>
<script>
  $(function () {
    $("#example1").DataTable();
    $('#example2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
    });
  });
</script>
</body>
</html>