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
| function ModifierMembre()
{
$PageEnCours=$_SERVER['PHP_SELF'];
$dbh = new PDO('mysql:host=localhost;dbname=toto','tata,'titi');
$id=$_GET['id'];
$login=$_GET['login'];
$level=$_GET['level'];
$tab=<<<EOT
<form action="" method="GET"> <table border=1>
EOT;
$req1=$dbh->prepare("SELECT * FROM testig1 WHERE id=:id");
$req1->bindParam(':id',$id,PDO::PARAM_INT);
$req1->execute();
while($row = $req1->fetch())
{
$tab.=<<<EOT
<tr>
<td><font face="diavlo">{$row['login']}</font></td>
<td><input type="text" name="login" value="{$row['login']}"/></td>
<td><font face="diavlo">{$row['level']}</font></td>
<td><input type="text" name="level" value="{$row['level']}"/></td>
<td><input type="submit" name="envoyer" value="envoyer"><input type="hidden" name="id" value="{$row['id']}" /></td>
</tr>
EOT;
}
$tab.="</table></form>";
return $tab;
if(isset($_GET['envoyer']))
{
$dbh = new PDO('mysql:host=localhost;dbname=toto','tata','titi');
$sql=$dbh->prepare("UPDATE testig1 SET login=:login, level=:level WHERE id=:id'");
$sql->bindParam(':login',$_GET['login'],PDO::PARAM_STR);
$sql->bindParam(':level',$_GET['level'],PDO::PARAM_INT);
$sql->bindParam(':id',$_GET['id'],PDO::PARAM_INT);
$sql->execute();
$body= ModifierMembre();
return $body;
}
} |
