<!DOCTYPE html>
<html><head>
<meta charset=UTF-8>
<title>Afis</title>


<link href="stil.css" rel="stylesheet" type="text/css">
</head>

<body>
<div id="wrapper">
<div id="header">
<h1>This is the Page Header</h1>
</div>
 
<div id="left-column">
<h2>The Navigation</h2>
<?php
include "meniu.php";
?>
</div>
 
<div id="right-column">
<h2>Studentii din scoala noastra</h2>
<?php
	include "conect.php";
	$sql="SELECT * FROM studenti ORDER BY nume";
	$rez=mysqli_query ($conexiune,$sql);
?>
<table>
		<tr>
			<th>Nr Crt</th>
			<th>Nume</th>
			<th>Prenume</th>
			<th>Semi-grupa</th>
			<th>Email</th>
			<th>Data nasterii</th>
			<th>Sterge</th>
		</tr>
			<?php
				$i=1;
				while($row=mysqli_fetch_array($rez))
				{
					echo"<tr";
						if($i%2==0)
							echo" class=\"stil1\"";
						echo"><td>".$i."</td>
						<td>".$row['nume']."</td>
						<td>".$row['prenume']."</td>
						<td>".$row['sgrupa']."</td>
						<td>".$row['email']."</td>
						<td>".$row['data_n']."</td>
						<td><a href=sterge_student.php?id=".$row['id'].">Sterge</a></td>
						</tr>\n";
					$i++;
				}
			?>	
</table>
</div>
 
<div id="footer">
<p>The Page Footer Goes Here</p>
</div>
</div><!--aici se termina wrapperul-->


</body></html>