1#@!#!123s

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

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

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

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

    #srkproperty_details .course-detailsa img {
        width: 100% !important;
        max-height: 250px !important;
    }

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

</script>


<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
        </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>Title</th>
                            <th>Posted Date</th>
                            <th>Picture</th>
                            <th>Details</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>

                        <?php
        $srno = 0;
        $sqlAssign1 = "SELECT * FROM `atul_blogs` ORDER BY `atul_blogs`.`id` DESC";			
//                   echo $sqlAssign1;     
        $resultAssign1 = mysqli_query($conn, $sqlAssign1);											
        if (mysqli_num_rows($resultAssign1) > 0) {
            while($rows = mysqli_fetch_assoc($resultAssign1)) { 
                
                $id = $rows['id'];
                $title = $rows['title'];
                  $b_custom_url = $rows['custom_url'];
                $date_add = $rows['date_add'];
				$post_by = $rows['post_by'];
                $blogs_details = $rows['blogs_details'];
                $picture = $rows['picture'];
                 $blogz_tags = $rows['blog_tags'];
                 $t_status = $rows['status'];
                
                
      
                
?>
                        <tr>
                            <th scope="row"><?php echo $srno += 1;?></th>

                            <td class="text-left">
                                <p><b>Title : </b><?php echo $title;?></p>
                                <?php if(!empty($b_custom_url)){?>
                                <p><b>Custom Url : </b><?php echo $b_custom_url;?></p>
                                <?php }?>
                                <?php if(!empty($blogz_tags)){?>
                                <p><b>Tags : </b><?php echo $blogz_tags;?></p>
                                <?php }?>


                            </td>

                            <td>
                                <p><b>Posted By : </b><?php echo $date_add;?></p>
                                <br>
                                <p><b>Posted By : </b><?php echo $post_by;?></p>
                            </td>
                            <td><img src="<?php echo $admin_baseurl . 'blogs/blogs-files/'. $picture;?>" style="width:100px;"></td>

                            <td>
                                <a type="button" course-details='<?php echo $blogs_details;?>' data-toggle="modal" data-target="#srkproperty_details" class="btn theme-btn show_property_details" style="cursor: pointer;">More Detail</a>
                            </td>


                            <td>
                                <div class="action_btns">

                                    <form method="post" action="update-blogs-details.php?id=<?php echo $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-details.php?id=<?php echo $id;?>">
                                        <button type="submit" name="Delete_blogs_details" 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($t_status == 'active'){?>
                                    <form method="post" action="execute-blogs-details.php?id=<?php echo $id;?>">
                                        <button type="submit" name="status_deactive_blogs" class="actionbtn"><i class="fa fa-toggle-on text-success" aria-hidden="true"></i></button>
                                    </form>
                                    <?php }else{?>
                                    <form method="post" action="execute-blogs-details.php?id=<?php echo $id;?>">
                                        <button type="submit" name="status_active_blogs" 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');
?>