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 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94
| <?php
session_start();
?>
<!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>Test option</title>
</head>
<?php
$cookie_matricule=$_SESSION["cookie_matricule"];
$centre=0;
//connection à la base de données:
$cnx = odbc_connect( "DSN_disponibilite", "root", "" ) or die ("Impossible de se connecter à la base de donnée") ;
//Recuperation des valeurs des centres
$sql = "SELECT * FROM Rcentre where matricule=".$cookie_matricule."";
$requete = odbc_do($cnx, $sql) ;
$result = odbc_fetch_object($requete);
$centre1=$result->centre1;
$centre2=$result->centre2;
$ncentre1=$result->ncentre1;
$ncentre2=$result->ncentre2;
?>
<body>
<?php
if (($centre1<>$centre2)AND($centre2<>"")){echo "different" ?>
<?php
if (isset($_POST['ok'])) {$centre=$_POST['radio'];echo $_POST['radio'];} else {$centre=$centre1;echo $centre;}
?>
<form id="form1" name="form1" method="post" action="">
<p>
<?php
if ($centre==$centre1){
?>
<input type="radio" name="radio" id="centre" value="<?php echo $centre1; ?>" checked="checked"/>
<label for="centre"><?php echo $ncentre1; ?></label>
<?php ;}
else {
?>
<input type="radio" name="radio" id="centre" value="<?php echo $centre1; ?>" />
<label for="centre"><?php echo $ncentre1; ?></label>
<?php ;} ?>
<br/>
<?php
if ($centre==$centre2){
?>
<input type="radio" name="radio" id="centre2" value="<?php echo $centre2; ?>" checked="checked" />
<label for="centre2"><?php echo $ncentre2; ?></label>
<?php ;}
else {
?>
<input type="radio" name="radio" id="centre2" value="<?php echo $centre2; ?>" />
<label for="centre2"><?php echo $ncentre2; ?></label>
<?php ;} ?>
</p>
<input type="submit" name="ok" id="ok" value="Envoyer" />
</form>
<?php ;} else { echo "pareil"; $_POST['radio']=$centre1; //echo $_POST['radio']
;} ?>
<?php
//requête SQL ensemble des disponibilités déclarées (date()>= date déclarée):
$date=date('d-m-Y');
$dateEN = substr($date,6,4)."-".substr($date,3,2)."-".substr($date,0,2);
$sqldecla = "SELECT * FROM dispo_journaliere where matricule=".$cookie_matricule." and jour>=#".$dateEN."# AND centre=".$_POST['radio']." ORDER BY jour" ;
// echo "".$sqldecla."";
$cnx = odbc_connect( "DSN_disponibilite", "root", "" ) or die ("Impossible de se connecter à la base de donnée") ;
//exécution de la requête:
$requetedecla = odbc_do($cnx, $sqldecla) ;
echo $sqldecla;
echo ("<div align=\"center\">Disponibilité déclarée pour le:");
while( $resultdecla = odbc_fetch_object( $requetedecla ) )
{
$date2=$resultdecla->jour;
$dateEN1 = date(substr($date2,8,2)."-".substr($date2,5,2)."-".substr($date2,0,4));
?> <div align="center"><a href="declaration_dispo.php?dateurl=<?php echo $dateEN1; ?>"><?php echo $dateEN1;?></a><br>
<?php
} ?>
</body>
</html> |
Partager