<h1>Gestion des notes : /* Professeur */</h1>
			<?php
				include "connexion_data.php";
				/*mysql_connect($host,$login,"");
				mysql_select_db($database) or die( "Unable to select database");*/
				$sql = "select nom from note where id = 1;";
				mysql_connect($host,$login,"");
				mysql_select_db($database) or die( "Unable to select database");
				$sql = "select NOTE_NOTE from note where NUM_NOTE = 1;";
				$resultat = mysql_query($sql);
				//echo mysql_result($resultat,0);
				echo mysql_fetch_array($resultat);
			?>
			<table id="one-column-emphasis" summary="Notes élèves, LaMache">
				<colgroup>
					<col class="oce-first" />
					<col/>
					<col/>
					<col/>
					<col/>
					<col/>
					<col class="oce-last" />
				</colgroup>
				<thead>
					<tr>
					<th scope="col">Eleves</th>
					<?php
						$matiere = "select INTITULE_MATIERE from matiere;";
						$result = mysql_query($matiere);
						while($row = mysql_fetch_array($result))
						{
							$matiere = $row[0];
							echo "<th scope='col'>".$matiere."</th>";
						}
					?>
					</tr>
				</thead>
				<tbody>
					<?php

					$reqnb = "select count(*) from note";

					$nb_col = mysql_query($reqnb);
					echo mysql_result($nb_col,0);
					//select count(*) from note

						$name = "select NOM_ETUDIANT, PRENOM_ETUDIANT from etudiant";
						$matiere = "select NUM_MATIERE from matiere;";
						$result = mysql_query($name);
						while($row = mysql_fetch_array($result))
						{
								$nom = $row[0];
								$prenom = $row[1];
								echo "<tr><td>".$nom." ".$prenom."</td></td>";
								$result = mysql_query($matiere);
								while($rox = mysql_fetch_array($result))
								{
									$matiere = $rox[0];

									//$id_etu = "Select NUM_ETUDIANT, NUM_FORMATION from etudiant";
									//$id_note = "Select NUM_NOTE from posseder where NUM_ETUDIANT =".id_etudiant."AND NUM_FORMATION=".id_formation.";";

									//$note = "Select NOTE_NOTE from note where
									echo "<td>

									<input type='text' name=".$matiere."_".$nom."/></td>";
								}
						}
						//$reqmat = "select note from note where nom = ".mysql_result($valuename,0).";";
						echo "</tr>";
						//$reqmat = "select note from note where nom = ".mysql_result($valuename,0).";";
						//var_dump($nom);
						//$querymat = mysql_query($reqmat);


					  ?>
								</tbody>
				<tfoot>
						<tr>
						<td>Moyenne classe</td>
					<?php
						$matiere = "select INTITULE_MATIERE from matiere;";
						$result = mysql_query($matiere);
						while($row = mysql_fetch_array($result))
						{

							$var_test = 4;
 							$matiere = $row[0];
							echo "<td>".$var_test."</td>";
						}
					?>
					</tr>
				</tfoot>
			</table>
				<?php
				//Database Logins
				$user="root";
				$password="";
				$serv="localhost";
				$database="iri";
				//Connection Db
				mysql_connect($serv,$user,$password);
				@mysql_select_db($database) or die( "Unable to select database");
				?>
				<form name="formulaire" method="post" action="notes_script.php">
				<select name="id_etudiant" size="1" >";
				<?php
				$dip = "select num_etudiant,nom_etudiant from etudiant";
				$dip2=mysql_query($dip);
				while ($donnees = mysql_fetch_array($dip2) )
				{
					echo"<option value='".$donnees['num_etudiant']."'>".$donnees['nom_etudiant']."</option>";
				}
				?>
				</select>

				<select name="id_matiere" size="1" >";
				<?php
				$dip = "select NUM_MATIERE,INTITULE_MATIERE from MATIERE";
				$dip2=mysql_query($dip);
				while ($donnees = mysql_fetch_array($dip2) )
				{
				echo"<option value='".$donnees['NUM_MATIERE']."'>".$donnees['INTITULE_MATIERE']."</option>";
				}
				?>
				</select>

      				<table width="313" height="86" border="1">
					<td width="161">note<input name="note" type="text" id="note" value=""></td>
					<td width="161">type<input name="type" type="text" id="type" value=""></td>
					<td width="161">coef<input name="coef" type="text" id="coef" value=""></td>
					<tr>
						<td height="44" colspan="2"><div align="center"> <input type="submit" name="Submit" value="Envoyer"> </div>	</td>
					</tr>
			        </table>


				</tbody>
				<tfoot>
						<tr>
						<td>Moyenne classe</td>
					<?php
						$matiere = "select INTITULE_MATIERE from matiere;";
						$result = mysql_query($matiere);
						while($row = mysql_fetch_array($result))
						{

							$var_test = 4;
 							$matiere = $row[0];
							echo "<td>".$var_test."</td>";
						}
					?>
					</tr>
				</tfoot>

			</table>

			<input type="submit" name="submit" value="SUBMIT"/>
			<input type="reset" name="reset" value="RESET"/>
			<span id="useradd">Ajouter un élève : <input type="text" id="neweleve" value="Nom élève ?"/>
			<a href="javascript:ajout_eleve()"><img src="images/add.png"/></a>
			</span>

			<span class="parents"><h1>Gestion des notes : /* Parents/élèves */</h1>
			Bonjour Jean-Broche Poulet,<br/>
			Vous êtes sur la page d'acces au notes de vôtre enfant : &nbsp;
		<SELECT name="fonction">
			<OPTION VALUE="Martin.Poulet">Martin Poulet</OPTION>
			<OPTION VALUE="Cuisse.Poulet">Cuisse Poulet</OPTION>
		</SELECT><br /></span>
			<a href="#"><img src="images/downloadbt.png"/><a>