gistfile1.txt

<?php
$con=mysqli_connect("##########","blogthorbis","##########","blogthorbis");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
date_default_timezone_set('America/New_York');
?>
<?php
$self = $_SERVER['PHP_SELF'];
if ($Res = mysqli_query($con,'SELECT * FROM `PublicBlog` ORDER BY `Date` DESC')) { 
    while($Row = $Res->fetch_object()) {
$blogtopic = $Row->BlogTopic;
$dateword = $Row->DateWordForm;
$blogurl = $Row->BlogURL;  
$upload_location = $Row->upload_location;
$date = $Row->Date; 
$p = $Row->BlogP;
$ext = $Row->filetype;
$title = $p;
if (strlen($title)>200){
$rtitle = substr($title,0,200)."...";
}else {
$rtitle = $title;
}
echo '
<li class="show">
<div class="spacer1"></div>
  <div class="blogbackground background-style3">
		<div class="row">
			<article class="thinner">
					<section>
						<div class="12u">';
							if($ext == 'image/jpeg' || $ext == 'image/jpg' || $ext == 'image/png' || $ext == 'image/gif'){echo '<a data-lightbox="image-1" href="'.$Row->upload_location.'"><img class="floatright blogimage" src="'.$Row->upload_location.'"></img></a>';}
							elseif($ext == 'audio/mp3' || $ext == 'audio/ogg'){echo '<audio controls class="floatright blogmusic" src="'.$Row->upload_location.'"></audio>';}
							elseif($ext == 'video/mp4' || $ext == 'audio/ogg'){echo '<video controls class="floatright blogvideo" src="'.$Row->upload_location.'"></video>';}
							 
							echo'
							<h1 class="blogh1">'.$Row->BlogTopic.'</h1>
							<i id="'.$Row->Date.'" class="blogdate">'.$Row->DateWordForm.'</i>
							<p class="blogp">'.$rtitle.'</p>
							<i class="blogurl"><a style="color:#2A5DB0; text-decoration:underline;" href="'.$Row->BlogURL.'">Read More</a></i>
							<form action="'.$self.'" method="post">
							<i class="blogurl"><input id="Submit" type="Submit" value="Submit" class="mybutton Submit" style="color:#2A5DB0; text-decoration:underline;">Report Post</input></i>
							</form>
						</div>
					</section>			
			</article>
		</div>
	</div>
</li>
 
';
if (isset($_POST['Submit'])) {
   mail('bcw1995@gmail.com',  'New Public Blog Post | Byron Wade', $blogurl);
}
	}
}
mysqli_close($con);
?>