<!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>Modifica nota si/sau data</h2>
<?php
	include "conect.php";
		$id=$_GET['id'];
			$sql="SELECT * FROM note WHERE id='$id'";
			$rez=mysql_query($sql);
			$row=mysql_fetch_array($rez);
			$idstudent=$row['id_student'];
			$idmaterie=$row['id_materie'];
		$sql1="SELECT *FROM studenti WHERE id='$idstudent'";
		$rez1=mysql_query($sql1);
		$row1=mysql_fetch_array($rez1);
		$sql2="SELECT * FROM materii WHERE id='$idmaterie'";
		$rez2=mysql_query($sql2);
		$row2=mysql_fetch_array($rez2);
		
		$sql3="SELECT * FROM studenti";
		$rez3=mysql_query($sql3);
		
		$sql4="SELECT * FROM materii";
		$rez4=mysql_query($sql4);

	?>	
		
	<p>Student : <?php echo $row1['nume']; ?><br />
	Materia: <?php echo $row2['denumire']; ?><br />

	<form action="update_s.php" method="post">
	<input  type="text" name="nota" value="<?php echo $row['nota']  ?>" />
	<input  type="text" name="data" value="<?php echo $row['data']  ?>" />
	<input type="hidden" name ="idu" value ="<?php echo $id ?>" />
	<input type="submit" value="modifica" />
	
	</form>
</div>
 
<div id="footer">
<p>The Page Footer Goes Here</p>
</div>
</div><!--aici se termina wrapperul-->


</body></html>