<?php include("includes/db_config.php"); ?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <title>Telangana Journalist Reporter Association</title>
    <?php include("includes/css.php");?>
    <link rel="canonical" href="https://www.tjra.in/" />
    <meta property="og:locale" content="en_Us" />
    <meta property="og:type" content="website" />
    <meta property="og:title" content="Telangana Journalist Reporter Association" />
    <meta property="og:description" content="Telangana Journalist Reporter Association provides " />
    <meta property="og:url" content="https://www.tjra.in//" />
    <meta property="og:site_name" content="Telangana Journalist Reporter Association" />
    <meta charset="utf-8">
    <meta name="keywords" content="" />
    <meta name="author" content="Telangana Journalist Reporter Association">
    <meta name="description" content="" />
    <style>
        .page-header {
            padding-top: 10px;
            padding-bottom: 5px;
        }

        .page-header__bg {
            background-image: none;
            background-color: #fff;
        }

        .page-header__bg::before {
            background-color: #000
        }

        .blog-details__text {
            padding-right: 10px;
            font-size: 18px;
            text-align: justify;
        }

        .comments-one__card:not(:first-of-type) {
            margin-top: 25px;
            padding-top: 25px;
        }

        .blog-card {
            margin-bottom: 25px;
        }.blog-card__content{padding-bottom: 8px}
        .blog-card__image{border-radius: 16px 16px 0px 0px;background-color: transparent;}
        .blog-card__image img{height: 215px;}
          @media (min-width: 320px) and (max-width: 640px) {
             .page-header {
                 padding-top:40px;
                 padding-bottom: 5px;
             }
         }
    </style>
</head>

<body class="custom-cursor">
    <div class="custom-cursor__cursor"></div>
    <div class="custom-cursor__cursor-two"></div>

    <div class="page-wrapper">
        <?php include("includes/header.php");?>

        <section class="page-header">
            <div class="page-header__bg"></div>
            <div class="container-fluid">
                <ul class="careox-breadcrumb list-unstyled">
                    <li><a href="index.php">Home</a></li>
                    <li><span>Photo Gallery</span></li>
                </ul>
            </div>
        </section>

        <section class="blog-two blog-two--home-three">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-md-12">
                        <div class="sec-title text-left">
                            <h6 class="sec-title__tagline bw-split-in-right"><span class="sec-title__tagline__border"></span>Latest</h6>
                            <h3 class="sec-title__title bw-split-in-left">Photo Gallery</h3>
                        </div>
                    </div>
                </div>
                <div class="row blog-one__carousel">
                     <?php  $sql2 = 'SELECT crk_gallery_category.gallery_name,crk_gallery_category.id as gidd,crk_gallery_image.* FROM crk_gallery_image
                                JOIN crk_gallery_category ON crk_gallery_image.gallery_cat_id = crk_gallery_category.id
                                WHERE crk_gallery_image.id IN (
                                    SELECT MAX(crk_gallery_image.id)
                                    FROM crk_gallery_image
                                    GROUP BY gallery_cat_id
                                ) ORDER BY crk_gallery_image.gallery_cat_id';
                        $resultq=mysqli_query($conn, $sql2);
                        while($gal=mysqli_fetch_array($resultq)){ ?>
                    <div class="col-md-3 item">
                        <div class="blog-card wow fadeInUp" data-wow-duration='1500ms' data-wow-delay='100ms' style='--accent-color: #ff5528;'>
                            <div class="blog-card__image">
                                <img src="admin-jurep/gallery/<?= $gal['image']; ?>" alt="">
                                <img src="admin-jurep/gallery/<?= $gal['image']; ?>" alt="">
                                <a href="gallery-detail.php?g_id=<?= $gal['gidd'];?>" class="blog-card__image__link"><span class="sr-only"><?php $string = $gal['gallery_name']; 
                                                echo substr($string, 0, 25); ?></span>
                                </a>
                            </div>
                            <div class="blog-card__content">
                                <h3 class="blog-card__title"><a href="gallery-detail.php?g_id=<?php echo ($gal['gidd']);?>"><?php $string = $gal['gallery_name']; echo substr($string, 0, 25); ?></a></h3>
                            </div>
                        </div>
                    </div>
                    <?php } ?>
                   
                </div>
            </div>
        </section>
    </div>
    <?php include("includes/footer.php");?>
    <?php include("includes/js.php");?>
</body>

</html>