Table structure for table `examinee`
--
-
CREATE TABLE `examinee` (
`examinee_id` int(10) UNSIGNED NOT NULL,
`user_name` varchar(30) NOT NULL,
`password` varchar(40) NOT NULL,
`date_of_registration` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--
-- Dumping data for table `examinee`
--
-
INSERT INTO `examinee` (`examinee_id`, `user_name`, `password`, `date_of_registration`) VALUES
(1, 'khalidswaisi', 'swaisi2016', '2016-03-23 00:00:00'),
(2, 'user', 'user', '2016-04-10 16:38:00'),
(3, 'mohammed', 'nasyia', '0000-00-00 00:00:00');
-
-- --------------------------------------------------------
-
-
display page
-
<?php include ("connection.php"); ?>
-
<center><h2>Examinee List</h2></center>
<table border="1" cellpadding = "0" cellspacing = "0" width = "700" align = "center">
<thead>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
</thead>
<?php
$sql = mysqli_query ($link,"SELECT * FROM `examinee`") or die ();
while ( $row = mysqli_fetch_assoc($sql)) {
echo "<tr>
<td>".$row['examinee_id']."</td>
<td>".$row['user_name']."</td>
<td>".$row['password']."</td>
<td>".$row['date_of_registration']."</td>
<td align = 'center'>
<a href = 'examinee_Edit.php?examinee_id=$row[examinee_id]'>Update</a>
<a href = 'examinee_Delete.php?examinee_id=$row[examinee_id]'> Delete</a>
</td>
</tr>";
}
-
?>
</table>
-
</body>
-
-
</html>
-
</body>
</html>
Table structure for table `examinee`
--
CREATE TABLE `examinee` (
`examinee_id` int(10) UNSIGNED NOT NULL,
`user_name` varchar(30) NOT NULL,
`password` varchar(40) NOT NULL,
`date_of_registration` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `examinee`
--
INSERT INTO `examinee` (`examinee_id`, `user_name`, `password`, `date_of_registration`) VALUES
(1, 'khalidswaisi', 'swaisi2016', '2016-03-23 00:00:00'),
(2, 'user', 'user', '2016-04-10 16:38:00'),
(3, 'mohammed', 'nasyia', '0000-00-00 00:00:00');
-- --------------------------------------------------------
display page
<?php include ("connection.php"); ?>
<center><h2>Examinee List</h2></center>
<table border="1" cellpadding = "0" cellspacing = "0" width = "700" align = "center">
<thead>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
</thead>
<?php
$sql = mysqli_query ($link,"SELECT * FROM `examinee`") or die ();
while ( $row = mysqli_fetch_assoc($sql)) {
echo "<tr>
<td>".$row['examinee_id']."</td>
<td>".$row['user_name']."</td>
<td>".$row['password']."</td>
<td>".$row['date_of_registration']."</td>
<td align = 'center'>
<a href = 'examinee_Edit.php?examinee_id=$row[examinee_id]'>Update</a>
<a href = 'examinee_Delete.php?examinee_id=$row[examinee_id]'> Delete</a>
</td>
</tr>";
}
?>
</table>
</body>
</html>
</body>
</html>
1 Answer(s)