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
| <?php
include('include/MySQL.php');
$cnx=connect();
if (!isset($_POST['id']))
{
$id=0;
echo"effacement<br/>";
echo '<form action="accesv2.php" method="post">';
echo'<input type="hidden" name="id" value="'.$id.'">';
echo'<input type="submit" name="continuer" value="continuer">';
echo'</form>';
}
else
{
$req_rap= "select nom from utilisateur where isRAP=1";
$res=sendSQL($cnx,$req_rap);
$test=mysql_num_rows($res);
$query="select idchiffrage from chiffrage";
$resultat=sendSQL($cnx,$query);
$nbr=mysql_num_rows($resultat);
$n=$_POST['id'];
$id=$n+100;
$nbr_req=1;
echo '<table>
<tr><td>';
$i=0;
while($test>$i)
{
$nom=mysql_result($res,$i,0);
while($n <= ($nbr-1) and $n < $id)
{
$idchiffrage=mysql_result($resultat,$n,'idchiffrage');
$query="insert into acces (id_acces, idchiffrage, nom, droit) values ('',$idchiffrage ,$nom,'lecture/ecriture')";
$res=sendSQL($cnx,$query);
echo "chiffrage n° $idchiffrage -- ";
echo "n° $n <br/>";
$n++;
$nbr_req=$nbr_req+5;
}
$i++;
}
echo "$nbr_req requetes sql <br/>";
echo '</td>';
echo'<td VALIGN=TOP align=center>';
if($n!=$nbr)
{
echo '<form action="accesv2.php" method="post">';
echo'<input type="hidden" name="id" size="6" value="'.$id.'">';
echo'<input type="submit" name="continuer" value="continuer">';
echo'</form>';
}
else
{
echo "<b> les acces ont été redistribués </b>";
}
echo'</td></tr></table>';
}
?> |
Partager