D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
diafrica
/
spre.dominicaninstitute.edu.ng
/
Filename :
blog-detail.php
back
Copy
<?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> <font color='red'>By:</font> " . $row['author'] . " || <font color='red'>On:</font> " . $row['date'] . " || <font color='red'>Views:</font> " . $row['views'] . "</h6> <h2> " . $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> <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> <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> <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>