Online PHP editor | output for XB3CT

<?php ini_set('display_errors', 'On'); error_reporting(E_ALL); $time = microtime(); $time = explode(' ', $time); $time = $time[1] + $time[0]; $starttime = $time; session_start(); require 'connect.php'; require 'functions.php'; // Connect to MySQLi $sqli = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME) or die("Error: ".mysqli_error($sqli)); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } if (isset($_GET['id']) && is_numeric($_GET['id']) ) { $id = mysqli_real_escape_string($sqli, $_GET['id']); $query = mysqli_query($sqli, "SELECT * FROM blog WHERE id='$id'") or die("Error: ".mysqli_error($sqli)); $checknumblogs = mysqli_num_rows($query); if($checknumblogs == 0) { $noBlogPostsFound = TRUE; } else { $row = mysqli_fetch_assoc($query); $headline = $row['headline']; $story = $row['story']; $timestamp = $row['timestamp']; $userid = $row['userid']; $userquery = mysqli_query($sqli, "SELECT * FROM members WHERE id='$userid'") or die("Error: ".mysqli_error($sqli)); $userexists = mysqli_num_rows($userquery); if ($userexists == 0) { $username = "<deleted user>"; } else { $userrow = mysqli_fetch_assoc($userquery); $username = $userrow['username']; } } } else { if (!isset($_GET['page']) || !is_numeric($_GET['page']) || ($_GET['page'] < 0)) { $page = 0; } else { $page = (int)$_GET['page']; } $limit = 3; $postsperpage = $limit; $start = $page * $limit; $query = mysqli_query($sqli, "SELECT * FROM blog ORDER BY timestamp DESC LIMIT $start, $limit") or die("Error: ".mysqli_error($sqli)); $checknumblogs = mysqli_num_rows($query); // Check if any blog posts exists if($checknumblogs == 0) { $noBlogPostsFound = TRUE; } else { $blogposts = array(); while ($row = mysqli_fetch_array($query)) { $userid = $row['userid']; $userquery = mysqli_query($sqli, "SELECT * FROM members WHERE id='$userid'") or die("Error: ".mysqli_error($sqli)); $userexists = mysqli_num_rows($userquery); if ($userexists == 0) { $username = "<deleted user>"; } else { $userrow = mysqli_fetch_assoc($userquery); $username = $userrow['username']; } $blogposts[] = array( "id" => $row['id'], "headline" => $row['headline'], "story" => $row['story'], "timestamp" => $row['timestamp'], "userid" => $row['userid'], "username" => $username ); } } $totalquery = mysqli_query($sqli, "SELECT * FROM blog") or die("Error: ".mysqli_error($sqli)); $totalblogposts = mysqli_num_rows($totalquery); } //FORUMS $limit = 5; $forumquery = mysqli_query($sqli, "SELECT * FROM forumtopics ORDER BY lastpost DESC LIMIT 0, $limit") or die("Error: ".mysqli_error($sqli)); $forumposts = array(); while ($row = mysqli_fetch_array($forumquery)) { $uid = $row['lastpostuserid']; $userquery = mysqli_query($sqli, "SELECT * FROM members WHERE id='$uid'") or die("Error: ".mysqli_error($sqli)); $userexists = mysqli_num_rows($userquery); if ($userexists == 0) { $username = "<deleted user>"; } else { $userrow = mysqli_fetch_assoc($userquery); $username = $userrow['username']; } $forumposts[] = array( "id" => $row['id'], "threadname" => $row['threadname'], "text" => $row['text'], "lastpost" => $row['lastpost'], "userid" => $row['userid'], "username" => $username, "categoryid" => $row['categoryid'] ); } //EVENT $limit = 1; $eventquery = mysqli_query($sqli, "SELECT * FROM events ORDER BY id DESC LIMIT 0, $limit") or die("Error: ".mysqli_error($sqli)); $events = array(); $counter = 0; while ($row = mysqli_fetch_array($eventquery)) { $events[] = array( "id" => $row['id'], "name" => $row['name'], "timestamp" => $row['timestamp'], "picturethumbnail" => $row['picturethumbnail'] ); } //TOPINFOTEXT $textquery = mysqli_query($sqli, "SELECT * FROM toptext ORDER BY id") or die("Error: ".mysqli_error($sqli)); $textresult = mysqli_fetch_assoc($textquery); ?> <html> <head> <meta http-equiv="Content-Type" content="text/html;charset=UTF-8" /> <title>indiehjaerta.com ♥</title> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>  <link href='http://fonts.googleapis.com/css?family=Oswald:400,300' rel='stylesheet' type='text/css'> <link href='http://fonts.googleapis.com/css?family=Open+Sans:300italic,300,400' rel='stylesheet' type='text/css'> <link href='http://fonts.googleapis.com/css?family=Roboto:300,300italic' rel='stylesheet' type='text/css'> <link href="stylesheet/style.css" rel="stylesheet" type="text/css" /> <link href="stylesheet/blog.css" rel="stylesheet" type="text/css" /> </head> <body> <script type="text/javascript"> $(function() { $('#TopBarLogin').click(function() { $('#LoginPopUp').show(); return false; }); }); </script> <script type="text/javascript"> $(document).mouseup(function (e) { var container = $("#LoginPopUp"); if (!container.is(e.target) && container.has(e.target).length === 0) { container.hide(); } }); </script> <script type="text/javascript"> $(function() { if (navigator.userAgent.toLowerCase().indexOf("chrome") >= 0) { var intervalId = 0; $(window).load(function() { intervalId = setInterval(function () { // << somehow this does the trick! if ($('input:-webkit-autofill').length > 0) { clearInterval(intervalId); $('input:-webkit-autofill').each(function () { var text = $(this).val(); var name = $(this).attr('name'); $(this).after(this.outerHTML).remove(); $('input[name=' + name + ']').val(text); }); } }, 1); }); } }); </script> <div id="TopBarImageContainer"> <div id="TopBarImage"></div> </div> <div id="MainContent"> <a href="#"> <span class="DivLink"> <div id="TopBarLogin"> <span class="TopBarText">LOGIN <div id="TopBarTriangleDown"></div> </span> </div> </span> </a> <a href="register.php"> <span class="DivLink"> <div id="TopBarCreateAccount"> <span class="TopBarText">CREATE AN ACCOUNT</span> </div> </span> </a> <div id="TopBarUserMenu"> <div id="TopBarUserMenuProfile"> <a href="profile.php"> <span class="TopBarText"> <div id="TopBarUserMenuProfileImage"></div> <span class="DivLink"> PROFILE </span> </span> </a> </div> <div id="TopBarUserMenuMessages"> <a href="messages.php"> <span class="TopBarText"> <div id="TopBarUserMenuMessagesImage"></div> <span class="DivLink"> MESSAGES </span> </span> </a> </div> <div id="TopBarUserMenuSupport"> <a href="support.php"> <span class="TopBarText"> <div id="TopBarUserMenuSupportImage"></div> <span class="DivLink"> SUPPORT </span> </span> </a> </div> </div> <div id="LoginPopUp"> <form method="post" action=""> <input name="username" type="text" id="username" placeholder="Username" style="display: none" /> <input name="password" type="password" id="password" placeholder="Password" style="display: none" /> <input class="TopLoginInput" name="username" type="text" id="username" placeholder="Username" /><br /> <input class="TopLoginInput" name="password" type="password" id="password" placeholder="Password" /><br /> <input class="TopLoginButton" type="submit" name="login" value=""> </form> </div> <div id="LogoMenu"> <div id="SocialTopLinks"> <div id="SocialTopTwitterLink"> <a href="http://www.twitter.com/indiehjaerta"> <span class="DivLink"></span> </a> </div> <div id="SocialTopFacebookLink"> <a href="http://www.facebook.com/indiehjaerta"> <span class="DivLink"></span> </a> </div> <div id="SocialTopYouTubeLink"> <a href="https://www.youtube.com/indiehjaerta"> <span class="DivLink"></span> </a> </div> <div id="SocialTopInstagramLink"> <a href="http://www.instagram.com/indiehjaerta"> <span class="DivLink"></span> </a> </div> <div id="SocialTopTwitchLink"> <a href="http://www.twitch.tv/indiehjaerta"> <span class="DivLink"></span> </a> </div> </div> <div id="TopLogo"> <a href="default.php"><span class="DivLink"></span></a> </div> <div id="MenuLinkSeparator"></div> <div id="MenuLinks"> <a href="default.php" class="Menu">HOME</a>          <a href="about.php" class="Menu">ABOUT</a>         <a href="blog.php" class="Menu">BLOG</a>          <a href="events.php" class="Menu">EVENTS</a>          <a href="forums.php" class="Menu">FORUMS</a>         <a href="contact.php" class="Menu">CONTACT</a> </div> </div> <div id="Container"> <div id="InfoHeader"> <span class="TopInfoText"><?php echo $textresult['text']?></span> </div> <div id="Content"> <div id="BlogContent"> <?php //WRITE OUT IF NO BLOG POSTS FOUND! if (isset($_GET['id']) && is_numeric($_GET['id']) ) { ?> <span class="BlogPostHeadlineSingle"><?php echo strtoupper($headline) ?></span><br /> <span class="BlogPostInfoSingle">posted by <a href="profile.php?id=<?php echo $userid ?>"><?php echo $username ?></a> at <?php echo $timestamp ?></span><br /><br /> <div id="BlogContentTextSingle"> <span class="BlogPostTextSingle"><?php echo $story ?></span><br /> </div> <img src="images/separator-horizontal-long.png" id="SeparatorHorizontal1100" /><br /> <span class="BlogComments">Comments:</span> <?php } else { if (isset($noBlogPostsFound) && $noBlogPostsFound == TRUE) { echo '<span class="BlogPostHeadlineList">NO BLOG POSTS FOUND<br /> IF YOU THINK YOU\'VE REACHED THIS PAGE BY ACCIDENT CONTACT WEBMASTER</span>' } else { $counter = 0; foreach ($blogposts as $post) { $counter++; ?> <a href="?id=<?php echo $post['id'] ?>" class="BlogPostHeadlineList"><?php echo strtoupper($post['headline']) ?></a><br /> <span class="BlogPostInfoList">posted by <a href="profile.php?id=<?php echo $post['userid'] ?>"><?php echo $post['username'] ?></a> at <?php echo $post['timestamp'] ?></span><br /> <div id="BlogContentText"> <span class="BlogPostTextList"><?php echo rtrim(tokenTruncate($post['story'], 550)); if (strlen($post['story']) > 550) { echo '...'; } ?></span><br /> </div> <div class="BlogButtonContainer"> <?php if (strlen($post['story']) > 550) { ?> <a href="<?php echo $_SERVER['PHP_SELF'].'?id='.$post['id'] ?>"><img src="images/buttonreadmore.png" class="ButtonReadMore" /></a> <?php } ?> <a href="<?php echo $_SERVER['PHP_SELF'].'?id='.$post['id']. '#comments' ?>"><img src="images/buttoncomments.png" class="ButtonComment" /></a> </div> <?php if ($counter < $postsperpage) { ?> <img src="images/separator-horizontal-long.png" id="SeparatorHorizontal1100" /><br /> <?php } } ?> </div> <div id="BlogLinks"> <span class="BlogNavigationLink"> <?php if ($page > 0) { $prev = $start - $limit; echo '<a href="'.$_SERVER['PHP_SELF'].'?page='.$prev.'" class="BlogNavigationLink">« Newer posts</a> '; } else { echo '« Newer posts '; } $maxpages = floor($totalblogposts/$postsperpage); echo '<span class="BlogNavigationLink">'; for ($i = 0; $i <= $maxpages; $i++) { if ($page != $i) { echo '<a href="'.$_SERVER['PHP_SELF'].'?page='.$i.'" class="BlogNavigationLink">' .($i+1). '</a> '; } else { echo $i+1; } } echo '</span>'; if ($page < $maxpages) { $nextpage = $page+1; echo ' <a href="'.$_SERVER['PHP_SELF'].'?page='.$nextpage.'" class="BlogNavigationLink">Older Posts »</a>'; } else { echo ' Older Posts »'; } } } ?> </span> </div> </div> <div id="NewsLetterBanner"> </div> <div id="SiteInfoContainer"> <div id="ForumPostsContainer"> <img src="images/icon-forum-large.png" class="ForumPostsIcon" /> <span class="ForumPostsText">FORUM POSTS</span><br /> <?php $counter = 0; foreach ($forumposts as $posts) { $counter++; $dateandtime = getdate(strtotime($posts['lastpost'])); $min = $dateandtime['minutes']; $hr = $dateandtime['hours']; $d = $dateandtime['mday']; $m = $dateandtime['mon']; $y = $dateandtime['year']; $hr = str_pad($hr, 2, '0', STR_PAD_LEFT); $min = str_pad($min, 2, '0', STR_PAD_LEFT); $monthName = date("F", mktime(0, 0, 0, $m, 10)); $ordinaldate = ordinal($d); ?> <div class="ForumPostContainer"> <a href="forums.php?fid=<?php echo $posts['categoryid'] ?>&tid=<?php echo $posts['id'] ?>" class="FrontpageForumLink"><?php echo $posts['threadname'] ?></a> <span class="ForumPostInfo"> <?php echo 'posted by <a href="profile.php?id=' .$posts['userid']. '">' .$posts['username']. '</a> at ' .$hr. ':' .$min. ' on ' .$monthName. ' ' .$ordinaldate. ', ' .$y; ?> </span> </div> <?php if ($counter != 5) { ?> <img src="images/forumpostsseparator.png" class="ForumPostsSeparator" /> <?php } } ?> </div> <img src="images/shortseparator2.png" class="ShortSeparator" /> <div id="EventContainer"> <img src="images/icon-calendar-large.png" class="EventsIcon" /> <span class="ForumPostsText">UPCOMING EVENT</span><br /> <?php foreach ($events as $event) { $dateandtime = getdate(strtotime($event['timestamp'])); $d = $dateandtime['mday']; $m = $dateandtime['mon']; $y = $dateandtime['year']; $d = str_pad($d, 2, '0', STR_PAD_LEFT); $m = str_pad($m, 2, '0', STR_PAD_LEFT); echo '<span class="EventDate">'.$y.'.'.$m.'.'.$d.'</span>'; echo '<span class="EventTitle">' .strtoupper($event['name']). '</span>'; if (strlen($event['picturethumbnail']) > 4) { echo '<img src="images/' .$event['picturethumbnail']. '" class="EventThumbnail" />'; } echo '<a href="events.php?id=' .$event['id']. '"><img src="images/buttonreadmoreevent.png" class="ButtonReadMoreEvent" /></a>'; } ?> </div> </div> </div> <div id="Bot"> <div class="BotLinkDiv"> <span class="BotLinkHeadline">LINK-TEXTS</span><br /> <a href="" class="BotLinkText">LINK1</a><br /> <a href="" class="BotLinkText">LINK2</a><br /> <a href="" class="BotLinkText">LINK3</a><br /> <a href="" class="BotLinkText">LINK4</a><br /> <a href="" class="BotLinkText">LINK5</a><br /> <a href="" class="BotLinkText">LINK6</a><br /> </div> <div class="BotLinkDiv"> <span class="BotLinkHeadline">LINK-TEXTS</span><br /> <a href="" class="BotLinkText">LINK1</a><br /> <a href="" class="BotLinkText">LINK2</a><br /> <a href="" class="BotLinkText">LINK3</a><br /> <a href="" class="BotLinkText">LINK4</a><br /> <a href="" class="BotLinkText">LINK5</a><br /> <a href="" class="BotLinkText">LINK6</a><br /> </div> <div class="BotLinkDiv"> <span class="BotLinkHeadline">ACCOUNT</span><br /> <a href="" class="BotLinkText">LOGIN</a><br /> <a href="" class="BotLinkText">CREATE ACCOUNT</a><br /> <a href="" class="BotLinkText">FORGOT PASSWORD</a><br /> <a href="" class="BotLinkText">PROFILE</a><br /> </div> <div class="BotLinkDiv"> <span class="BotLinkTextJoin">NOT A MEMBER?</span> <a href="register.php"><img src="images/buttonjoinnow.png" clas="BotButtonJoinNow" /></a> </div> <div class="BotLinkDiv"> <span class="BotLinkHeadline">SOCIAL</span><br /> <a href="http://www.twitch.tv/indiehjaerta" class="BotLinkText">TWITCH</a><br /> <a href="http://www.facebook.com/indiehjaerta" class="BotLinkText">FACEBOOK</a><br /> <a href="http://www.twitter.com/indiehjaerta" class="BotLinkText">TWITTER</a><br /> <a href="http://www.youtube.com/indiehjaerta" class="BotLinkText">YOUTUBE</a><br /> <a href="http://www.instagram.com/indiehjaerta" class="BotLinkText">INSTAGRAM</a><br /> </div> <div class="BotLinkDiv"> <span class="BotLinkHeadline">SUPPORT</span><br /> <a href="" class="BotLinkText">LINK1</a><br /> <a href="" class="BotLinkText">LINK2</a><br /> <a href="" class="BotLinkText">LINK3</a><br /> <a href="" class="BotLinkText">LINK4</a><br /> <a href="" class="BotLinkText">LINK5</a><br /> <a href="" class="BotLinkText">LINK6</a><br /> </div> <div id="BotLogo"> <a href="#"><span class="DivLink"></span></a> </div> <?php $time = microtime(); $time = explode(' ', $time); $time = $time[1] + $time[0]; $finish = $time; $total_time = round(($finish - $starttime), 4); ?> <span class="BotLogoText">Page generated in <?php echo $total_time ?> seconds.</span> </div> </div> </body> </html>