<?php
    include "../partials/dbconnect.php";
?>

<?php
    $cid = $_GET['c'];
    $sql_blog_cat_title = "SELECT * FROM blog_categories WHERE category_id = $cid";

    $result = mysqli_query($conn, $sql_blog_cat_title);

    if ($row = mysqli_fetch_assoc($result)){

        $categories_title = $row['category_page_title'];

    }

?>


<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1, maximum-scale=5.0, user-scalable=yes">
    <link rel="icon" href="https://theunitedindian.com//images/site-logo.png" type="image/png">
    <link rel="stylesheet" href="https://theunitedindian.com//styles/style.css">
    <link rel="stylesheet" href="https://theunitedindian.com//styles/media.css">
    <title><?php echo ' '.$categories_title.' '; ?></title>
    <link rel="canonical" href="https://www.theunitedindian.com/news/category" />

</head>

<body>

    <?php
        include "../partials/header.php";
        include "../partials/sidebar.php";
    ?>

    <div class="category-main-container">
        <div class="category-container">

            <?php
                $cid = $_GET['c'];
                $sql_blog_cat = "SELECT * FROM blog_categories WHERE category_id = $cid";
                $sql_blogs_cat = "SELECT * FROM blogs INNER JOIN blog_categories ON blogs.blog_category = blog_categories.category_id";
                $result = mysqli_query($conn, $sql_blog_cat);
                
                // $sql_blogs_cat = "SELECT * FROM blogs INNER JOIN blog_categories ON blogs.blog_category = blog_categories.category_id WHERE blogs.blog_category = $cid ORDER BY blogs.blog_posting_date DESC";
                // $result = mysqli_query($conn, $sql_blogs_cat);


                if ($row = mysqli_fetch_assoc($result)){

                    // $categories_category_id = $row['category_id'];
                    $categories_category_name = $row['category_name'];
                    $categories_category_name_button = $categories_category_name;
                    $categories_category_name_button = str_replace(" ", "-", $categories_category_name_button);

                    echo '

                        <div class="category-title">
                            <p class="'.$categories_category_name_button.'-btn">'.$categories_category_name.'</p>
                        </div>
                        <div class="category-line">
                            <p>Latest in '.$categories_category_name.'</p>
                        </div>

                    ';

                }

            ?>

            <div class="category-blog-main-container">

                <?php
                    $blogs_cat = $_GET['c'];
                    $sql_blogs_cat = "SELECT * FROM blogs INNER JOIN blog_categories ON blogs.blog_category = blog_categories.category_id WHERE blogs.blog_category = $blogs_cat ORDER BY blogs.blog_category, blogs.blog_posting_date DESC";
                    $result = mysqli_query($conn, $sql_blogs_cat);

                    while ($row= mysqli_fetch_assoc($result)) {

                        $blogs_cat_blog_id = $row['blog_id'];
                        $blogs_cat_blog_meta_description = $row['blog_meta_description'];
                        $blogs_cat_blog_meta_keywords = $row['blog_meta_keywords'];
                        $blogs_cat_blog_page_title = $row['blog_page_title'];
                        $blogs_cat_blog_title = $row['blog_title'];
                        $blogs_cat_blog_image = $row['blog_image'];
                        $blogs_cat_blog_img_alt_desc = $row['blog_img_alt_desc'];
                        $blogs_cat_blog_image_credit_link = $row['blog_image_credit_link'];
                        $blogs_cat_blog_tagline = $row['blog_tagline'];
                        $blogs_cat_blog_tags = $row['blog_tags'];
                        $blogs_cat_blog_content  = $row['blog_content'];
                        $blogs_cat_blog_posting_date = date('M d, Y', strtotime($row['blog_posting_date']));
                        $blogs_cat_blog_category_name = $row['category_name'];
                        $blogs_cat_blog_category = $row['blog_category'];
                        $blogs_cat_blog_category_name_button = $blogs_cat_blog_category_name;
                        $blogs_cat_blog_category_name_button = str_replace(" ", "-", $categories_category_name_button);
                        $blogs_cat_blog_category_name_cat_link = strtolower($blogs_cat_blog_category_name);
                        $blogs_cat_blog_category_name_cat_link = str_replace(" ", "_", $blogs_cat_blog_category_name_cat_link);
                        $blogs_cat_blog_slug = $row['blog_slug'];

// <a href="https://theunitedindian.com/news/blog?'.$blogs_cat_blog_slug.'&b='.$blogs_cat_blog_id.'&c='.$blogs_cat_blog_category.'" class="cat-img-blog-link">
                        echo '

                            <div class="category-blog-container">
                                <div class="category-left">
                                    <div class="category-image">
                                        <a href="https://theunitedindian.com/news/'.$blogs_cat_blog_slug.'" class="cat-img-blog-link">
                                            <img src="https://theunitedindian.com/images/'.$blogs_cat_blog_image.'" width="650" height="370" alt="'.$blogs_cat_blog_img_alt_desc.'">
                                        </a>
                                    </div>
                                </div>
                                <div class="category-right">
                                    <div class="category-button">
                                        <a href="https://theunitedindian.com/news/'.$blogs_cat_blog_category_name_cat_link.'" class="'.$blogs_cat_blog_category_name_button.'-btn">'.$blogs_cat_blog_category_name.'</a>
                                    </div>
                                    <div class="category-blog-details">
                                        <a href="https://theunitedindian.com/news/'.$blogs_cat_blog_slug.'" class="cat-blog-det-link">
                                            <p>'
                                                .$blogs_cat_blog_title.
                                            '</p>
                                        </a>
                                    </div>
                                    <div class="category-posted-date">
                                        <div class="category-blog-date">
                                            <div class="date-time">
                                                <p>'.$blogs_cat_blog_posting_date.'</p>
                                            </div>
                                            <span class="bull">&bull;</span>
                                            <div class="blog-credit">
                                                <p>TUI Staff</p>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>

                        ';
                    }
                ?>

            </div>

            <!-- <div class="loading-btn">
                <a href="">Load more</a>
            </div> -->
        </div>
    </div>

    <!-- Footer -->
    <?php
        include "../partials/footer.php";
    ?>

</body>

</html>