<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Doi</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>Adauga note</h2>
<form action="insert_note.php" method="post">
Student:
	<?php include "conect.php";
	$sql1="SELECT * FROM studenti";
	$rez1=mysql_query($sql1);
	?>
	<select name="idul_stud">
	<option value=0">Selectati</option>
	<?php
		while($row1=mysql_fetch_array($rez1))
		{
			echo "<option value=\"".$row1['id']."\">".$row1['nume']."</option>";
		}
	?>
	</select></br>
Materie:
	<?php include_once "conect.php";
		$sql2="SELECT * FROM materii";
		$rez2=mysql_query($sql2);
	?>
	<select name="idul_mat">
	<?php
		while($row2=mysql_fetch_array($rez2))
		{
			echo "<option value=\"".$row2['id']."\">".$row2['denumire']."</option>";
		}
	?>
	</select></br>
Nota:
	<input type="text" name="nota"/><br/>
Data:
	<input type="text" name="data"/><br/>
	
<input type="submit" value="Trimite"/>
<input type="reset" value="Sterge"/>
</form>
</div>
 
<div id="footer">
<p>The Page Footer Goes Here</p>
</div>
</div><!--aici se termina wrapperul-->


</body></html>