<?php include("db_config.php");
if(isset($_POST['submit_comment']))
{ extract($_POST);
date_default_timezone_set('Asia/Kolkata');
$date = date('Y-m-d H:i:s');
$bid=$_POST["bid"];
$email = mysqli_real_escape_string($conn,$_POST['cmemail']);
$name = mysqli_real_escape_string($conn,$_POST['cmname']);
$message = mysqli_real_escape_string($conn,$_POST['cmmessage']);
$sqlq="INSERT into blog_comment(blog_id,name,email_id,message,created_date) values ('$bid','$name','$email','$message','$date')";
$res=mysqli_query($conn,$sqlq) or die(mysqli_error());
}
 ?> 
<!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("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: 190px;
            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;
  }</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("header.php");
 $page_name = str_replace(".php", "", basename($_SERVER['PHP_SELF']));
 $Current_URL = basename(dirname(__FILE__));
 $findid = (mysqli_query($conn, "SELECT * FROM blog"));
 while ($res2=mysqli_fetch_array($findid)) {
    if(strtolower(str_replace(" ", "-", $res2["blog_title"])) == $page_name){
        $bid = $res2["id"];
    }
}      $sql2="select * from blog where id='".$bid."'";
       $exe2=mysqli_query($conn,$sql2);
       $res=mysqli_fetch_array($exe2);
       $blog_url=$res['blog_title']; 
       $blog_name = strtolower(str_replace(" ", "-", $blog_url)); ?>
        <section class="page-header">
            <div class="page-header__bg"></div>
            <div class="container-fluid">
                 <ul class="careox-breadcrumb list-unstyled">
                    <li><a href="https://tjra.in/index.php">Home</a></li>
                    <li><span>Blog</span></li>
                    <li><span><?= $res['blog_title']; ?></span></li>
                </ul>
            </div>
        </section>

        <section class="blog-details">
            <div class="container-fluid">
                <div class="row gutter-y-60">
                    <div class="col-lg-8">
                        <div class="blog-details__content">
                            <div class="blog-details__image">
                                <img src="https://tjra.in/admin-jurep/images/blog/<?= $res['blog_image']; ?>" alt="">
                            </div>
                            <ul class="list-unstyled blog-details__top-meta">
                                <li><a href="blog-detail.php"><img src="https://tjra.in/assets/images/blog/blog-author-1-1.jpg" alt=""><?= $res['blog_postby']; ?></a></li>
                                <li><i class="icofont-comment"></i>Comment</li>
                                <li><i class="icofont-ui-calendar"></i><?php  $date=$res['blog_date'];
                                                $newDate = date("d M Y", strtotime($date));
                                                echo $newDate; ?></li>
                            </ul> 
                            <h3 class="blog-details__title"><?= $res['blog_title']; ?></h3>
                            <p class="blog-details__text">
                               <?= $string = html_entity_decode($res['blod_desp']); ?>
                            </p>
                        </div>

                        <div class="comments-one">
                            <h3 class="comments-one__title"> Comments</h3>
                            <ul class="list-unstyled comments-one__list">
                                <?php $sql_cmt=mysqli_query($conn,"select * from blog_comment where blog_id='".$res['id']."'");
                                while($res_cmt=mysqli_fetch_array($sql_cmt)){ ?>
                                <li class="comments-one__card">
                                    <div class="comments-one__card__image">
                                        <img src="https://tjra.in/assets/images/blog/blog-comment-1-1.jpg" alt="">
                                    </div>
                                    <div class="comments-one__card__content">
                                        <h3 class="comments-one__card__title"><?= $res_cmt['name'];?><span class="comments-one__card__date"><?php $date=$res_cmt['blog_date'];
                                                $newDate = date("d M Y", strtotime($date));
                                                echo $newDate; ?></span></h3>
                                        <p class="comments-one__card__text"><?= $res_cmt['message'];?>
                                        </p> 
                                    </div>
                                </li>
                                <?php } ?>
                            </ul> 
                        </div>

                        <div class="comments-form">
                            <h3 class="comments-form__title">Leave a comment</h3><!-- /.comments-form__title -->
                            <form class="comments-form__form" method="post" action="">
                                <div class="form-one__group">
                                    <div class="form-one__control">
                                        <input type="text" name="cmname" placeholder="Your name" required> 
                                        <input type="hidden" name="bid" value="<?= $res['id'];?>"> 
                                    </div><!-- /.form-one__control -->
                                    <div class="form-one__control">
                                        <input type="email" name="cmemail" placeholder="Email address" required>
                                    </div><!-- /.form-one__control -->
                                    <div class="form-one__control form-one__control--full">
                                        <textarea name="cmmessage" placeholder="Write  a message"></textarea><!-- /# -->
                                    </div><!-- /.form-one__control -->
                                    <div class="form-one__control form-one__control--full">
                                        <button type="submit" name="submit_comment" class="careox-btn careox-btn--base"><span>Submit comment</span></button>
                                    </div><!-- /.form-one__control -->
                                </div><!-- /.form-one__group -->
                            </form>
                            <div class="result"></div>
                        </div><!-- /.comments-form -->
                    </div><!-- /.col-lg-8 -->
                    <div class="col-lg-4">
                        <div class="sidebar">
                            <aside class="widget-area">
                                 
                                <div class="sidebar__single">
                                    <h4 class="sidebar__title">Recent Post</h4> 
                                    <ul class="sidebar__posts list-unstyled">
                                        <?php $bg_id=$res['id'];
                                        $sql_bg=mysqli_query($conn,"select * from blog where id != '".$bg_id."'");
                                        while($resbg=mysqli_fetch_array($sql_bg)){
                                        $blog_url=$resbg['blog_title']; 
                                        $blog_name = strtolower(str_replace(" ", "-", $blog_url)); ?>
                                        <li class="sidebar__posts__item">
                                            <div class="sidebar__posts__image">
                                                <img src="https://tjra.in/admin-jurep/images/blog/<?= $resbg['blog_image']; ?>" alt="" style="height:70px">
                                            </div>
                                            <div class="sidebar__posts__content">
                                                <p class="sidebar__posts__meta"><i class="icofont-calendar"></i><?php $date=$resbg['blog_date'];
                                                    $newDate = date("d M Y", strtotime($date));
                                                    echo $newDate; ?></p><!-- /.sidebar__posts__date -->
                                                <h4 class="sidebar__posts__title"><a href="<?= "$blog_name"; ?>"><?= $resbg['blog_title']; ?></a></h4><!-- /.sidebar__posts__title -->
                                            </div><!-- /.sidebar__posts__content -->
                                        </li>
                                        <?php } ?>
                                        
                                    </ul><!-- /.sidebar__posts list-unstyled -->
                                </div>
                            </aside><!-- /.widget-area -->
                        </div><!-- /.sidebar -->
                    </div><!-- /.col-lg-4 -->
                </div><!-- /.row -->
            </div><!-- /.container -->
        </section>
        <?php include("footer.php");?>
        <?php include("js.php");?>
</body>

</html>