slides.php

<?php 

    // First we execute our common code to connection to the database and start the session 
    require("common.php"); 
     
    // // At the top of the page we check to see whether the user is logged in or not 
    // if(empty($_SESSION['user'])) 
    // { 
        // // If they are not, we redirect them to the login page. 
        // header("Location: login.php"); 
         
        // // Remember that this die statement is absolutely critical.  Without it, 
        // // people can view your members-only content without logging in. 
        // die("Redirecting to login.php"); 
    // } 
     
    // Everything below this point in the file is secured by the login system 
     
    // We can retrieve a list of members from the database using a SELECT query. 
    // In this case we do not have a WHERE clause because we want to select all 
    // of the rows from the database table. 
    $query = " 
        SELECT 
            slideId, 
            title, 
            body,
			slideImageId
        FROM slides 
    "; 
     
    try 
    { 
        // These two statements run the query against your database table. 
        $stmt = $db->prepare($query); 
        $stmt->execute(); 
    } 
    catch(PDOException $ex) 
    { 
        // Note: On a production website, you should not output $ex->getMessage(). 
        // It may provide an attacker with helpful information about your code.  
        die("Failed to run query: " . $ex->getMessage()); 
    } 
         
    // Finally, we can retrieve all of the found rows into an array using fetchAll 
    $rows = $stmt->fetchAll(); 
?> 



	
	
    <?php foreach($rows as $row): ?> 
		<div id="slide-<?php echo $row['slideId']; ?>">
			<div class="info">
				<h1><?php echo htmlentities($row['title'], ENT_QUOTES, 'UTF-8'); ?></h1>
			
				<p><?php echo htmlentities($row['body'], ENT_QUOTES, 'UTF-8'); ?></p>
			</div>
			<img src="images/slides/<?php echo $row['slideImageId']; ?>.jpg" />
		</div>
    <?php endforeach; ?> 

<script src="scripts/slides.js"></script>