par
jp.kerloch » 28 févr. 2008, 12:50
Bonjour,
Voici mon problème. Je suis entrain de developper une gestion de cantine en PHP5 et ca fonctionne nickel.. Maintenant le petit soucis que j'ai c'est que si une personne commande un repaset qu'elle prend 2 entrees ca passe or que cela ne devrait pas. pareil pour le plat de resistance etc ...
Je vous donne mon code ..
<?
session_start();
include("hydrus.php5");
if(hydrus_access_valid_admin($_SESSION['login'],$_SESSION['password'],session_id(),$bdd) == false)
{
hydrus_utils_redirect("login.php5");
exit();
}
$error = 0;
if(isset($_POST)==true && $_POST['valid'] == 1)
{
if (
strlen($_POST['menu_entree1']) <= 0 &&
strlen($_POST['menu_entree2']) <= 0 &&
strlen($_POST['menu_entree3']) <= 0 &&
strlen($_POST['menu_entree4']) <= 0 &&
strlen($_POST['menu_resistance1']) <= 0 &&
strlen($_POST['menu_resistance2']) <= 0 &&
strlen($_POST['menu_resistance3']) <= 0 &&
strlen($_POST['menu_resistance4']) <= 0 &&
strlen($_POST['menu_resistance5']) <= 0 ||
// strlen($_POST['menu_legume1']) <= 0 &&
// strlen($_POST['menu_legume2']) <= 0 &&
// strlen($_POST['menu_legume3']) <= 0 ||
strlen($_POST['menu_fromage1']) <= 0 &&
strlen($_POST['menu_fromage2']) <= 0 &&
strlen($_POST['menu_fromage3']) <= 0 &&
strlen($_POST['menu_dessert1']) <= 0 &&
strlen($_POST['menu_dessert2']) <= 0 &&
strlen($_POST['menu_dessert3']) <= 0
)
{$error = 1;
{
hydrus_utils_alert("Il y a surement une erreur");
hydrus_utils_redirect ("commande_menu1.php5?semaine='".$_GET['semaine']."'&jour='".$_GET['jour']."'");
}
}
if($error == 0)
{
$requete_txt = "
INSERT INTO `menu_utilisateur`
(`menu_id`,`menu_semaine`,`menu_jour`,`admin_id`,`menu_entree1`,`menu_entree2`,`menu_entree3`,`menu_entree4`,`menu_resistance1`, `menu_resistance2`,`menu_resistance3`,
`menu_resistance4`,`menu_resistance5`,`menu_legume1`,`menu_legume2`,`menu_legume3`,`menu_fromage1`,`menu_fromage2`,`menu_fromage3`,`menu_dessert1`,`menu_dessert2`,`menu_dessert3`)
VALUES(
'','".$_GET['semaine']."','".$_GET['jour']."','".($_SESSION['login'])."','".$_POST['menu_entree1']."','".$_POST['menu_entree2']."','".$_POST['menu_entree3']."','".$_POST['menu_entree4']."','".$_POST['menu_resistance1']."','".$_POST['menu_resistance2']."','".$_POST['menu_resistance3']."','".$_POST['menu_resistance4']."','".$_POST['menu_resistance5']."','".$_POST['menu_legume1']."','".$_POST['menu_legume2']."','".$_POST['menu_legume3']."','".$_POST['menu_fromage1']."','".$_POST['menu_fromage2']."','".$_POST['menu_fromage3']."','".$_POST['menu_dessert1']."','".$_POST['menu_dessert2']."','".$_POST['menu_dessert3']."')";
$bdd->query($requete_txt);
////// Menu_legume verife
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][21] == 1)
{
$requete_txt = " UPDATE `menu_utilisateur` SET `menu_legume1` = '',`menu_legume2` = '',`menu_legume3` = '' where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' AND admin_id = '".$_SESSION['login']."' ";
$bdd->query($requete_txt);
}
}
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][22] == 1)
{
$requete_txt = " UPDATE `menu_utilisateur` SET `menu_legume1` = '',`menu_legume2` = '',`menu_legume3` = '' where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' AND admin_id = '".$_SESSION['login']."' ";
$bdd->query($requete_txt);
}
}
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][23] == 1)
{
$requete_txt = " UPDATE `menu_utilisateur` SET `menu_legume1` = '',`menu_legume2` = '',`menu_legume3` = '' where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' AND admin_id = '".$_SESSION['login']."' ";
$bdd->query($requete_txt);
}
}
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][24] == 1)
{
$requete_txt = " UPDATE `menu_utilisateur` SET `menu_legume1` = '',`menu_legume2` = '',`menu_legume3` = '' where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' AND admin_id = '".$_SESSION['login']."' ";
$bdd->query($requete_txt);
}
}
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][25] == 1)
{
$requete_txt = " UPDATE `menu_utilisateur` SET `menu_legume1` = '',`menu_legume2` = '',`menu_legume3` = '' where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' AND admin_id = '".$_SESSION['login']."' ";
$bdd->query($requete_txt);
}
}
hydrus_utils_alert("Votre commande a bien été prise en compte.");
hydrus_utils_redirect("commande_menu.php5");
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
<html>
<head>
<title>Corolle:: Cantine</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-image: url(images/bg.gif);
}
-->
</style>
<link href="styles.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
#Layer1 { position:absolute;
left:257px;
top:8px;
width:297px;
height:77px;
z-index:1;
}
.Style6 {font-family: "Segoe UI"}
.Style8 {font-size: 12}
-->
</style>
</head>
<body onLoad="MM_preloadImages('images/photos1H.gif','images/photos2H.gif','images/photos3H.gif','images/photos4H.gif')">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><table width="773" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images/header.jpg" width="773" height="270"></td>
</tr>
<tr>
<td background="images/menu.jpg"> </td>
</tr>
<tr>
<td><table width="773" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/topBox.gif" width="773" height="18"></td>
</tr>
<tr>
<td valign="top" background="images/bgBox.gif"><table width="773" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="216" valign="top"><table width="216" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="menu">
<div align="center">
<br>
<? hydrus_generate_menu($_SESSION['admin_id'],$bdd); ?> </div></td></tr>
<tr>
<td height="10"><img src="images/separateur.gif" width="216" height="10"></td>
</tr>
</table> </td>
<td width="27"> </td>
<td width="500" valign="top"><p><form method="post">
<input type="hidden" name="valid" value="1" />
<table width="488" border="1">
<tr class="Style4">
<td height="1"><span class="Style27 Style6 Style8">Semaine:</span></td>
<td><label class="Style27 Style6 Style8"><? echo $_GET['semaine']; ?> </label></td>
</tr>
<tr class="Style4">
<td height="1"><span class="Style27 Style6 Style8">Jour:</span></td>
<td><label class="Style27 Style6 Style8"><? echo $_GET['jour']; ?></label></td>
</tr>
<tr class="Style4">
<td width="145" height="68"><span class="Style27 Style6 Style8">Entrées:</span></td>
<td width="386"><span class="Style27 Style6 Style8">
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$entree1 = $result[$i][3];
print("<input type='checkbox' name='menu_entree1' value='".$entree1."' >");
echo $result[$i][3];
}
?>
</label>
<label> <br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$entree2 = $result[$i][4];
print("<input type='checkbox' name='menu_entree2' value='".$entree2."' >");
echo $result[$i][4];
}
?>
<br />
</label>
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$entree3 = $result[$i][5];
print("<input type='checkbox' name='menu_entree3' value='".$entree3."' >");
echo $result[$i][5];
}
?>
<br />
</label>
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$entree4 = $result[$i][6];
print("<input type='checkbox' name='menu_entree4' value='".$entree4."' >");
echo $result[$i][6];
}
?>
</label>
</span></td>
</tr>
<tr class="Style4">
<td height="73"><span class="Style27 Style6 Style8">Plat de Résistance: </span></td>
<td><span class="Style27 Style6 Style8">
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$resistance1 = $result[$i][7];
print("<input type='checkbox' name='menu_resistance1' value='".$resistance1."' >");
echo $result[$i][7];
}
?>
</label>
<label>
<?
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][21] == 1)
{
echo "( Plat Complet)";
}
}
?><br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$resistance2 = $result[$i][8];
print("<input type='checkbox' name='menu_resistance2' value='".$resistance2."' >");
echo $result[$i][8];
}
?>
</label>
<label>
<?
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][22] == 1)
{
echo "( Plat Complet)";
}
}
?>
<br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$resistance3 = $result[$i][9];
print("<input type='checkbox' name='menu_resistance3' value='".$resistance3."' >");
echo $result[$i][9];
}
?>
<?
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][23] == 1)
{
echo "( Plat Complet)";
}
}
?>
<br />
</label>
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$resistance4 = $result[$i][10];
print("<input type='checkbox' name='menu_resistance4' value='".$resistance4."' >");
echo $result[$i][10];
}
?>
<?
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][24] == 1)
{
echo "( Plat Complet)";
}
}
?>
<br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$resistance5 = $result[$i][11];
print("<input type='checkbox' name='menu_resistance5' value='".$resistance5."' >");
echo $result[$i][11];
}
?>
</label>
<?
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][25] == 1)
{
echo "( Plat Complet)";
}
}
?>
</span></td>
</tr>
<tr class="Style4">
<td height="82"><span class="Style27 Style6 Style8">Légumes: </span></td>
<td><span class="Style27 Style6 Style8">
<label></label>
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$legume1 = $result[$i][12];
print("<input type='checkbox' name='menu_legume1' value='".$legume1."' >");
echo $result[$i][12];
}
?>
</label>
<label> <br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$legume2 = $result[$i][13];
print("<input type='checkbox' name='menu_legume2' value='".$legume2."' >");
echo $result[$i][13];
}
?>
<br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$legume3 = $result[$i][14];
print("<input type='checkbox' name='menu_legume3' value='".$legume3."' >");
echo $result[$i][14];
}
?>
</label>
</span></td>
</tr>
<tr class="Style4">
<td height="75"><span class="Style27 Style6 Style8">Fromage : </span></td>
<td><span class="Style27 Style6 Style8">
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$fromage1 = $result[$i][15];
print("<input type='checkbox' name='menu_fromage1' value='".$fromage1."' >");
echo $result[$i][15];
}
?>
<br />
</label>
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$fromage2 = $result[$i][16];
print("<input type='checkbox' name='menu_fromage2' value='".$fromage2."' >");
echo $result[$i][16];
}
?>
<br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$fromage3 = $result[$i][17];
print("<input type='checkbox' name='menu_fromage3' value='".$fromage3."' >");
echo $result[$i][17];
}
?>
</label>
</span></td>
</tr>
<tr class="Style4">
<td height="67"><span class="Style27 Style6 Style8">Dessert: </span></td>
<td><span class="Style27 Style6 Style8">
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$dessert1 = $result[$i][18];
print("<input type='checkbox' name='menu_dessert1' value='".$dessert1."' >");
echo $result[$i][18];
}
?>
<br />
</label>
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$dessert2 = $result[$i][19];
print("<input type='checkbox' name='menu_dessert2' value='".$dessert2."' >");
echo $result[$i][19];
}
?>
<br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$dessert3 = $result[$i][20];
print("<input type='checkbox' name='menu_dessert3' value='".$dessert3."' >");
echo $result[$i][20];
}
?>
</label>
</span></td>
</tr>
<tr>
<td colspan='2'><center class="Style27 Style6 Style8">
<h5>
<input name="submit" type="submit" value="Valider"/>
</h5>
</center></td>
</tr>
</table>
</form></p>
</td>
<td width="30"> </td>
</tr>
</table> </td>
</tr>
<tr>
<td><img src="images/FootBox.gif" width="773" height="25"></td>
</tr>
<tr>
<td><div align="center"><span class="texte">Design par KERLOCH Jean-Philip </span></div></td>
</tr>
</table></td>
</tr>
</table>
<p align="center" class="texte"> </p></td>
</tr>
</table>
</body>
</html>
ca serait cool si vous pouviez m'aider...
Cordialement
Bonjour,
Voici mon problème. Je suis entrain de developper une gestion de cantine en PHP5 et ca fonctionne nickel.. Maintenant le petit soucis que j'ai c'est que si une personne commande un repaset qu'elle prend 2 entrees ca passe or que cela ne devrait pas. pareil pour le plat de resistance etc ...
Je vous donne mon code ..
[php]<?
session_start();
include("hydrus.php5");
if(hydrus_access_valid_admin($_SESSION['login'],$_SESSION['password'],session_id(),$bdd) == false)
{
hydrus_utils_redirect("login.php5");
exit();
}
$error = 0;
if(isset($_POST)==true && $_POST['valid'] == 1)
{
if (
strlen($_POST['menu_entree1']) <= 0 &&
strlen($_POST['menu_entree2']) <= 0 &&
strlen($_POST['menu_entree3']) <= 0 &&
strlen($_POST['menu_entree4']) <= 0 &&
strlen($_POST['menu_resistance1']) <= 0 &&
strlen($_POST['menu_resistance2']) <= 0 &&
strlen($_POST['menu_resistance3']) <= 0 &&
strlen($_POST['menu_resistance4']) <= 0 &&
strlen($_POST['menu_resistance5']) <= 0 ||
// strlen($_POST['menu_legume1']) <= 0 &&
// strlen($_POST['menu_legume2']) <= 0 &&
// strlen($_POST['menu_legume3']) <= 0 ||
strlen($_POST['menu_fromage1']) <= 0 &&
strlen($_POST['menu_fromage2']) <= 0 &&
strlen($_POST['menu_fromage3']) <= 0 &&
strlen($_POST['menu_dessert1']) <= 0 &&
strlen($_POST['menu_dessert2']) <= 0 &&
strlen($_POST['menu_dessert3']) <= 0
)
{$error = 1;
{
hydrus_utils_alert("Il y a surement une erreur");
hydrus_utils_redirect ("commande_menu1.php5?semaine='".$_GET['semaine']."'&jour='".$_GET['jour']."'");
}
}
if($error == 0)
{
$requete_txt = "
INSERT INTO `menu_utilisateur`
(`menu_id`,`menu_semaine`,`menu_jour`,`admin_id`,`menu_entree1`,`menu_entree2`,`menu_entree3`,`menu_entree4`,`menu_resistance1`, `menu_resistance2`,`menu_resistance3`,
`menu_resistance4`,`menu_resistance5`,`menu_legume1`,`menu_legume2`,`menu_legume3`,`menu_fromage1`,`menu_fromage2`,`menu_fromage3`,`menu_dessert1`,`menu_dessert2`,`menu_dessert3`)
VALUES(
'','".$_GET['semaine']."','".$_GET['jour']."','".($_SESSION['login'])."','".$_POST['menu_entree1']."','".$_POST['menu_entree2']."','".$_POST['menu_entree3']."','".$_POST['menu_entree4']."','".$_POST['menu_resistance1']."','".$_POST['menu_resistance2']."','".$_POST['menu_resistance3']."','".$_POST['menu_resistance4']."','".$_POST['menu_resistance5']."','".$_POST['menu_legume1']."','".$_POST['menu_legume2']."','".$_POST['menu_legume3']."','".$_POST['menu_fromage1']."','".$_POST['menu_fromage2']."','".$_POST['menu_fromage3']."','".$_POST['menu_dessert1']."','".$_POST['menu_dessert2']."','".$_POST['menu_dessert3']."')";
$bdd->query($requete_txt);
////// Menu_legume verife
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][21] == 1)
{
$requete_txt = " UPDATE `menu_utilisateur` SET `menu_legume1` = '',`menu_legume2` = '',`menu_legume3` = '' where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' AND admin_id = '".$_SESSION['login']."' ";
$bdd->query($requete_txt);
}
}
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][22] == 1)
{
$requete_txt = " UPDATE `menu_utilisateur` SET `menu_legume1` = '',`menu_legume2` = '',`menu_legume3` = '' where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' AND admin_id = '".$_SESSION['login']."' ";
$bdd->query($requete_txt);
}
}
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][23] == 1)
{
$requete_txt = " UPDATE `menu_utilisateur` SET `menu_legume1` = '',`menu_legume2` = '',`menu_legume3` = '' where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' AND admin_id = '".$_SESSION['login']."' ";
$bdd->query($requete_txt);
}
}
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][24] == 1)
{
$requete_txt = " UPDATE `menu_utilisateur` SET `menu_legume1` = '',`menu_legume2` = '',`menu_legume3` = '' where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' AND admin_id = '".$_SESSION['login']."' ";
$bdd->query($requete_txt);
}
}
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][25] == 1)
{
$requete_txt = " UPDATE `menu_utilisateur` SET `menu_legume1` = '',`menu_legume2` = '',`menu_legume3` = '' where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' AND admin_id = '".$_SESSION['login']."' ";
$bdd->query($requete_txt);
}
}
hydrus_utils_alert("Votre commande a bien été prise en compte.");
hydrus_utils_redirect("commande_menu.php5");
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
<html>
<head>
<title>Corolle:: Cantine</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-image: url(images/bg.gif);
}
-->
</style>
<link href="styles.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
#Layer1 { position:absolute;
left:257px;
top:8px;
width:297px;
height:77px;
z-index:1;
}
.Style6 {font-family: "Segoe UI"}
.Style8 {font-size: 12}
-->
</style>
</head>
<body onLoad="MM_preloadImages('images/photos1H.gif','images/photos2H.gif','images/photos3H.gif','images/photos4H.gif')">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><table width="773" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images/header.jpg" width="773" height="270"></td>
</tr>
<tr>
<td background="images/menu.jpg"> </td>
</tr>
<tr>
<td><table width="773" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/topBox.gif" width="773" height="18"></td>
</tr>
<tr>
<td valign="top" background="images/bgBox.gif"><table width="773" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="216" valign="top"><table width="216" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="menu">
<div align="center">
<br>
<? hydrus_generate_menu($_SESSION['admin_id'],$bdd); ?> </div></td></tr>
<tr>
<td height="10"><img src="images/separateur.gif" width="216" height="10"></td>
</tr>
</table> </td>
<td width="27"> </td>
<td width="500" valign="top"><p><form method="post">
<input type="hidden" name="valid" value="1" />
<table width="488" border="1">
<tr class="Style4">
<td height="1"><span class="Style27 Style6 Style8">Semaine:</span></td>
<td><label class="Style27 Style6 Style8"><? echo $_GET['semaine']; ?> </label></td>
</tr>
<tr class="Style4">
<td height="1"><span class="Style27 Style6 Style8">Jour:</span></td>
<td><label class="Style27 Style6 Style8"><? echo $_GET['jour']; ?></label></td>
</tr>
<tr class="Style4">
<td width="145" height="68"><span class="Style27 Style6 Style8">Entrées:</span></td>
<td width="386"><span class="Style27 Style6 Style8">
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$entree1 = $result[$i][3];
print("<input type='checkbox' name='menu_entree1' value='".$entree1."' >");
echo $result[$i][3];
}
?>
</label>
<label> <br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$entree2 = $result[$i][4];
print("<input type='checkbox' name='menu_entree2' value='".$entree2."' >");
echo $result[$i][4];
}
?>
<br />
</label>
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$entree3 = $result[$i][5];
print("<input type='checkbox' name='menu_entree3' value='".$entree3."' >");
echo $result[$i][5];
}
?>
<br />
</label>
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$entree4 = $result[$i][6];
print("<input type='checkbox' name='menu_entree4' value='".$entree4."' >");
echo $result[$i][6];
}
?>
</label>
</span></td>
</tr>
<tr class="Style4">
<td height="73"><span class="Style27 Style6 Style8">Plat de Résistance: </span></td>
<td><span class="Style27 Style6 Style8">
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$resistance1 = $result[$i][7];
print("<input type='checkbox' name='menu_resistance1' value='".$resistance1."' >");
echo $result[$i][7];
}
?>
</label>
<label>
<?
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][21] == 1)
{
echo "( Plat Complet)";
}
}
?><br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$resistance2 = $result[$i][8];
print("<input type='checkbox' name='menu_resistance2' value='".$resistance2."' >");
echo $result[$i][8];
}
?>
</label>
<label>
<?
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][22] == 1)
{
echo "( Plat Complet)";
}
}
?>
<br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$resistance3 = $result[$i][9];
print("<input type='checkbox' name='menu_resistance3' value='".$resistance3."' >");
echo $result[$i][9];
}
?>
<?
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][23] == 1)
{
echo "( Plat Complet)";
}
}
?>
<br />
</label>
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$resistance4 = $result[$i][10];
print("<input type='checkbox' name='menu_resistance4' value='".$resistance4."' >");
echo $result[$i][10];
}
?>
<?
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][24] == 1)
{
echo "( Plat Complet)";
}
}
?>
<br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$resistance5 = $result[$i][11];
print("<input type='checkbox' name='menu_resistance5' value='".$resistance5."' >");
echo $result[$i][11];
}
?>
</label>
<?
$requete_txt = "SELECT * from menu where menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
if ($result[$i][25] == 1)
{
echo "( Plat Complet)";
}
}
?>
</span></td>
</tr>
<tr class="Style4">
<td height="82"><span class="Style27 Style6 Style8">Légumes: </span></td>
<td><span class="Style27 Style6 Style8">
<label></label>
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$legume1 = $result[$i][12];
print("<input type='checkbox' name='menu_legume1' value='".$legume1."' >");
echo $result[$i][12];
}
?>
</label>
<label> <br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$legume2 = $result[$i][13];
print("<input type='checkbox' name='menu_legume2' value='".$legume2."' >");
echo $result[$i][13];
}
?>
<br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$legume3 = $result[$i][14];
print("<input type='checkbox' name='menu_legume3' value='".$legume3."' >");
echo $result[$i][14];
}
?>
</label>
</span></td>
</tr>
<tr class="Style4">
<td height="75"><span class="Style27 Style6 Style8">Fromage : </span></td>
<td><span class="Style27 Style6 Style8">
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$fromage1 = $result[$i][15];
print("<input type='checkbox' name='menu_fromage1' value='".$fromage1."' >");
echo $result[$i][15];
}
?>
<br />
</label>
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$fromage2 = $result[$i][16];
print("<input type='checkbox' name='menu_fromage2' value='".$fromage2."' >");
echo $result[$i][16];
}
?>
<br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$fromage3 = $result[$i][17];
print("<input type='checkbox' name='menu_fromage3' value='".$fromage3."' >");
echo $result[$i][17];
}
?>
</label>
</span></td>
</tr>
<tr class="Style4">
<td height="67"><span class="Style27 Style6 Style8">Dessert: </span></td>
<td><span class="Style27 Style6 Style8">
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$dessert1 = $result[$i][18];
print("<input type='checkbox' name='menu_dessert1' value='".$dessert1."' >");
echo $result[$i][18];
}
?>
<br />
</label>
<label>
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$dessert2 = $result[$i][19];
print("<input type='checkbox' name='menu_dessert2' value='".$dessert2."' >");
echo $result[$i][19];
}
?>
<br />
<?
$requete_txt = "SELECT DISTINCT * FROM `menu` WHERE menu_jour = '".$_GET['jour']."' AND menu_semaine = '".$_GET['semaine']."' ";
$result = $bdd->result_to_array($bdd->query($requete_txt));
for($i=0;$i<count($result);$i++)
{
$dessert3 = $result[$i][20];
print("<input type='checkbox' name='menu_dessert3' value='".$dessert3."' >");
echo $result[$i][20];
}
?>
</label>
</span></td>
</tr>
<tr>
<td colspan='2'><center class="Style27 Style6 Style8">
<h5>
<input name="submit" type="submit" value="Valider"/>
</h5>
</center></td>
</tr>
</table>
</form></p>
</td>
<td width="30"> </td>
</tr>
</table> </td>
</tr>
<tr>
<td><img src="images/FootBox.gif" width="773" height="25"></td>
</tr>
<tr>
<td><div align="center"><span class="texte">Design par KERLOCH Jean-Philip </span></div></td>
</tr>
</table></td>
</tr>
</table>
<p align="center" class="texte"> </p></td>
</tr>
</table>
</body>
</html>
[/php]
ca serait cool si vous pouviez m'aider...
Cordialement