1#@!#!123s

: / proc / thread-self / root / home / shubmkcj / designpitara.com / admin / testimonials /
Filename : view-blogs-review.php
back
<?php
    
   include("../include/config.php");
    include("../include/sessionhandle.php");
    include("../include/header.php");
?>


<style>
    #testimonials ul li:nth-child(3) {
        background-color: #eb6a4e;
    }

    #testimonials ul li:nth-child(3) a {
        color: #fff;
    }

    #testimonials ul li:nth-child(3) a:hover {
        background-color: #eb6a4e;
    }

    
    .table-responsive .table td:nth-child(2) {
    width: 25%;
    }
    .table-responsive .table td:nth-child(3) {
    width: 40%;
    }
    .table-responsive .table td:nth-child(4) {
    width: 100px;
    }

</style>
<script>
    window.onload = function() {
        document.getElementById('testimonials').classList.add("active");
        document.getElementById('testimonials1').classList.add("in");
    };

</script>

<div class="small-header">
    <div class="hpanel">
        <div class="panel-body">
            <div id="hbreadcrumb" class="pull-right">
                <ol class="hbreadcrumb breadcrumb">
                    <li><a href="<?php echo $admin_baseurl . 'dashboard.php';?>">Dashboard</a></li>
                    <li class="active">
                        <span>Review</span>
                    </li>
                </ol>
            </div>
            <h2 class="font-light m-b-xs">
                View Blogs Reviews
            </h2>

        </div>
    </div>
</div>


<div class="content">
    <div class="hpanel">
        <div class="panel-heading hbuilt">
            <div class="panel-tools">
                <a class="showhide"><i class="fa fa-chevron-up"></i></a>
                <a class="fullscreen"><i class="fa fa-expand"></i></a>
            </div>
            View All Blogs Reviews
        </div>
        <div class="panel-body">
            <div class="table-responsive">
                <table id="userPermission_dataTable" class="table table-striped table-bordered table-hover">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Details</th>
                            <th>Review</th>                            
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>

                        <?php
        $srno = 0;
        $sqlAssign1 = "SELECT * FROM `blogs_review` ORDER BY `blogs_review`.`id` DESC";										
        $resultAssign1 = mysqli_query($conn, $sqlAssign1);											
        if (mysqli_num_rows($resultAssign1) > 0) {
            while($rows = mysqli_fetch_assoc($resultAssign1)) { 
                
                $testi_id = $rows['id'];
                $testi_blogs_id = $rows['blogs_id'];
                $testi_name = $rows['name'];
                $testi_email = $rows['email'];
                $testi_comment = $rows['feedback'];
                $testi_post_date = $rows['post_date'];
                $testi_status = $rows['status'];
                
//        $sqlAssign1s = "SELECT * FROM `blog` WHERE `blog`.`id`='$testi_blogs_id';";										echo $sqlAssign1s;
        $resultAssign1s = mysqli_query($conn, $sqlAssign1s);											
        if (mysqli_num_rows($resultAssign1s) > 0) {
            while($rowsz = mysqli_fetch_assoc($resultAssign1s)) {                 
                $blogs_title = $rowsz['title'];
            }}
                
?>
                        <tr>
                            <th scope="row"><?php echo $srno += 1;?></th>
                            <td style="text-align:left">
                                <p><b>Blogs : </b><?php echo $blogs_title;?></p>
                                <p><b>Name : </b><?php echo $testi_name;?></p>
                                <p><b>Email : </b><?php echo $testi_email;?></p>
                                <p><b>Posted Date : </b><?php echo $testi_post_date;?></p>
                            
                            </td>
                            <td style="text-align:left">
                                <p><?php echo $testi_comment; ?></p>                               
                            </td>

                            <td>
                                <div class="action_btns">

<!--
                                    <form method="post" action="update-testimonials.php?id=<?php echo $testi_id;?>">
                                        <button type="submit" class="actionbtn"><i class="fa fa-pencil-square-o text-success" aria-hidden="true"></i></button>
                                    </form>
-->

                                    <form method="post" action="execute-blogs.php?id=<?php echo $testi_id;?>">
                                        <button type="submit" name="Delete_testimonial" class="actionbtn" onclick="return confirm('Do you want to delete this data?')"><i class="fa fa-trash text-danger" aria-hidden="true"></i></button>
                                    </form>


                                    <?php if($testi_status == 'active'){?>
                                    <form method="post" action="execute-blogs.php?id=<?php echo $testi_id;?>">
                                        <button type="submit" name="status_deactive_testimonial" class="actionbtn"><i class="fa fa-toggle-on text-success" aria-hidden="true"></i></button>
                                    </form>
                                    <?php }else{?>
                                    <form method="post" action="execute-blogs.php?id=<?php echo $testi_id;?>">
                                        <button type="submit" name="status_active_testimoniale" class="actionbtn"><i class="fa fa-toggle-off text-danger" aria-hidden="true"></i></button>
                                    </form>
                                    <?php }?>
                                </div>
                            </td>


                        </tr>
                        <?php }}?>

                    </tbody>
                </table>
            </div>
        </div>

    </div>
</div>

<br>
<?php 
    include('../include/footer.php');
?>