Untitled

<?php
include 'header.php';
include 'menu.php';
?>
<?php
session_start();
session_destroy();
if(isset($_SESSION["firstName"])&&isset($_SESSION["lastName"])&&isset($_SESSION["emailAddress"])&&isset($_SESSION["phoneNum"])&&isset($_SESSION["socialNumber"])&&isset($_SESSION["password"])){
echo "<h1>Session State Data</h1>";
echo "First Name: " .$_SESSION["firstName"]."</br>";
echo "Last Name: ".$_SESSION["lastName"]."</br>";
echo "Email Address: ".$_SESSION["emailAddress"]."</br>";
echo "Phone Number: ".$_SESSION["phoneNum"]."</br>";
echo "SIN: ".$_SESSION["socialNumber"]."</br>";
echo "Password: ".$_SESSION["password"]."</br>";
}
$host = "localhost";
$database = "peterngu_cst8238";
$username = "peterngu_account";
$password = "44126841";
$dbConnection = mysql_connect($host, $username, $password);
if(!$dbConnection){
	die("Unable to connect to database ". $host.mysql_connect_error($dbConnection));
}
mysql_select_db($database);
$sql = "SELECT * FROM employee";
$data = mysql_query($sql);
echo "<h1>Database Data</h1>";
echo "<table>
	  <tr>
	  <td><b>First Name</b></td>
	  <td><b>Last Name</b></td>
	  <td><b>Email Address</b></td>
	  <td><b>Phone Number</b></td>
	  <td><b>SIN</b></td>
	  <td><b>Password</b></td>
	  </tr>";
while($record = mysql_fetch_array($data)){
echo "<tr>";
echo "<td>" .$record['firstName'] . "</td>";
echo "<td>" .$record['lastName'] . "</td>";
echo "<td>" .$record['emailAddress'] . "</td>";
echo "<td>" .$record['phoneNum'] . "</td>";
echo "<td>" .$record['socialNumber'] . "</td>";
echo "<td>" .$record['password'] . "</td>";
echo "</tr>";
echo "</br>";
}
echo"</table>";
mysql_close($dbConnection);
?>
<html>
</html>
<?php
include 'footer.php';
?>