1#@!#!123s

: / home / diafrica / spre.dominicaninstitute.edu.ng /
Filename : blog-detail.php
back
<?php
include_once './includes/config.php';
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
?>

<?php
// gets the user IP Address
$ip_address = md5(
  $_SERVER['REMOTE_ADDR'] .
  $_SERVER['HTTP_USER_AGENT']
);

  $id = $_GET['id'];
  $check_ip = mysqli_query($con, "SELECT * FROM postviews WHERE post_id = {$id} AND ip_address='$ip_address'") or die(mysqli_error($con));
  
  if(mysqli_num_rows($check_ip) == 0)
  {
    $insertview = mysqli_query($con, "INSERT into postviews SET post_id = '$id', ip_address = '$ip_address'");
    $updateview = mysqli_query($con, "UPDATE blogs set views = views+1 WHERE id = '$id'");
  }
  $result = mysqli_query($con, "SELECT * FROM blogs WHERE id={$id}");
  $ro = mysqli_fetch_assoc($result);
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta property="og:title" content="<?php echo $ro['title'] ?>" />
    <meta property="og:type" content="article" />
    <meta property="og:image" content="<?php echo $ro['image'] ?>" />
    <meta property="og:url" content="https://graceworld.family/blog-detail" />
    <meta property="og:image:width" content="100" />
    <meta property="og:image:height" content="100" />
    <meta property="twitter:card" content="summary_large_image" />
    <meta property="twitter:image" content="<?php echo $ro['image'] ?>" />

    <?php
    if (isset($_GET['id'])) {
        $id = $_GET['id'];
        $result = mysqli_query($con, "SELECT * FROM blogs WHERE id={$id}");
        $row = mysqli_fetch_assoc($result);

    ?>
    <title><?php echo $row['title']." - GraceWorld Family";?></title>

    <?php 
}
?>
    <!-- Stylesheets -->
    <!-- bootstrap v3.3.6 css -->
    <link href="css/bootstrap.css" rel="stylesheet">
    <!-- font-awesome css -->
    <link href="css/font-awesome.css" rel="stylesheet">
    <!-- flaticon css -->
    <link href="css/flaticon.css" rel="stylesheet">
    <!-- factoryplus-icons css -->
    <link href="css/factoryplus-icons.css" rel="stylesheet">
    <!-- animate css -->
    <link href="css/animate.css" rel="stylesheet">
    <!-- owl.carousel css -->
    <link href="css/owl.css" rel="stylesheet">
    <!-- fancybox css -->
    <link href="css/jquery.fancybox.css" rel="stylesheet">
    <link href="css/hover.css" rel="stylesheet">
    <link href="css/frontend.css" rel="stylesheet">
    <link href="css/style.css" rel="stylesheet">
    <!-- switcher css -->
    <link href="css/switcher.css" rel="stylesheet">
     <link href="css/switcher/orangehome.css" rel="stylesheet">
    <link rel='stylesheet' id='factoryhub-color-switcher-css' href='css/switcher/default.css' />
    <!-- revolution slider css -->
    <link rel="stylesheet" type="text/css" href="css/revolution/settings.css">
    <link rel="stylesheet" type="text/css" href="css/revolution/layers.css">
    <link rel="stylesheet" type="text/css" href="css/revolution/navigation.css">

    <!--Favicon-->
    <link rel="shortcut icon" href="images/favicon.png" type="image/x-icon">
    <link rel="icon" href="images/favicon.png" type="image/x-icon">
    <!-- Responsive -->
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link href="css/responsive.css" rel="stylesheet">
    
</head>

<body class="home header-sticky header-v3 hide-topbar-mobile">
    <div id="page">



<?php 
      include_once './includes/header.php';
?>

