1#@!#!123s

: / proc / thread-self / root / home / shubmkcj / designpitara.com / admin / gallery /
Filename : view-gallery.php
back
<?php
    include("../include/config.php");
    include("../include/sessionhandle.php");
    include("../include/header.php");
?>
<style>
    #d_Gallery ul li:nth-child(3) {
        background-color: #eb6a4e;
    }

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

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

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

    hr {
        margin-top: 5px !important;
        margin-bottom: 5px !important;
        border: 0;
        border-top: 1px solid #eee;
    }

    .img_container {
        position: relative;
        padding: 5px;
    }

    .overlay {
        position: absolute;
        top: 0;
        bottom: 0;
        left: 0;
        right: 0;
        height: 100%;
        width: 100%;
        opacity: 0;
        transition: .3s ease;
        background-color: #423e3e70;
    }

    .img_container:hover .overlay {
        opacity: 1;
    }

    .icon {
        color: red;
        font-size: 50px !important;
        position: absolute;
        top: 50%;
        left: 50%;
        transform: translate(-50%, -50%);
        -ms-transform: translate(-50%, -50%);
        text-align: center;
    }

    .fa-user:hover {
        color: #eee;
    }

</style>
<script>
    window.onload = function() {
        document.getElementById('d_Gallery').classList.add("active");
        document.getElementById('d_Gallery1').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>Gallery</span>
                    </li>
                </ol>
            </div>
            <h2 class="font-light m-b-xs">
                View Gallery
            </h2>
        </div>
    </div>
</div>




<div class="content">
    <div class="hpanel">
        <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 Gallery
            </div>
            <div class="panel-body">
                <?php
        $srno = 0;
        $sqlAssign1 = "SELECT * FROM `gallery` ORDER BY `gallery`.`id` DESC;";			
//                   echo $sqlAssign1;     
        $resultAssign1 = mysqli_query($conn, $sqlAssign1);											
        if (mysqli_num_rows($resultAssign1) > 0) {
            while($rows = mysqli_fetch_assoc($resultAssign1)) { 
                
                $gl_id = $rows['id'];
                $gallery = $rows['img'];
                $gl_title = $rows['img_name'];
                $img_categ = $rows['img_categ'];
                
                
                
    $sqlAssign2 = "SELECT * FROM `gallery_category` WHERE `gallery_category`.`id`='$img_categ';";
//    echo $sqlAssign2;
    
    $resultAssign2 = mysqli_query($conn, $sqlAssign2);											
    if (mysqli_num_rows($resultAssign2) > 0) {
        while($row1 = mysqli_fetch_assoc($resultAssign2)) { 
            $g_category_name = $row1['g_category_name'];
        }
    }
                                
?>

                <div class="col-md-4">
                    <div class="img_container">
                        <img src="<?php echo $admin_baseurl . 'gallery/upload/'.$gallery;?>" class="img-responsive" style="height:180px; width:100%">
                        <div class="overlay">
                            <form method="post" action="execute-img.php?id=<?php echo $gl_id;?>">
                                <button type="submit" name="delete_gallery_img" class="actionbtn icon" onclick="return confirm('Do you want to delete this data?')"><i class=" icon fa fa-trash text-danger" aria-hidden="true"></i></button>
                            </form>

                        </div>
                        <?php if(!empty($gl_title)){?>
                        <h5 style="text-align:center"><?php echo $gl_title; ?></h5>
                        <?php }?>
                        <?php if(!empty($img_categ)){?>
                        <h5 style="text-align:center"><?php echo $g_category_name; ?></h5>
                        <?php }?>
                    </div>

                </div>
                <?php }}else{ ?>

                <h4 style="text-align:center">There is no Images in database.</h4>

                <?php     } ?>

            </div>

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


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