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>';
}
?> |
