1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
| <form name="Formulaire" id="Formulaire">
<table >
<th></th>
<th>Salle</th>
<th>Nom evenement </th>
<th> Nature evenement</th>
<th> Theme evenement</th>
<th> Date evenement </th>
<th> heure Début </th>
<th> heure Fin </th>
<th> disfonctionement technique </th><tr>
<?php
$dsn="con_salle";
$username="localhost";
$password="";
$sqlconnect=odbc_connect($dsn,$username,$password);
$select="select id_even,ID_SALLE,NOM,NATURE,THEME,DATEPART(yy,date)as datee,DATEPART(mm,date)as mont,DATEPART(dd,date)as day,HEURE_DEBUT ,HEURE_FIN ,DISFONCT_TECH from EVENEMENT where login='$login' order by id_even ";
$process=odbc_exec($sqlconnect, $select);
while(odbc_fetch_row($process)){
$id_even=odbc_result($process,"id_even");
$Salle= odbc_result($process,"ID_SALLE" );
if($Salle==1){$Salle="salle de conferance ";}
else { $Salle=$Salle-1;
$Salle="salle de réunion $Salle";}
$nom= odbc_result($process,"NOM" );
$nature= odbc_result($process,"NATURE" );
$theme= odbc_result($process,"THEME" );
$date= odbc_result($process,"datee" );
$date1= odbc_result($process,"mont" );
$date2= odbc_result($process,"day" );
$heure_d= odbc_result($process,"HEURE_DEBUT" );
$heure_f= odbc_result($process,"HEURE_FIN" );
$disf= odbc_result($process,"DISFONCT_TECH" );
if($date=='2000' && $date1=='01' && $date2=='01'){
echo"<td> - </td>";
}
else {
echo"<td><input type='checkbox' name='options[]' id='options[]' value='$id_even' /></td>"; }
echo "<td>$Salle</td> ";
echo "<td>$nom</td>";
echo"<td> $nature</td>" ;
echo "<td>$theme</td>" ;
if($date=='2000' && $date1=='01' && $date2=='01'){
echo"<td>Annuler </td>";}
else {
echo "<td>$date - $date1 - $date2</td>" ; }
echo "<td>$heure_d h 00</td>";
echo "<td>$heure_f h 00</td>";
echo "<td>$disf</td><tr>" ;
}
?>
</table> |
Partager