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 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137
| <?php
// Appel de l'Entête de Page
include('include/header.php');
function selected($i, $rowPar)
{
if ($i == 1)
{
$select = ( $id_marque1 == $rowPar ) ? ' selected="selected"' : '';
}
else if ($i == 2)
{
$select = ( $id_marque2 == $rowPar ) ? ' selected="selected"' : '';
}
else if ($i == 3)
{
$select = ( $id_marque3 == $rowPar ) ? ' selected="selected"' : '';
}
else if ($i == 4)
{
$select = ( $id_marque4 == $rowPar) ? ' selected="selected"' : '';
}
else if ($i == 5)
{
$select = ( $id_marque5 == $rowPar ) ? ' selected="selected"' : '';
}
return $select;
}
?>
<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr> <br>
<br>
<td colspan="4" align="center" class="txt2">TITRE</td>
</tr>
<tr>
<td colspan="4"> </td>
</tr>
<tr>
<td width="2%"> </td>
<td width="14%"> </td>
<td width="54%"> </td>
<td width="30%" class="champs">Afficher le logo</td>
</tr>
<?php
$i = 1;
$id_marque1 = ( isset($_POST['id_marque1']) ) ? intval($_POST['id_marque1']) : 0;
$id_marque2 = ( isset($_POST['id_marque2']) ) ? intval($_POST['id_marque2']) : 0;
$id_marque3 = ( isset($_POST['id_marque3']) ) ? intval($_POST['id_marque3']) : 0;
$id_marque4 = ( isset($_POST['id_marque4']) ) ? intval($_POST['id_marque4']) : 0;
$id_marque5 = ( isset($_POST['id_marque5']) ) ? intval($_POST['id_marque5']) : 0;
while ($i<6)
{
?>
<form name="form<?php echo $i; ?>" action="produit.php" method="POST">
<tr>
<td class="txt"><?php echo $i; ?></td>
<td style="padding-left:10px" class="txt"><select name="id_marque<?php echo $i; ?>" class="required2" onChange="this.form.submit();">
<option value="0">Choisir une Partie</option>
<?php
$sqlPar = "SELECT id_marque, nom FROM marque ORDER BY id_marque ASC";
$affPar = mysql_query($sqlPar, $connexion_bdd) or die(mysql_error());
while( $rowPar = mysql_fetch_assoc($affPar) )
{
$select = selected($i, $rowPar['id_marque']);
echo '<option value="' . $rowPar['id_marque'] . '" ' . $select . '>' . $rowPar['nom'] . '</option>';
}
mysql_free_result($affPar);
?>
</select></td>
<td style="padding-left:20px"><select name="id_prod<?php echo $i; ?>" class="required2">
<option value="0" selected>Choisir un produit</option>
<?php
if( !empty($id_marque))
{
if ($i == 1)
{
$sqlPar = 'SELECT id_prod, nom, id_marque FROM produit WHERE id_marque=' . $id_marque1;
}
else if ($i == 2)
{
$sqlPar = 'SELECT id_prod, nom, id_marque FROM produit WHERE id_marque=' . $id_marque2;
}
else if ($i == 3)
{
$sqlPar = 'SELECT id_prod, nom, id_marque FROM produit WHERE id_marque=' . $id_marque3;
}
else if ($i == 4)
{
$sqlPar = 'SELECT id_prod, nom, id_marque FROM produit WHERE id_marque=' . $id_marque4;
}
else if ($i == 5)
{
$sqlPar = 'SELECT id_prod, nom, id_marque FROM produit WHERE id_marque=' . $id_marque5;
}
$affPar = mysql_query($sqlPar, $connexion_bdd) or die(mysql_error());
while( $rowPar = mysql_fetch_assoc($affPar) )
{
$select = ( $id_prod == $rowPar['id_prod'] ) ? ' selected="selected"' : '';
echo '<option value="' . $rowPar['id_prod'] . '" ' . $select . '>' . $rowPar['nom'] . '</option>';
}
mysql_free_result($affPar);
}
?>
</select>
</td>
<td class="champs"><input type="radio" name="logo<?php echo $i; ?>" value="1">
oui </td>
</tr> </form>
<?php
$i ++;
}
?>
<tr>
<td colspan="4" align="center" class="txt2"> </td>
</tr>
<tr>
<td class="message" colspan="5"></td>
</tr>
</table>
<br>
<br>
<br>
</div>
<?php
// Appel du Pied de Page
include('include/footer.php');
?> |
Partager