Code to view results

By 

<!DOCTYPE html>
<html>
<head>
 <title>Thanks for Joining</title>
 <meta charset="UTF-8">
 <meta name="description" content="">
 <meta name="keywords" content="">
 <link rel="stylesheet" href="bootstrap.css">
 <link rel="stylesheet" href="style.css">
</head>
<body>
<?php 

 $dsn = "mysql:host=localhost;dbname=proferik_Demo"; 
 $username = "proferik_teacher";
 $password = "Pa55word";
 
 $db = new PDO($dsn, $username, $password);

 $sql = "SELECT * FROM tblDemo";
 
 $answer = $db->query($sql);
?>
 
<header class="container-fluid">
 <h1>Survey Results</h1> 
 <h2><a href="index.html">HOME</a></h2>
</header>
 
<div class="container"> 
<?php 
 foreach ($answer as $ans) {
 echo $ans['first_name']. "<br>" ; 
 echo $ans['last_name']. "<br>" ; 
 echo $ans['cars']. "<br>" ;
 echo $ans['html_feelings']. "<br>" ;
 echo "<hr>";
 }
 ?>
</div> 


</body>
</html>

Leave a Reply