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
|
<?php>
$serveur = "sql.free.fr";
$login = "login";
$pass = "mdp";
$nom_cl = $_POST['nom_cl'];
$prenom_cl = $_POST['prenom_cl'];
$localisation = $_POST['localisation'];
$typelog = $_POST['typelog'];
$statut = $_POST['statut'];
$acces_1 = $_POST['acces_1'];
$acces_2 = $_POST['acces_2'];
$acces_3 = $_POST['acces_3'];
$acces_4 = $_POST['acces_4'];
try
{
$connexion = new PDO("mysql:host=$serveur;dbname=visdom;charset=UTF8", $login, $pass);
$connexion -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$requete = $connexion->prepare("UPDATE visdom SET (nom_cl,prenom_cl,localisation,typelog,statut,acces_1,acces_2,acces_3,acces_4)
VALUES (:nom_cl,:prenom_cl,:localisation,:typelog,:statut,:acces_1,:acces_2,:acces_3,:acces_4)
WHERE nom_cl=':nom_cl' AND prenom_cl= ':prenom_cl");
$requete->bindParam(":nom_cl", $nom_cl);
$requete->bindParam(":prenom_cl", $prenom_cl);
$requete->bindParam(":localisation", $localisation);
$requete->bindParam(":typelog", $typelog);
$requete->bindParam(":statut", $statut);
$requete->bindParam(":acces_1", $acces_1);
$requete->bindParam(":acces_2", $acces_2);
$requete->bindParam(":acces_3", $acces_3);
$requete->bindParam(":acces_4", $acces_4);
$requete->execute();
}
catch(PDOException $e)
{
echo 'Echec de la connexion : ' .$e->getMessage();
}
?> |