<?php
    if (isset($_GET['id'])) {
        $id = $_GET['id'];
        $result = mysqli_query($con, "SELECT * FROM blogs WHERE id={$id}");
        $row = mysqli_fetch_assoc($result);

    ?> 

        <!--Page Header-->
        <div class="page-header title-area">
           
            <div class="breadcrumb-area">
                <div class="container">
                    <div class="row">
                        <div class="col-md-8 col-sm-12 col-xs-12 site-breadcrumb">
                            <nav class="breadcrumb">
                                <a class="home" href="./"><span>Home</span></a>
                                <i class="fa fa-angle-right" aria-hidden="true"></i>
                                <?php echo "<span>" . $row['title'] . "</span>";?>
                            </nav>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!--Page Header end-->

        <!--blog page sec-->
        <section class="blogpage single-post blog-classic  secpadd">
            <div class="container">
                <div class="row">
                    <div class="col-md-8">

                        
                        <div class='hentry'>
                            
                            <header class='entry-header'>
                               <?php
                                    echo "
                                <div class=''>
                                    <img src=\"{$row['image']}\" style='height:300px'>
                                    
                                </div>

                                
                                <!-- .entry-meta -->
                                <h6>&nbsp;<font color='red'>By:</font> " . $row['author'] . " || <font color='red'>On:</font> " . $row['date'] . " || <font color='red'>Views:</font> " . $row['views'] . "</h6>

                                <h2>&nbsp;" . $row['title'] . "</h2>

                            </header>
                            <!-- .entry-header -->

                            <div class='entry-content'>
                                <p>" . $row['text'] . "</p>
                            </div>

                            <!-- .entry-content -->

                        
                            <!-- .entry-footer -->
                        </div>



                        ";
                        ?>
                            <div class="share">
                                            <span><font color="red">Share:</font> </span>
                                            <a style"color=blue" class="w-inline-block social-share-btn fb"
                                            href="http://www.facebook.com/sharer.php?u=https://graceworld.family/blog-detail?id=<?php echo $id ?>" target="_blank" title="Share on Facebook">
                                                        <i class="fa fa-facebook"></i>
                                                </a>
                                                &nbsp;
                                            <a class="w-inline-block social-share-btn tw"
                                                        href="https://twitter.com/intent/tweet?" target="_blank"
                                                        title="Tweet"
                                                        onclick="window.open('https://twitter.com/intent/tweet?text=' + encodeURIComponent(document.title) + ':%20 ' + encodeURIComponent(document.URL)); return false;">
                                                    <i class="fa fa-twitter"></i>
                                            </a>
                                            &nbsp;
                                            <a class="w-inline-block social-share-btn lnk"
                                                        href="https://www.linkedin.com/sharing/share-offsite/?url=https://graceworld.family/blog"
                                                        target="_blank" title="Share on LinkedIn">
                                                        <i class="fa fa-linkedin"></i>
                                            </a>
                                            &nbsp;
                                            <a class="w-inline-block social-share-btn wh"
                                            href="whatsapp://send?text= https://graceworld.family/blog-detail?id=<?php echo $id ?>"data-action="share/whatsapp/share"
                                                        target="_blank" title="Share on Whatsapp">
                                                    <i class="fa fa-whatsapp"></i>
                                            </a>
                                        </div>




          
                  
                  <div class="fh-section-title clearfix  text-left version-dark paddbtm40">
                            
                           
                            <h4>Comments <font color="green">(<?php $sql="SELECT count(*) as total from blogcomments where postid='$id'";
$result=mysqli_query($con,$sql);
$data=mysqli_fetch_assoc($result);
echo $data['total']; ?>)</font></h4>
                             
                        </div>

         <?php
$dio = mysqli_query($con, "SELECT * FROM blogcomments where postid='$id' order by id desc");
$row_dio = mysqli_fetch_assoc($dio);
$totalRows_dio = mysqli_num_rows($dio);
?>
 <?php if ($totalRows_dio>0) {
                        do {
        ?>                 
                <?php echo $row_dio['comment']; ?><br>
                <font face="candara"><small><i class="fa fa-user"></i> <?php echo $row_dio['name']; ?> <i class="fa fa-clock-o"></i> <?php echo $row_dio['dater']; ?></small></font>
                <hr style="border: 1px orange solid;">
                <?php  } 
        while ($row_dio = mysqli_fetch_assoc($dio)); 
        ?>
      
      <?php }
      ?>


    <?php 
if(isset($_POST['addcomment'])){
         
         $comment = str_replace("'", "''", $_POST['comment']);
         $name = str_replace("'", "''", $_POST['name']);
         $dater = date("m/d/Y h:i:s a", time());

 $query = mysqli_query($con,"INSERT into blogcomments (postid,comment,name,dater) VALUES ('$id','$comment','$name','$dater')")
     or die(mysqli_error($con));
      if($query)
             {
                   echo "<div class='alert alert-success'> Submitted successfully! Refresh <a href=''>HERE</a></div>";
  }
      
    else
  {
                  echo "<div class='alert alert-danger'> An error occured, please try again! </div>";
  }
  }

?>    
        

                        <form action="<?php echo $editFormAction; ?>" method="POST">
                            <div class="fh-form request-form">
                                <div class="row">
                                    
                                     <div class="field col-md-12">
                                        <textarea name="comment" placeholder="Type your Comment" required style="border:1px green solid;"></textarea>
                                    </div>

                                    <div class="field col-md-12">
                                        <input name="name" placeholder="Your Name" type="text" style="border:1px green solid;">
                                    </div>

                                   
                                </div>

                                 <div class="row">
                                      <div class="col-md-2">
                                        <br>
                                        <input name="addcomment" value="Submit" class="fh-btn" type="submit">
                                    </div>

                                </div>
                                
                               
                              

                            </div>
                        </form>
            </div>
<?php
}
?>

  



                    <div class="col-md-4">
                        <?php include_once 'includes/sidebar.php';?>
                    </div>



                </div>
            </div>
        </section>
        <!--blog page end-->

   <?php 
        include_once 'includes/footer.php';
        ?>
    </div>
    <!--End pagewrapper-->

   <?php
   include_once 'includes/mobile-menu.php'; 
   ?>
    <div id="off-canvas-layer" class="off-canvas-layer"></div>
    <!--primary-mobile-nav end-->

    <!--Scroll to top-->
    <a id="scroll-top" class="backtotop" href="#page-top"><i class="fa fa-angle-up"></i></a>

    <!-- jquery Liabrary -->
    <script src="js/jquery-1.12.4.min.js"></script>
    <!-- bootstrap v3.3.6 js -->
    <script src="js/bootstrap.min.js"></script>
    <!-- fancybox js -->
    <script src="js/jquery.fancybox.pack.js"></script>
    <script src="js/jquery.fancybox-media.js"></script>
    <script src="../../../unpkg.com/isotope-layout%403.0.6/dist/isotope.pkgd.min.js"></script>
    <!-- owl.carousel js -->
    <script src="js/owl.js"></script>
    <!-- counter js -->
    <script src="js/jquery.appear.js"></script>
    <script src="js/jquery.countTo.js"></script>
    <!-- validate js -->
    <script src="js/validate.js"></script>
    <!-- switcher js -->
    <script src="js/switcher.js"></script>

    <!-- google map -->
    <script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyAHzPSV2jshbjI8fqnC_C4L08ffnj5EN3A"></script>
    <script src="js/gmap.js"></script>
    <script src="js/map-helper.js"></script>

    <!-- REVOLUTION JS FILES -->
    <script type="text/javascript" src="js/revolution/jquery.themepunch.tools.min.js"></script>
    <script type="text/javascript" src="js/revolution/jquery.themepunch.revolution.min.js"></script>
    <script type="text/javascript" src="js/revolution/extensions/revolution.extension.actions.min.js"></script>
    <script type="text/javascript" src="js/revolution/extensions/revolution.extension.carousel.min.js"></script>
    <script type="text/javascript" src="js/revolution/extensions/revolution.extension.kenburn.min.js"></script>
    <script type="text/javascript" src="js/revolution/extensions/revolution.extension.layeranimation.min.js"></script>
    <script type="text/javascript" src="js/revolution/extensions/revolution.extension.migration.min.js"></script>
    <script type="text/javascript" src="js/revolution/extensions/revolution.extension.navigation.min.js"></script>
    <script type="text/javascript" src="js/revolution/extensions/revolution.extension.parallax.min.js"></script>
    <script type="text/javascript" src="js/revolution/extensions/revolution.extension.slideanims.min.js"></script>
    <script type="text/javascript" src="js/revolution/extensions/revolution.extension.video.min.js"></script>

    <!-- script JS  -->
    <script src="js/scripts.min.js"></script>
    <script src="js/script.js"></script>
</body>
</html>