File manager

File manager - Edit - /home/custbahd/mediagepr.com/blog/single/index.php

Back
<?php session_start(); include_once('../../admin/articles/db/connection.php'); $article = $_GET['article']; if(isset($_POST['comment'])){ $blog_id = $_POST['blog_id']; $name = $_POST['name']; $email = $_POST['email']; $comments = $_POST['comments']; $rating = $_POST['rating']; $image = $_FILES['image']['name']; $target = "images/".basename($_FILES['image']['name']); $sql = "INSERT INTO comments (blog_id, name, email, comments, rating, image) VALUES ('$blog_id', '$name', '$email', '$comments', '$rating', '$image')"; if (move_uploaded_file($_FILES['image']['tmp_name'], $target)); //use for MySQLi OOP if($conn->query($sql)){ $_SESSION['success'] = 'Comment Submitted'; } /////////////// //use for MySQLi Procedural // if(mysqli_query($conn, $sql)){ // $_SESSION['success'] = 'Member added successfully'; // } ////////////// else{ $_SESSION['error'] = 'Failed to submit comment'; } } ?> <?php include_once("../../admin/articles/db/config.php"); //getting id from url $article = $_GET['article']; //selecting data associated with this particular id $result = mysqli_query($mysqli, "SELECT * FROM articles WHERE id=$article"); while($res = mysqli_fetch_array($result)) { $title = $res['title']; $topic = $res['topic']; $editor = $res['editor']; $source = $res['source']; $description1 = $res['description1']; $description2 = $res['description2']; $description3 = $res['description3']; $description4 = $res['description4']; $description5 = $res['description5']; $description6 = $res['description6']; $description7 = $res['description7']; $description8 = $res['description8']; $description9 = $res['description9']; $description10 = $res['description10']; $description11 = $res['description11']; $description12 = $res['description12']; $description13 = $res['description13']; $description14 = $res['description14']; $description15 = $res['description15']; $description16 = $res['description16']; $summ1 = $res['summ1']; $summ2 = $res['summ2']; $summ3 = $res['summ3']; $summ4 = $res['summ4']; $summ5 = $res['summ5']; $image1 = $res['image1']; $image2 = $res['image2']; $image3 = $res['image3']; $image4 = $res['image4']; $image5 = $res['image5']; $date = $res['date']; } ?> <?php //including the database connection file include_once("../../admin/articles/db/config.php"); //fetching data in descending order (lastest entry first) //$result = mysql_query("SELECT * FROM users ORDER BY id DESC"); // mysql_query is deprecated $result = mysqli_query($mysqli, "SELECT * FROM articles ORDER BY id ASC"); // using mysqli_query instead ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Single Blog \| Media Age PR ©</title> <!-- Social Share Data --> <meta content="text/html; charset=utf-8" name="Content-Type"> <meta property="og:title" content="Media Age PR ©"> <meta property="og:url" content="https://mediagepr.com/blog/grid"> <meta property="og:description" content="Experienced in Corporate & Brand Reputation Management, Marketing PR, with thorough knowledge of regional media, how it works and how to leverage media to get the best."> <meta property="og:image" content="https://mediagepr.com/images/img/banners/big.png"> <meta property="og:image:width" content="120"> <meta property="og:image:height" content="110"> <!-- Twitter Cards --> <meta name="twitter:card" content="summary_large_image"> <meta name="twitter:url" content="https://mediagepr.com/blog/grid"> <meta name="twitter:title" content="Blog \| Media Age PR ©"> <meta name="twitter:description" content="Experts in Corporate Brand & Reputation Management, Marketing PR, Regional Media, how it works and how to leverage media to get the best."> <meta name="twitter:image" content="https://mediagepr.com/images/img/banners/big.png"> <meta name="twitter:site" content="@MediagePr"> <meta name="twitter:creator" content="@MediagePr"> <meta name="description" content="Corporate Brand Reputation & Crisis Management"> <meta name="keywords" content="Blog Brand Reputation & Crisis Management"> <!-- responsive meta --> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- For IE --> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <!-- master stylesheet --> <link rel="stylesheet" href="../../css/style.css"> <!-- Responsive stylesheet --> <link rel="stylesheet" href="../../css/responsive.css"> <!-- Favicon --> <link rel="apple-touch-icon" sizes="180x180" href="../../images/img/logo1.png"> <link rel="icon" type="image/png" href="../../images/img/logo1.png" sizes="32x32"> <link rel="icon" type="image/png" href="../../images/img/logo1.png" sizes="16x16"> <style type="text/css"> .header-contact-info .text-holder a{ color: gray; } p.thp { margin-bottom: 10px !important; } /Background Overlay Black & White/ .background-overlay, .background-overlay-black, .background-overlay-white { position: relative; z-index: 2; background-position: center center; background-size: cover; } .background-overlay:before, .background-overlay-black:before, .background-overlay-white:before { position: absolute; z-index: -1; top: 0; left: 0; width: 100%; height: 100%; content: ""; } .background-overlay-black:before { background-color: rgba(0, 0, 0, 0.5); } .background-overlay-white:before { background-color: rgba(255, 255, 255, 0.6); } /Pop Up/ .openBtn { border: none; color: black; width: 100%; height: 100%; border-radius: 10px; font-size: 14px; cursor: pointer; transition: 2s; outline: none !important; box-shadow: 0 0 4px 0 rgba(255, 0, 0, 0.8); background: rgba(256, 250, 250, 0.8); } .openBtn:hover { color: #fff; background: rgba(255, 0, 0, 0.6); } .overlay { display: none; position: fixed; top: 0; left: 0; width: 100%; height: 100%; z-index: 9999999999; background: rgba(0, 0, 0, 0.4); } .overlay-content { position: relative; top: 40%; padding: 15px; border-radius: 10px; color: black; text-align: center; width: 80%; height: 300px; margin: auto; background-image: url(../../images/img/motion/17.gif); background-position: center; background-size: cover; box-shadow: 0 0 4px 0 rgba(255, 0, 0, 0.6); } .overlay-content p{ } .overlay h5 { font-weight: bold; text-align: center; padding: 10px; font-size: 16px; border-bottom: 1px solid red; cursor: pointer; color: red; z-index: 9; } .overlay h3 { text-align: center; margin-top: 20px; font-weight: bold; font-size: 14px; cursor: pointer; color: black; z-index: 9; } .closebtn { position: absolute; top: 0; right: 2%; font-size: 30px; font-weight: normal; text-align: center; cursor: pointer; color: red; outline: none; opacity: 1; z-index: 9; } .close:hover { color: red; } .close i{ color: red; } .overlay i { font-weight: normal; color: red; } .overlay-content form { } .overlay-content form input { margin-top: 10px; padding: 5px; border: 1px solid red; border-radius: 5px; background: none; } .overlay-content form input[type=text] { float: left; width: 48%; } .overlay-content form input[type=text]:nth-child(2) { margin-left: 4%; } .overlay-content form input[type=number] { margin-top: 20px; width: 100%; } .overlay-content form input[type=submit] { display: block; position: absolute; bottom: 30px; left: 20px; width: 40%; font-size: 15px; background: red; color: white; } .overlay-content button{ display: block; position: absolute; bottom: 30px; right: 20px; font-size: 15px; color: #FEFAFA; width: 40%; padding: 5px; border-radius: 5px; border: none; outline: none; cursor: pointer; background: black; } /* If the screen size is 601px wide or more, set the font-size of <div> to 80px / @media screen and (min-width: 601px) { .overlay-content { top: 40%; width: 30%; height: 300px; } } /Overlay Background Overlay/ .overlay-background-overlay-white { position: relative; z-index: 2; background-position: center center; background-size: cover; } .overlay-background-overlay-white:before { position: absolute; z-index: -1; top: 0; left: 0; width: 100%; height: 100%; content: ""; border-radius: 10px; } .overlay-background-overlay-white:before { background-color: rgba(255, 255, 255, 0.8); } / If the screen size is 601px wide or more, set the font-size of <div> to 80px / @media screen and (min-width: 601px) { .overlay { top: 0; left: 0; } .openBtn img{ height: 300px; } } /Auto Pop Up/ .popup{ width: 420px; padding: 20px 30px; position: fixed; transform: translate(-50%,-50%); left: 50%; top: 50%; border-radius: 8px; font-family: "Poppins",sans-serif; display: none; text-align: center; z-index: 999; background-image: url(../../images/img/feature-work-3-large.jpg); background-position: center; background-size: cover; } .popup h2{ font-weight: bold; text-align: center; text-transform: uppercase; font-size: 16px; color: #E31E25; text-decoration: underline; } .popup p{ font-size: 14px; margin-top: 60px; line-height: 25px; text-align: left; } .popup a{ } .popup form { } .popup form input { margin-top: 10px; padding: 5px; border: 1px solid red; border-radius: 5px; background: none; } .popup form input[type=text] { float: left; width: 48%; } .popup form input[type=text]:nth-child(2) { margin-left: 4%; } .popup form input[type=email] { margin-top: 20px; width: 100%; } .popup form input[type=submit] { display: block; position: absolute; bottom: 120px; right: 30px; width: 40%; font-size: 15px; background: red; color: white; } .popup button{ display: block; position: absolute; bottom: 120px; left: 30px; font-size: 15px; color: #FEFAFA; width: 30%; padding: 5px; border-radius: 5px; border: none; outline: none; cursor: pointer; background: black; } / If the screen size is 601px wide or more, set the font-size of <div> to 80px / @media screen and (min-width: 601px) { .popup{ left: 82%; top: 76%; } .popup h2{ font-weight: bold; font-size: 18px; color: #E31E25; text-decoration: underline; } .popup form input[type=submit] { bottom: 90px; } .popup button{ bottom: 90px; } } / If the screen size is 600px wide or less, set the font-size of <div> to 30px / @media screen and (max-width: 600px) { .popup{ width: 300px; left: 57%; top: 60%; } } /Toggler/ [type="checkbox"]:checked, [type="checkbox"]:not(:checked){ position: absolute; left: -9999px; } .menu-icon:checked + label, .menu-icon:not(:checked) + label{ position: absolute; top: 26px; right: 5px; display: block; width: 30px; height: 30px; padding: 0; margin: 0; cursor: pointer; z-index: 10; } .menu-icon:checked + label:before, .menu-icon:not(:checked) + label:before{ position: absolute; content: ''; display: block; width: 30px; height: 20px; z-index: 20; top: 0; left: 0; border-top: 2px solid red; border-bottom: 2px solid red; transition: border-width 100ms 1500ms ease, top 100ms 1600ms cubic-bezier(0.23, 1, 0.32, 1), height 100ms 1600ms cubic-bezier(0.23, 1, 0.32, 1), background-color 200ms ease, transform 200ms cubic-bezier(0.23, 1, 0.32, 1); } .menu-icon:checked + label:after, .menu-icon:not(:checked) + label:after{ position: absolute; content: ''; display: block; width: 22px; height: 2px; z-index: 20; top: 10px; right: 4px; background-color: red; margin-top: -1px; transition: width 100ms 1750ms ease, right 100ms 1750ms ease, margin-top 100ms ease, transform 200ms cubic-bezier(0.23, 1, 0.32, 1); } .menu-icon:checked + label:before{ top: 10px; transform: rotate(45deg); height: 2px; background-color: red; border-width: 0; transition: border-width 100ms 340ms ease, top 100ms 300ms cubic-bezier(0.23, 1, 0.32, 1), height 100ms 300ms cubic-bezier(0.23, 1, 0.32, 1), background-color 200ms 500ms ease, transform 200ms 1700ms cubic-bezier(0.23, 1, 0.32, 1); } .menu-icon:checked + label:after{ width: 30px; margin-top: 0; right: 0; transform: rotate(-45deg); transition: width 100ms ease, right 100ms ease, margin-top 100ms 500ms ease, transform 200ms 1700ms cubic-bezier(0.23, 1, 0.32, 1); } /Navbar Icons/ .head-icons { position: absolute; right: 50px; top: 20px; width: 35px; height: 35px; padding: 5px; border: 1px solid red; border-radius: 100px; } .head-icons a{ color: red; font-size: 20px !important; } / If the screen size is 601px wide or more, set the font-size of <div> to 80px / @media screen and (min-width: 601px) { .head-icons { display: none; position: absolute; width: 10%; margin-left: 1035px; top: 70px; } } .breadcrumb-area { background-attachment: fixed; background-position: center; background-size: cover; } .breadcrumb-area h1{ color: white; text-transform: uppercase; font-size: 25px; } / If the screen size is 601px wide or more / @media screen and (min-width: 601px) { .breadcrumb-area { height: 400px; background-attachment: fixed; background-position: center; background-size: cover; } } .rating-form .field-label { color: gray !important; font-weight: bold !important; } /Radio/ .rating-form li { fill: rgb(242, 242, 242); } input[type="radio"] { position: absolute; opacity: 0; } input[type="radio"] + li { -webkit-transition: all 0.2s; transition: all 0.2s; } input + li { cursor: pointer; } input[class="super-happy"]:hover + li, input[class="super-happy"]:checked + li, input[class="super-happy"]:focus + li { fill: rgb(0, 109, 217); } input[class="happy"]:hover + li, input[class="happy"]:checked + li, input[class="happy"]:focus + li { fill: rgb(0, 204, 79); } input[class="neutral"]:hover + li, input[class="neutral"]:checked + li, input[class="neutral"]:focus + li { fill: rgb(232, 214, 0); } input[class="sad"]:hover + li, input[class="sad"]:checked + li, input[class="sad"]:focus + li { fill: rgb(229, 132, 0); } input[class="super-sad"]:hover + li, input[class="super-sad"]:checked + li, input[class="super-sad"]:focus + li { fill: rgb(239, 42, 16); } /Upload File/ .upload-btn-wrapper { position: relative; overflow: hidden; display: inline-block; } .btn { width: 100px; height: 100px; color: gray; background-color: white; border-radius: 100px; font-size: 20px; font-weight: bold; } .btn img{ width: 100%; border-radius: 100px; box-shadow: 0 0 4px 0 red; } .btn:hover { width: 80px; height: 80px; } .upload-btn-wrapper input[type=file] { font-size: 100px; position: absolute; left: 0; top: 0; opacity: 0; } </style> </head> <body> <div class="boxed_wrapper"> <!--Start Top bar area --> <section class="top-bar-area"> <div class="container"> <div class="row top-info-row"> <div class="col-md-4 col-sm-12 col-xs-12"> <div class="top-info"> <ul> <li><span class="icon-signs"></span>Commercial Plaza, Kampala Rd</li> </ul> </div> </div> <div class="col-md-4 col-sm-12 col-xs-12"> <div class="top-info"> <ul> <li><span class="icon-clock"></span>Open: Mon-Sat: 09.00 to 18.00</li> </ul> </div> </div> <div class="col-md-3 col-sm-12 col-xs-12"> <div class="top-info"> <ul> <li><span class="icon-email-filled-closed-envelope"></span> P.O Box 34821, Kampala (U)</li> </ul> </div> </div> <div class="col-md-1 col-sm-12 col-xs-12"> <div id="google_translate_element"></div> <script type="text/javascript"> function googleTranslateElementInit() { new google.translate.TranslateElement({ pageLanguage: 'en' }, 'google_translate_element'); } </script> </div> </div> <!--Start Responsive Top Info--> <div class="row top-info1"> <div class="top-info"> <span class="icon-signs"></span> <br> Commercial Plaza <br> Kampala Rd </div> <div class="top-info"> <span class="icon-clock"></span> <br> Open: Mon-Sat: <br> 09.00 to 18.00 </div> <div class="top-info"> <span class="icon-email-filled-closed-envelope"></span> <br> P.O Box 34821 <br> Kampala (U) </div> <div class="col-md-1 col-sm-12 col-xs-12"> <div id="google_translate_element"></div> <script type="text/javascript"> function googleTranslateElementInit() { new google.translate.TranslateElement({ pageLanguage: 'en' }, 'google_translate_element'); } </script> </div> </div> <!--End Responsive Top Info--> </div> </section> <!--End Top bar area --> <!--Start header area--> <header class="header-area"> <div class="container"> <div class="row"> <div class="col-lg-5 col-md-4 col-sm-12 col-xs-12"> <div class="logo"> <a href="../../"> <img src="../../images/img/logo5.png" alt="Media Age Logo"> </a> </div> </div> <div class="header-contact-row col-lg-5 col-md-6 col-sm-12 col-xs-12"> <div class="header-contact-info"> <ul> <li> <div class="iocn-holder"> <span class="icon-technology"></span> </div> <div class="text-holder thp"> <h6>Call Us</h6> <p class="thp"><a href="tel:+256414348728">+256 414 348 728</a></p> <p><a href="tel:+256414348721">+256 414 348 721</a></p> </div> </li> <li> <div class="iocn-holder"> <span class="icon-letter"></span> </div> <div class="text-holder"> <h6>Mail Us</h6> <p><a href="mailto:info@mediagepr.com">info@mediagepr.com</a></p> </div> </li> </ul> </div> </div> <div class="col-lg-2 col-md-2 col-sm-12 col-xs-12"> <div class="top-social-links" align="center"> <ul> <li><a href="https://facebook.com/MediageprEA"><i class="fa fa-facebook" aria-hidden="true"></i></a></li> <li><a href="https://www.twitter.com/MediagePR"><i class="fa fa-twitter" aria-hidden="true"></i></a></li> <li><a href="https://www.instagram.com/mediagepr"><i class="fa fa-instagram" aria-hidden="true"></i></a></li> <li><a href="https://www.linkedin.com/company/mediage-pr-ea"><i class="fa fa-linkedin" aria-hidden="true"></i></a></li> <li><a href="https://wa.me//+256755348728"><i class="fa fa-whatsapp" aria-hidden="true"></i></a></li> <li class="responsive-mail"><a href="mailto:info@mediagepr.com"><i class="fa fa-envelope" aria-hidden="true"></i></a></li> </ul> </div> </div> </div> </div> </header> <!--End header area--> <!--Start mainmenu area--> <section class="mainmenu-area stricky"> <div class="container"> <div class="mainmenu-bg"> <div class="row"> <div class="col-md-10 col-sm-12 col-xs-12"> <!--Start mainmenu--> <nav class="main-menu"> <div class="navbar-header"> <div type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse"> <input class="menu-icon" type="checkbox" id="menu-icon" name="menu-icon"/> <label for="menu-icon"></label> <div class="head-icons" align="center"> <a href="tel:+256755348728"><span class="fa fa-phone"></span></a> </div> </div> </div> <div class="navbar-collapse collapse clearfix"> <ul class="navigation clearfix"> <li class="home current"><a href="../../index.php"><span class="fa fa-home"></span></a></li> <li class="dropdown"><a href="../../pages/about">About us</a> <ul> <li><a href="../../pages/about">Company Overview</a></li> <li><a href="../../pages/team">Our Team</a></li> <li><a href="../../pages/partners">Our Partners</a></li> <li><a href="../../pages/faqs">FAQ's</a></li> <li><a href="../../pages/testimonials">Client Feedback</a></li> </ul> </li> <li class="dropdown"><a href="../../services">Our Services</a> <ul> <li><a href="../../services/reputation">Reputation Management</a></li> <li><a href="../../services/crisis">Crisis Management</a></li> <li><a href="../../services/brand">Brand Management</a></li> <li><a href="../../services/public/relations">Public Relations</a></li> <li><a href="../../services/media">Media Relations</a></li> <li><a href="../../services/media">Media Events</a></li> <li><a href="../../services/communications">Communications Strategies</a></li> <li><a href="../../services/public/affairs">Public Affairs</a></li> <li><a href="../../services/btl">BTL Communications</a></li> </ul> </li> <li><a href="../../blog/grid">Latest News</a> </li> <li><a href="../../pages/portfolio">Portfolio</a> </li> <li><a href="../../contact">Contact Us</a></li> </ul> </div> </nav> <!--End mainmenu--> </div> <div class="col-md-2 col-sm-12 col-xs-12"> <div class="free-consulation-button pull-right"> <a class="thm-btn bg-clr1" onclick="openConsult()">Consult Now</a> </div> </div> </div> </div> </div> </section> <!--End mainmenu area--> <!--Start Consult Pop Up--> <div id="consult" class="overlay"> <div class="overlay-content overlay-background-overlay-white"> <h5>Consult Us</h5> <h3> Let our professionals help you</h3> <form action="../../contact/contact/consult/index.php" method="post"> <input type="text" name="fname" placeholder="First Name"> <input type="text" name="lname" placeholder="Last Name"> <input type="number" name="phone" placeholder="Phone Number"> <input type="submit" name="submit" value="Submit"> </form> <button id="close" onclick="closeConsult()">No Thanks</button> </div> </div> <script> function openConsult() { document.getElementById("consult").style.display = "block"; } function closeConsult() { document.getElementById("consult").style.display = "none"; } </script> <!--End Consult Pop Up--> <!--Start breadcrumb area--> <section class="breadcrumb-area background-overlay-black" style="background-image: url(../../images/img/stock/services/10.jpg);"> <div class="container text-center"> <h1>Single Blog Post</h1> </div> </section> <!--End breadcrumb area--> <!--Start breadcrumb bottom area--> <section class="breadcrumb-botton-area"> <div class="container"> <div class="left pull-left"> <ul> <li><a href="../../index.php">Home</a></li> <li><i class="fa fa-angle-right" aria-hidden="true"></i></li> <li><a href="../../blog/grid">Blog</a></li> <li><i class="fa fa-angle-right" aria-hidden="true"></i></li> <li>Single Blog</li> </ul> </div> <div align="right"> <nav class="menu"> <input type="checkbox" href="#" class="menu-open" name="menu-open" id="menu-open" /> <label class="menu-open-button" for="menu-open"> <a><i class="fa fa-share-alt" aria-hidden="true"></i></a> </label> <a target="_blank" href="https://www.facebook.com/sharer.php?u=https://mediagepr.com/blog/single/?article=<?php echo $article;?>" title="Blogs \| Media Age ©" class="menu-item blue-share"> <i class="fa fa-facebook"></i> </a> <a target="_blank" href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fmediagepr.com%2Fblog%2Fgrid%2Fsingle%2F?article=<?php echo $article;?>&text=Media+Age+Blogs+and+Latest+News.+ Check our latest blogs & articles. They may be highly valuable to you or your brand &hashtags=reputation,management,crisis,media,relations,events,corporate,public,affairs,mediagepr" class="menu-item lightblue-share"> <i class="fa fa-twitter"></i> </a> <a target="_blank" href="https://plus.google.com/share?url=https://mediagepr.com/blog/single/?article=<?php echo $article;?>" title="Blogs \| Media Age ©" class="menu-item red-share"> <i class="fa fa-google-plus"></i> </a> <a target="_blank" href="https://www.linkedin.com/shareArticle?mini=true &url=https://mediagepr.com/blog/single/?article=<?php echo $article;?>" title="Blogs \| Media Age ©" class="menu-item dodgerblue-share"> <i class="fa fa-linkedin"></i> </a> <a href="mailto:?subject=Blogs \| Media Age © &body=Check out our latest blogs and articles. They may be highly valuable to you or your brand https://mediagepr.com/blog/single/?article=<?php echo $article;?> Thank You!" title="Articles \| Media Age ©" class="menu-item purple-share"> <i class="fa fa-envelope"></i> </a> <a target="_blank" href="whatsapp://send?text=Check out our latest blogs and articles. They may be highly valuable to you or your brand https://mediagepr.com/blog/single/?article=<?php echo $article;?>. Thank You!" title="Blogs \| Media Age ©" class="menu-item green-share"> <i class="fa fa-whatsapp"></i> </a> </nav> </div> </div> </section> <!--End breadcrumb bottom area--> <!--Start blog area--> <section id="blog-area" class="blog-single-area"> <div class="container"> <div class="row"> <div class="col-lg-9 col-md-8 col-sm-12 col-xs-12"> <div class="blog-post"> <div class="single-blog-post"> <div class="img-holder" align="center"> <?php echo "<img src='../../admin/articles/images/$image1' alt='$title'>";?> <div class="published-date"> <h3><?php echo date('jS M', strtotime($date));?></h3> </div> <span style="font-size: 12px;"><?php echo $summ1;?></span> </div> <div class="text-holder"> <h3 class="blog-title"><?php echo $title;?></h3> <div class="text"> <p><?php echo $description1;?></p> </div> <?php if ($image2) { echo " <div class='middle-content-box'> <div class='row'> <div class='col-md-12'> <div class='img-holder' align='center'> <img src='../../admin/articles/images/$image2' alt='$title'> <span style='font-size: 12px;'>$summ2</span> </div> <div class='text-box'> <p>$description2</p> </div> </div> </div> </div> ";} elseif ($image2=="") { echo " <div class='bottom-content-box'> <p>$description2</p> </div> ";} ?> <?php if ($image3) { echo " <div class='bottom-content-box'> <p>$description3</p> <p>$description4</p> <p>$description5</p> <p>$description6</p> <p>$description7</p> </div> <div class='middle-content-box'> <div class='row'> <div class='col-md-12'> <div class='img-holder' align='center'> <img src='../../admin/articles/images/$image3' alt='$title'> <span style='font-size: 12px;'>$summ3</span> </div> <div class='text-box'> <p>$description8</p> </div> </div> </div> </div> <div class='bottom-content-box'> <p>$description9</p> <p>$description10</p> <p>$description11</p> <p>$description12</p> <p>$description13</p> <p>$description14</p> <p>$description15</p> <p>$description16</p> </div> ";} elseif ($image3=="") { echo " <div class='bottom-content-box'> <p>$description3</p> <p>$description4</p> <p>$description5</p> <p>$description6</p> <p>$description7</p> <p>$description8</p> <p>$description9</p> <p>$description10</p> <p>$description11</p> <p>$description12</p> <p>$description13</p> <p>$description14</p> <p>$description15</p> <p>$description16</p> </div> ";} ?> <div class="meta-info clearfix"> <div class="left pull-left"> <ul class="post-info"> <li><span style="color: black;">By:</span> <?php echo $editor;?></li> <li><?php echo $source;?></li> <li><span style="color: black;">Topic:</span> <?php echo $topic;?></li> <li> <?php include_once('../../admin/articles/db/count_db.php'); // of college_data table $sql = "SELECT count() FROM comments INNER JOIN articles ON comments.blog_id=articles.id WHERE articles.id=$article AND comments.approve=1"; $result = $conn->query($sql); // Display data on web page while($row = mysqli_fetch_array($result)) { if ($row['count()']=='0') { echo "No Comments"; } elseif ($row['count()']=='1') { echo $row['count()']. " Comment"; } else { echo $row['count()']. " Comments"; } echo "<br />"; } ?> </li> <span class="post-social"> <li><a href="https://facebook.com/MediageprEA" target="_blank"><i class="fa fa-facebook" aria-hidden="true"></i></a></li> <li><a href="https://www.twitter.com/MediagePR" target="_blank"><i class="fa fa-twitter" aria-hidden="true"></i></a></li> <li><a href="https://www.instagram.com/mediagepr" target="_blank"><i class="fa fa-instagram" aria-hidden="true"></i></a></li> <li><a href="https://www.linkedin.com/company/mediage-pr-ea" target="_blank"><i class="fa fa-linkedin" aria-hidden="true"></i></a></li> <li><a href="https://wa.me/message/256755348728" target="_blank"><i class="fa fa-whatsapp" aria-hidden="true"></i></a></li> </span> </ul> </div> <div class="right pull-right"> <a class="post-share" href="https://twitter.com/share?url=https://mediagepr.com/blog/single/?article=<?php echo $article;?>&text=<?php echo $title;?>&hashtags=reputation,management,crisis,media,relations,events,corporate,public,affairs"><i class="fa fa-share-alt" aria-hidden="true"></i></a> </div> </div> </div> </div> <?php include_once('../../admin/articles/db/count_db.php'); // of college_data table $sql = "SELECT count() FROM comments INNER JOIN articles ON comments.blog_id=articles.id WHERE articles.id=$article AND comments.approve=1"; $result = $conn->query($sql); // Display data on web page while($row = mysqli_fetch_array($result)) { if ($row['count()']=='0') { echo ""; } elseif ($row['count()']=='1') { echo "<div class='comment-box'>"; echo "<div class='row'>"; echo "<div class='col-md-12'>"; echo "<div class='sec-title'>"; echo "<h3>Read Comment</h3>"; echo "<span class='border'></span>"; echo "</div>"; } else { echo "<div class='comment-box'>"; echo "<div class='row'>"; echo "<div class='col-md-12'>"; echo "<div class='sec-title'>"; echo "<h3>Read Comments</h3>"; echo "<span class='border'></span>"; echo "</div>"; } } // Close the connection $conn->close(); ?> <!--Start single comment box--> <?php //servername $servername = "localhost"; //username $username = "root"; //empty password $password = ""; //database is the database name $dbname = "mediage"; // Create connection by passing these connection parameters $conn = new mysqli($servername, $username, $password, $dbname); //sql query to display all student_address table based on student id using inner join $sql = "SELECT DISTINCT articles.id, comments.id, comments.blog_id, comments.name, comments.email, comments.comments, comments.rating, comments.image, comments.approve, comments.decline, comments.date FROM comments INNER JOIN articles ON comments.blog_id=articles.id WHERE articles.id=$article AND comments.approve=1"; $result = $conn->query($sql); //display data on web page while($row = mysqli_fetch_array($result)){ echo "<div class='single-comment-box'>"; echo "<div class='img-holder'>"; if ($row['image']) { echo "<img src='images/".$row['image']."'>";} elseif ($row['image']=="") { echo "<img src='images/default.png'>";} echo "</div>"; echo "<div class='text-holder'>"; echo "<div class='top'>"; echo "<div class='date pull-left'>"; echo "<h5>".$row['name']." \| <span style='color: gray;font-size: 12px;'>".date("M jS, Y", strtotime($row['date']))."</span></h5>"; echo "</div>"; echo "<div class='review-box pull-right'>"; if ($row['rating']=="1") { echo "<ul><li><i class='fa fa-star'></i></li></ul>"; } if ($row['rating']=="2") { echo "<ul><li><i class='fa fa-star'></i></li><li><i class='fa fa-star'></i></li></ul>"; } if ($row['rating']=="3") { echo "<ul><li><i class='fa fa-star'></i></li><li><i class='fa fa-star'></i></li><li><i class='fa fa-star'></i></li></ul>"; } if ($row['rating']=="4") { echo "<ul><li><i class='fa fa-star'></i></li><li><i class='fa fa-star'></i></li><li><i class='fa fa-star'></i></li><li><i class='fa fa-star'></i></li></ul>"; } if ($row['rating']=="5") { echo "<ul><li><i class='fa fa-star'></i></li><li><i class='fa fa-star'></i></li><li><i class='fa fa-star'></i></li><li><i class='fa fa-star'></i></li><li><i class='fa fa-star'></i></li></ul>"; } echo "</div>"; echo "</div>"; echo "<div class='text'>"; echo "<p>".$row['comments']."</p>"; echo "</div>"; echo "</div>"; echo "</div>"; } $conn->close(); ?> <!--End single comment box--> </div> </div> </div> <div class="add-comment-box"> <div class="sec-title"> <h3>Post <span style="color: red;">A</span> Comment</h3> <span class="border"></span> </div> <?php echo "<form class='rating-form' action='' enctype='multipart/form-data' method='post'>"; ?> <?php echo "<input type='hidden' name='blog_id' value='$article'>"; ?> <div class="add-rating-box"> <div class="field-label">Rate</div> <ul> <label for="super-happy"> <input type="radio" name="rating" class="super-happy" id="super-happy" value="1" /> <li> <a> <i class="fa fa-star"></i> </a> </li> </label> \| <label for="happy"> <input type="radio" name="rating" class="happy" id="happy" value="2" /> <li> <a> <i class="fa fa-star"></i> <i class="fa fa-star"></i> </a> </li> </label> \| <label for="neutral"> <input type="radio" name="rating" class="neutral" id="neutral" value="3" /> <li> <a> <i class="fa fa-star"></i> <i class="fa fa-star"></i> <i class="fa fa-star"></i> </a> </li> </label> \| <label for="sad"> <input type="radio" name="rating" class="sad" id="sad" value="4" /> <li> <a> <i class="fa fa-star"></i> <i class="fa fa-star"></i> <i class="fa fa-star"></i> <i class="fa fa-star"></i> </a> </li> </label> \| <label for="super-sad"> <input type="radio" name="rating" class="super-sad" id="super-sad" value="5" checked="checked" /> <li> <a> <i class="fa fa-star"></i> <i class="fa fa-star"></i> <i class="fa fa-star"></i> <i class="fa fa-star"></i> <i class="fa fa-star"></i> </a> </li> </label> </ul> </div> <div class="row"> <div class="col-md-12"> <div class="field-label">Add Your Picture</div> <div class="upload-btn-wrapper"> <div class="btn"> <img src="../../images/img/default.png"> </div> <input type="file" name="image" /> </div> <div class="row"> <div class="col-md-6"> <div class="field-label">Your Name</div> <input type="text" name="name" value="" placeholder="" required=""> </div> <div class="col-md-6"> <div class="field-label">Your Email</div> <input type="email" name="email" value="" placeholder="" required=""> </div> </div> <div class="row"> <div class="col-md-12"> <div class="field-label">Your Comment</div> <textarea name="comments" required></textarea> </div> </div> <div class="row"> <div class="col-md-12"> <button class="thm-btn bg-clr1" type="submit" name="comment">Comment</button> </div> </div> </div> </div> </form> </div> </div> </div> <!--Start sidebar Wrapper--> <div class="col-lg-3 col-md-4 col-sm-7 col-xs-12"> <div class="sidebar-wrapper"> <!--Start single sidebar--> <div class="single-sidebar"> <div class="sec-title"> <h3>Categories</h3> <span class="border"></span> </div> <ul class="categories clearfix"> <li><a href="../../services/reputation">Reputation Management</a></li> <li><a href="../../services/crisis">Crisis Management</a></li> <li><a href="../../services/brand">Brand Managemengt</a></li> <li><a href="../../services/public/relations">Public Relations</a></li> <li><a href="../../services/media/relations">Media Relations</a></li> <li><a href="../../services/media/events">Media Events</a></li> <li><a href="../../services/communications">Communications Strategies</a></li> <li><a href="../../services/public/affairs">Public Affairs</a></li> <li><a href="../../services/btl">BTL Communications</a></li> </ul> </div> <!--End single sidebar--> <!--Start single sidebar--> <div class="single-sidebar"> <div class="sec-title"> <h3>Recent News</h3> <span class="border"></span> </div> <ul class="recent-post"> <?php //including the database connection file include_once("../../admin/articles/db/config.php"); $result = mysqli_query($mysqli, "SELECT * FROM articles ORDER BY id DESC LIMIT 10"); //while($res = mysql_fetch_array($result)) { // mysql_fetch_array is deprecated, we need to use mysqli_fetch_array while($res = mysqli_fetch_array($result)) { echo "<li>"; echo "<div class='img-holder'>"; echo "<img src='../../admin/articles/images/".$res['image1']."' alt='$res[title]'>"; echo "</div>"; echo "<div class='title-holder'>"; echo "<a href=\"index.php?article=$res[id]\">"; echo "<h5 class='post-title'>".substr($res['title'], 0, 40)."..</h5>"; echo "</a>"; echo "<h6 class='post-date'> <i class='icon-calendar-with-spring-binder-and-date-blocks'></i> ".date("M jS, Y", strtotime($res['date']))." </h6>"; echo "</div>"; echo "</li>"; } ?> </ul> </div> <!--End single sidebar--> <!--Start single-sidebar--> <div class="single-sidebar popular-tag"> <div class="sec-title"> <h3>Tag Cloud</h3> <span class="border"></span> </div> <ul class="popular-tag"> <?php //including the database connection file include_once("../../admin/articles/db/config.php"); //fetching data in descending order (lastest entry first) //$result = mysql_query("SELECT * FROM users ORDER BY id DESC"); // mysql_query is deprecated $result = mysqli_query($mysqli, "SELECT * FROM articles ORDER BY id ASC LIMIT 6"); // using mysqli_query instead //while($res = mysql_fetch_array($result)) { // mysql_fetch_array is deprecated, we need to use mysqli_fetch_array while($res = mysqli_fetch_array($result)) { echo "<li>"; echo "<a href=\"../single/index.php?article=$res[id]\">".$res['topic']."</a>"; echo "</li>"; } ?> </ul> </div> <!--End single-sidebar--> <!--Start single-sidebar--> <div class="single-sidebar"> <div class="business-enquiry"> <h3 style="color: red;">Crisis <span style="color: gray;">&</span> reputation enquiries<span style="color: gray;">!</span></h3> <p>Send us an <a href="mailto:info@mediagepr.com">email</a> and we’ll get in touch shortly, or call our office helpline<br><a href="tel:+256414348728">+256 414 348 728</a></p> </div> </div> <!--End single-sidebar--> </div> </div> <!--End Sidebar Wrapper--> </div> </div> </section> <!--End blog area--> <!--Start footer area--> <footer class="footer-area" style="background-image:url(../../images/stock/7.jpeg);background-attachment: fixed;"> <div class="footer-top-area"> <div class="container"> <div class="row"> <div class="col-md-12"> <div class="footer-top-content"> <div class="title pull-left"> <h3>Over 20 years of experience, we ensure you always get the best.</h3> </div> <div class="button pull-right"> <a class="thm-btn bg-clr1" onclick="openConsult()">Book Consultation</a> </div> </div> </div> </div> </div> </div> <div class="container"> <div class="row"> <!--Start single footer widget--> <div class="col-lg-5 col-md-3 col-sm-6 col-xs-12"> <div class="single-footer-widget pd-bottom" align="center"> <div style="overflow-y: scroll;width:90%;height: 280px;border-radius: 8px;"> <a class="twitter-timeline" href="https://twitter.com/MediagePR?ref_src=twsrc%5Etfw">Tweets by MediagePR</a> <script async src="https://platform.twitter.com/widgets.js" charset="utf-8"></script> </div><br> <a href="../../social/twitter" style="color: white;">View Full Page</a> </div> </div> <!--End single footer widget--> <!--Start single footer widget--> <div class="col-lg-3 col-md-3 col-sm-6 col-xs-12"> <div class="single-footer-widget"> <div class="title"> <h3>Latest News</h3> </div> <ul class="latest-news-items"> <?php //including the database connection file include_once("../../admin/articles/db/config.php"); //fetching data in descending order (lastest entry first) //$result = mysql_query("SELECT * FROM users ORDER BY id DESC"); // mysql_query is deprecated $result = mysqli_query($mysqli, "SELECT * FROM articles ORDER BY id DESC LIMIT 3"); // using mysqli_query instead //while($res = mysql_fetch_array($result)) { // mysql_fetch_array is deprecated, we need to use mysqli_fetch_array while($res = mysqli_fetch_array($result)) { echo "<li>"; echo "<a href=\"../../blog/single/index.php?article=$res[id]\">".substr($res['title'], 0, 60)."</a>"; echo "<p>".date("M jS, Y", strtotime($res['date']))."</p>"; echo "</li>"; } ?> </ul> </div> </div> <!--End single footer widget--> <!--Start single footer widget--> <div class="col-lg-3 col-md-3 col-sm-6 col-xs-12"> <div class="single-footer-widget pd-top pd-left"> <div class="title"> <h3>Contact Us</h3> </div> <ul class="footer-contact-info"> <li> <div class="icon-holder"> <span class="icon-world"></span> </div> <div class="text-holder"> <p>Commercial Plaza, Kampala Rd<br> P.O Box 34821 Kampala (U)</p> </div> </li> <li> <div class="icon-holder"> <span class="icon-technology-1"></span> </div> <div class="text-holder"> <p><a href="tel:+256414348728">+256 414 348 728</a></p> <p><a href="tel:+256414348721">+256 414 348 721</a></p> </div> </li> <li> <div class="icon-holder"> <span class="icon-technology-1"></span> </div> <div class="text-holder"> <p><a href="tel:+256755348728">+256 755 348 728</a></p> </div> </li> <li> <div class="icon-holder"> <span class="icon-letter-1 bottom-envelop"></span> </div> <div class="text-holder"> <p><a href="mailto:info@mediagepr.com">info@mediagepr.com</a></p> </div> </li> </ul> <ul class="footer-social-links"> <li><a href="https://facebook.com/MediageprEA" target="_blank"><i class="fa fa-facebook" aria-hidden="true"></i></a></li> <li><a href="https://www.twitter.com/MediagePR" target="_blank"><i class="fa fa-twitter" aria-hidden="true"></i></a></li> <li><a href="https://www.instagram.com/mediagepr" target="_blank"><i class="fa fa-instagram" aria-hidden="true"></i></a></li> <li><a href="https://www.linkedin.com/company/mediage-pr-ea" target="_blank"><i class="fa fa-linkedin" aria-hidden="true"></i></a></li> <li><a href="https://wa.me/message/256755348728" target="_blank"><i class="fa fa-whatsapp" aria-hidden="true"></i></a></li> </ul> </div> </div> <!--End single footer widget--> </div> </div> </footer> <!--End footer area--> <!--Start footer bottom area--> <section class="footer-bottom-area"> <div class="container"> <div class="row"> <div class="col-md-12"> <div class="footer-bottom"> <div class="copyright-text pull-left"> <p>Media Age © <script>document.write(new Date().getFullYear());</script> Copyright. All Rights Reserved, Powered by <a href="https://customassistinc.com/" target="_blank">Custom Assist Inc.</a></p> </div> <div class="footer-menu pull-right"> <ul> <li><a href="../../pages/terms">Terms & Conditions</a></li> <li><a href="../../pages/privacy">Privacy Policies</a></li> </ul> </div> </div> </div> </div> </div> </section> <!--End footer bottom area--> <!--Scroll to top--> <div class="scroll-to-top scroll-to-target" data-target="html"><span class="fa fa-angle-up"></span></div> <!-- main jQuery --> <script src="../../js/jquery-1.11.1.min.js"></script> <!-- bootstrap --> <script src="../../js/bootstrap.min.js"></script> <!-- bx slider --> <script src="../../js/jquery.bxslider.min.js"></script> <!-- count to --> <script src="../../js/jquery.countTo.js"></script> <!-- owl carousel --> <script src="../../js/owl.carousel.min.js"></script> <!-- validate --> <script src="../../js/validation.js"></script> <!-- mixit up --> <script src="../../js/jquery.mixitup.min.js"></script> <!-- easing --> <script src="../../js/jquery.easing.min.js"></script> <!-- gmap helper --> <script src="../../https://maps.googleapis.com/maps/api/js?key=AIzaSyAHzPSV2jshbjI8fqnC_C4L08ffnj5EN3A"></script> <!--gmap script--> <script src="../../js/gmaps.js"></script> <script src="../../js/map-helper.js"></script> <!-- fancy box --> <script src="../../js/jquery.fancybox.pack.js"></script> <script src="../../js/jquery.appear.js"></script> <!-- isotope script--> <script src="../../js/isotope.js"></script> <script src="../../js/jquery.prettyPhoto.js"></script> <script src="../../js/jquery.bootstrap-touchspin.js"></script> <!-- jQuery timepicker js --> <script src="../../assets/timepicker/timePicker.js"></script> <!-- Bootstrap select picker js --> <script src="../../assets/bootstrap-sl-1.12.1/bootstrap-select.js"></script> <!-- Bootstrap bootstrap touchspin js --> <!-- jQuery ui js --> <script src="../../assets/jquery-ui-1.11.4/jquery-ui.js"></script> <!-- Language Switche --> <script src="../../assets/language-switcher/jquery.polyglot.language.switcher.js"></script> <!-- Html 5 light box script--> <script src="../../assets/html5lightbox/html5lightbox.js"></script> <!-- revolution slider js --> <script src="../../assets/revolution/js/jquery.themepunch.tools.min.js"></script> <script src="../../assets/revolution/js/jquery.themepunch.revolution.min.js"></script> <script src="../../assets/revolution/js/extensions/revolution.extension.actions.min.js"></script> <script src="../../assets/revolution/js/extensions/revolution.extension.carousel.min.js"></script> <script src="../../assets/revolution/js/extensions/revolution.extension.kenburn.min.js"></script> <script src="../../assets/revolution/js/extensions/revolution.extension.layeranimation.min.js"></script> <script src="../../assets/revolution/js/extensions/revolution.extension.migration.min.js"></script> <script src="../../assets/revolution/js/extensions/revolution.extension.navigation.min.js"></script> <script src="../../assets/revolution/js/extensions/revolution.extension.parallax.min.js"></script> <script src="../../assets/revolution/js/extensions/revolution.extension.slideanims.min.js"></script> <script src="../../assets/revolution/js/extensions/revolution.extension.video.min.js"></script> <!-- thm custom script --> <script src="../../js/custom.js"></script> </div> </body> </html>

| ver. 1.4 | Github | . | PHP 8.1.33 | Generation time: 2.34 | proxy | phpinfo | Settings