J'ai un probleme je dois faire un site web permettant à des étudiant et des profs d'aller consulter leur emploi du temps stocker dan une base de donné (je peux fournir le dump si kelkun peu m'aider rapidement).J'aimerai ke lorsqu'il choisi le professeur,la promotion ou la salle, une liste de choix apparait pour choisir la semaine et qu'en suite on affiche les résultats dans le tableau. Merci de votre aide
Voici le code de la page
<html>
<title></title>
<head>
<SCRIPT LANGUAGE="JavaScript">
function ajout0(nombre) {
if (nombre < 10) nombre = "0" + nombre;
return nombre;
}
function an(annnee) {
annnee = annnee - 0;
if (annnee < 83) return (2000 + annnee);
if (annnee < 2000) return (1900 + annnee);
return annnee;
}
function MAJ1() {
var dateModif = new Date(document.lastModified);
document.write(ajout0(dateModif.getDate()) + "/"
+ ajout0(dateModif.getMonth()+1) + "/" + an(dateModif.getFullYear()));
}
</SCRIPT>
</head>
<td width="468" height="48" align="right"> <a href="#" onclick="lienGoogle='http://translate.google.com/translate?u=';
lienATraduire = escape(window.location);langDepart = 'fr';langArrivee = 'en';langPair = '&langpair='+langDepart+'%7C'+langArrivee;window.location=lienGoogle+lienATraduire+langPair;"><img src="http://localhost/ia_us.gif" alt="Translate with Google" width="30" height="20" border="0"></a>
</td>
<body bgcolor="#FF9933">
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
Dernière modification le : <i><SCRIPT LANGUAGE="Javascript">MAJ1()</SCRIPT></i></font><br><br>
Veuillez choisir : <br><br>
<label>
Professeur : </label><select name="listeprof" size="1">
<?php
$db = mysql_connect('localhost', 'root', 'xxxx');
mysql_select_db('edt',$db);
$sql = 'SELECT nom FROM Prof order by nom';
$req = mysql_query($sql);
while($data = mysql_fetch_assoc($req))
{
echo '<option value="'.$data['nom'].'">'.$data['nom'].'</option><br>';
}
mysql_close();
?> </select> <input type="submit" name="go" value="OK">
<label>Promotion : </label></li><select name="listepromo" size="1">
<?php
$db = mysql_connect('localhost', 'root', 'xxxxxxx');
mysql_select_db('edt',$db);
$sql = 'select Promo.nom, Classe.nom from Promo,Classe where Classe.id_promo=Promo.id_promo';
$req = mysql_query($sql);
while($data = mysql_fetch_assoc($req))
{
echo '<option value="'.$data['nom'].' '.$data['nom'].'">'.$data['nom'].' '.$data['nom'].'</option><br>';
}
mysql_close();
?></select> <input type="submit" name="go" value="OK">
<label>Salle : </label></li>
<select name="listesalle" size="1">
<?php
$db = mysql_connect('localhost', 'root', 'xxxxxxx');
mysql_select_db('edt',$db);
$sql = 'SELECT nom FROM Salle order by nom';
$req = mysql_query($sql);
while($data = mysql_fetch_assoc($req))
{
echo '<option value="'.$data['nom'].'">'.$data['nom'].'</option><br>';
}
mysql_close();
?></select> <input type="submit" name="go" value="OK">
<p align="right"><a href="admin/index2.php">Accès administration </a>
<img src="http://perso0.free.fr/cgi-bin/meteo.pl?dep=40" align="right" width="80" height="49"></p>
<p align="right"> </p>
<hr>
<style>
<!--
.ms-grid8-main { border-left-style: none; border-right: .75pt solid navy;
border-top: .75pt solid navy; border-bottom: .75pt solid navy;
background-color: white }
.ms-grid8-tl { font-weight: bold; color: white; border-left: .75pt solid navy;
border-right-style: none; border-top-style: none;
border-bottom: .75pt solid navy; background-color: navy }
.ms-grid8-left { font-weight: normal; color: black; border-left: .75pt solid navy;
border-right-style: none; border-top-style: none;
border-bottom: .75pt solid navy; background-color: white }
.ms-grid8-top { font-weight: bold; color: white; border-left: .75pt solid navy;
border-right-style: none; border-top-style: none;
border-bottom: .75pt solid navy; background-color: navy }
.ms-grid8-even { font-weight: normal; color: black; border-left: .75pt solid navy;
border-right-style: none; border-top-style: none;
border-bottom: .75pt solid navy; background-color: white }
-->
</style>
</head>
<p align="center"><b>Semaine du au</b></p>
<table cellpadding="0" cellspacing="0" class="ms-grid8-main" width="100%" height="539">
<!-- MSTableType="layout" -->
<!-- fpstyle: 23,011111100 -->
<tr>
<td valign="top" class="ms-grid8-tl">
<p align="center"> </td>
<td class="ms-grid8-top" height="37" width="194">
<p align="center">Lundi</td>
<td class="ms-grid8-top" height="37" width="194">
<p align="center">Mardi</td>
<td class="ms-grid8-top" height="37" width="194">
<p align="center">Mercredi</td>
<td class="ms-grid8-top" height="37" width="194">
<p align="center">Jeudi</td>
<td class="ms-grid8-top" height="37" width="194">
<p align="center">Vendredi</td>
</tr>
<tr>
<td valign="top" class="ms-grid8-left">
<p align="center">8h00</td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left">8h30</td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left">9h00</td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left">9h30</td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left">10h00</td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left">10h30</td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left">11h00</td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left">11h30</td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left">12h00</td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left">12h30</td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
<td class="ms-grid8-even" height="20" align="center"> </td>
</tr>
<tr>
<td valign="bottom" align="center" class="ms-grid8-left" height="20">13h00</td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left" height="20" bgcolor="#C0C0C0" style="background-color: #808080"> </td>
<td class="ms-grid8-even" style="background-color: #808080" colspan="5" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left" height="20">14h00</td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left" height="20">14h30</td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left" height="20">15h00</td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left" height="20">15h30</td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left" height="20">16h00</td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left" height="20">16h30</td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left" height="20">17h00</td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left" height="20">17h30</td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left" height="20">18h00</td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left" height="20">18h30</td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left" height="20">19h00</td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left" height="20">19h30</td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
</tr>
<tr>
<td valign="top" align="center" class="ms-grid8-left" height="20" width="103">
20h00</td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
<td class="ms-grid8-even" align="center"> </td>
</tr>
</table>
</body>
</html> Modifié par seb97133 (06 Jun 2006 - 16:11)
