FM / RIS

/home/gonqkt9zy6pk/public_html/RIS

Name	Size	Mode	Actions
admin/	-	0755	rm
cart/	-	0755	rm
cisum/	-	0755	rm
config/	-	0755	rm
css/	-	0755	rm
images/	-	0755	rm
js/	-	0755	rm
partials/	-	0755	rm
artists.php	8237	0644	edit dl rm
contact.php	5908	0644	edit dl rm
error_log	6662439	0644	edit dl rm
googlef0e45ee3f3eb5c27.html	53	0644	edit dl rm
index.php	8105	0644	edit dl rm
music.php	10739	0644	edit dl rm
musicNew.php	9711	0644	edit dl rm
musictest-1.php	2847	0644	edit dl rm
musictest-2.php	2472	0644	edit dl rm
news.php	5970	0644	edit dl rm
RISjukebox.php	12711	0644	edit dl rm
RISjukeboxMenu.php	11658	0644	edit dl rm
RISjukeboxTEMP.php	11342	0644	edit dl rm
song.php	6682	0644	edit dl rm

Edit: /home/gonqkt9zy6pk/public_html/RIS/news.php (5970B)

<!DOCTYPE html>
<html lang="en" ><head>
  <meta charset="UTF-8">
  <title>Rock In Soul Home</title>
  <link rel="stylesheet" href="../css/normalize.min.css">
<link rel="stylesheet" href="css/style.css">
	<link rel="stylesheet" href="../css/reset.min.css">
	<link href="css/singlePageTemplate.css" rel="stylesheet" type="text/css">
	
	<style>
body,
html{
    position: absolute;
    display: flex;
    flex-wrap: wrap;
    justify-content: center;
    align-items: center;
    width: 100%;
    height: 100vh;
    background-color: #706149;
}
    </style>

</head>
<body>


<div class="nav__bar">
    <a href="#" class="nav__trigger">
        <div class="bars"></div>
    </a>        
</div>
<div id="showMusic">Currently playing: </div>
<main class="main">
    

	
  
     <?php include('partials/header.php'); ?>
    <div class="hptagline" id="showMusic"> CURRENTLY PLAYING: <a href="song.php?id=7">Body Rock</a> by <a href="artists.php?id=1">Ernest 'Romeo' Polk</a></div>
  
  <section class="hphero" id="hero">
    <h2 class="hphero_header">ROCK IN SOUL<span class="hplight">NEWS </span></h2>
    <p class="hptagline">News on your favorite music and artists from local and worldwide!</p>
  </section>
   
    
  
	<div class="details">
								
					
		<?php
			if(isset($_SESSION['upload']))
			{
				echo $_SESSION['upload'];
				unset($_SESSION['upload']);
			}
		?>
		
	  
	
		  <?php 
			if(isset($_GET['id']))
		{
			//Category id is set and get he id
			$id = $_GET['id'];				
		
		//Getting Foods from Database that are active and featured
				//SQL Query
			$sql = "SELECT* FROM otb_news WHERE id='$id'";
			
			//Execute the Query
			$res= mysqli_query($conn,$sql);
			
			//Count Rows
			$count = mysqli_num_rows($res);
			
			//Check whether food is availible or not
			if($count>0)
			{
				//Food Availible so create 'while loop'
				while($row=mysqli_fetch_assoc($res))
				{
					//Get alll the values
					$id = $row['id'];
					$site = $row['site_number'];
					$title = $row['news_title'];
					$price = $row['special_price'];
					$copy = $row['news_copy'];
					$blurb = $row['news_blurb'];
					$image_name = $row['image_name'];
					$link = $row['news_link'];
					$link_text = $row['link_text'];
					$active = $row['active'];
					$featured = $row['featured'];
					$special = $row['special'];
					?>
	  <div>		  				
		   			 <?php 
								//Check whether image is availiable or not
								if($image_name=="")
								{
									//image not available
									echo "<div class='error'>Image not availible. </div>";
									
								}
								else
								{
									//Image Availible
									?>
		    						<img src="<?php echo SITEURL; ?>images/news/<?php echo $image_name;?>" alt="<?php echo $title;  ?>"  class="news-details-img">
		    				<?php 
									
								}							
							
							?>
								
        
		  <div class="news-menu-box">
			  
		    <div class="news-menu-desc">
		      <?php 
					
					echo "<h1>$title</h1>";						 
					if($site ==1){echo "<p>from: Out the Box</p>";}
					if($site ==2){echo "<p>from: OTB Bakery</p>";}
					if($site ==3){echo "<p>from: Rock in Soul</p>";}
					if($site ==4){echo "<p>from: New Breed Companies</p>";}

?>
				<br>
				<?php 
					if($special=='yes'){
						echo "<p class='success'>Active Special</p>";
						echo"<p class='news-menu-price'>$$price</p>"; 
						
					}				
					
				?>
		      
		      <p class="news-menu-detail"> <?php echo $blurb; ?> </p>
		      <br>
		      
	        </div>
        </div>
		  
		  <div class="news-menu-box">
			<a href="<?php echo SITEURL; echo $link; ?>"  class="btn-secondary"><?php echo $link_text; ?></a>
			
			</div>
		  <div class="news-menu-boxLG">		   
		    <div class="news-menu-desc">
		      <h4>News Details</h4>
		      <p class="news-detail"> <?php echo $copy; ?> </p>
		      <br>
	        </div>
			              <div class="clearfix"></div>

</div>
		  
	</div>
		<?php  
				} 
			}
		
		?>
	</div>
	
	</div>
	</div>
<?php  
			}
?>	
            <div class="clearfix"></div>

<section class="hpfooter_banner" id="contact">
<?php
			
				//Ccreate SQL Query to disply catagories from database
				$sql = "SELECT * FROM otb_news WHERE active='Yes' AND site_number='3'
				";//
				//Execute the Query
				$res = mysqli_query($conn, $sql);
				//Count rows to check whether the category is available or not
				$count = mysqli_num_rows($res);
				//echo $conn; //die();
				if($count>0){
					//categorie availble
					while($row=mysqli_fetch_assoc($res)){
						
						//Get the Values like id, title, image_name
						$id = $row['id'];
						$title = $row['news_title'];
						$image_name = $row['image_name'];
						$blurb = $row['news_blurb'];
						?>
							<a href="<?php echo SITEURL; ?>RIS/news.php?id=<?php echo $id;?>">
    							<div class="hpthumbnail">
								<img src="<?php echo SITEURL; ?>images/news/<?php echo $image_name; ?>" alt="<?php echo $title; ?>">			 					
      							<h1 class="hpstats">news</h1>
      							<h4><?php echo $title; ?></h4>
      							<p><?php echo $blurb; ?></p>
								</div>
							</a>							
			<?php
					}
				}

?>   </section>
  
			  <div class="clearfix"></div>

</body>
</html>

cmd: