View Students
<![CDATA[
<?php
session_name('StudentsRecords');
session_start();
echo '
<html>
<head>
<link rel="stylesheet" href="styles1.css" type="text/css" media="screen">
</head>
<body>
<div>
';
require_once ('mysql_connect.php');
$query = "select * from students order by student_name ";
$result = @mysql_query($query);
if ($result){
echo '<h2>View All Students</h2>';
echo '<table border="1">';
echo '<tr><td class="header">Student Name</td><td class="header">Category</td><td class="header">Password</td></tr>';
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)){
echo '<tr>';
echo '<td class="sname">'.$row['student_name'].'</td>';
echo '<td>'.$row['student_category'].'</td>';
echo '<td>'.$row['student_pw'].'</td>';
echo '</tr>';
}
echo '</table>';
mysql_free_result($result);
}
else{
echo 'Problem: Unable to retrieve data at this time. Try again Later.';
}
echo '</div></body></html>';
mysql_close();
?>
]]>