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
| <?
$serveur="localhost";
$admin="kkkk";
$motpasse="kkkk";
$base_donnees="projet_kkkkk";
$connexion=mysql_connect($serveur,$admin,$motpasse);
mysql_select_db($base_donnees,$connexion);
function requete_SQL($strSQL) {
$result = mysql_query($strSQL);
if (!$result) {
$message = 'erreur db';
die($message);
}
return $result;
}
function deconnexion()
{
mysql_close();
}
function afficherAdherent()
{
$strSQL="SELECT `ResidentCIN`, `ResidentNom`, `ResidentPrenoms`, `ResidentAdresse`, `ResidentVille`, `ResidentPays`, `ResidentSexe`, `ResidentTelPersonnel`, `ResidentTelDomicile`, `ResidentAdresseMail`, `ResidentUniversite`, `ResidentFaculte`, `ResidentAnneeEtude`, `ResidentObservations` FROM `reservations` ";
$resultat = requete_SQL($strSQL);
return $resultat;
}
function ajouterAdherent($c,$n,$pr,$a,$v,$p,$s,$tp,$td,$m,$u,$f,$ae,$o)
{
$strSQL="INSERT INTO `projet_maamora`.`reservations` (`ResidentNumAuto`, `ResidentCIN`, `ResidentNom`, `ResidentPrenoms`, `ResidentAdresse`, `ResidentVille`, `ResidentPays`, `ResidentSexe`, `ResidentTelPersonnel`, `ResidentTelDomicile`, `ResidentAdresseMail`, `ResidentUniversite`, `ResidentFaculte`, `ResidentAnneeEtude`, `ResidentObservations`, `ResidentDateCreation`) VALUES (null,'$c','$n','$pr','$a','$v','$p','$s','$tp','$td','$m','$u','$f','$ae','$o','');";
$resultat = requete_SQL($strSQL);
return $resultat;
}
function afficherAdherentByLogin($c)
{
$strSQL="SELECT `ResidentCIN`, `ResidentNom`, `ResidentPrenoms`, `ResidentAdresse`, `ResidentVille`, `ResidentPays`, `ResidentSexe`, `ResidentTelPersonnel`, `ResidentTelDomicile`, `ResidentAdresseMail`, `ResidentUniversite`, `ResidentFaculte`, `ResidentAnneeEtude`, `ResidentObservations` FROM `reservations` where `ResidentCIN`='$c'";
$resultat = requete_SQL($strSQL);
return $resultat;
}
function afficherAdherentById($id)
{
$strSQL="SELECT `ResidentCIN`, `ResidentNom`, `ResidentPrenoms`, `ResidentAdresse`, `ResidentVille`, `ResidentPays`, `ResidentSexe`, `ResidentTelPersonnel`, `ResidentTelDomicile`, `ResidentAdresseMail`, `ResidentUniversite`, `ResidentFaculte`, `ResidentAnneeEtude`, `ResidentObservations` FROM `reservations` where `ResidentNumAuto`=".$id;
$resultat = requete_SQL($strSQL);
return $resultat;
}
function verifierAdherent($c)
{
$strSQL="SELECT `ResidentCIN`, `ResidentNom`, `ResidentPrenoms`, `ResidentAdresse`, `ResidentVille`, `ResidentPays`, `ResidentSexe`, `ResidentTelPersonnel`, `ResidentTelDomicile`, `ResidentAdresseMail`, `ResidentUniversite`, `ResidentFaculte`, `ResidentAnneeEtude`, `ResidentObservations` FROM `reservations` where `ResidentCIN`='$c' " ;
$resultat2 = requete_SQL($strSQL);
$retour = mysql_num_rows($resultat2);
return $retour;
}
function supprimerById($id)
{
$strSQL="delete FROM `reservations` where `ResidentNumAuto`=".$id;
$resultat = requete_SQL($strSQL);
return $resultat;
}
function modifierAdherent($c,$n,$pr,$a,$v,$p,$s,$tp,$td,$m,$u,$f,$ae,$o)
{
$strSQL="UPDATE `reservations` SET `ResidentCIN`='$c', `ResidentNom`='$n', `ResidentPrenoms`='$pr', `ResidentAdresse`='$a', `ResidentVille`='$v', `ResidentPays`='$p', `ResidentSexe`='$s', `ResidentTelPersonnel`='$tp', `ResidentTelDomicile`='$td', `ResidentAdresseMail`='$m', `ResidentUniversite`='$u', `ResidentFaculte`='$f', `ResidentAnneeEtude`='$ae', `ResidentObservations`='$o' WHERE `admin`.`id` =".$i;
$resultat = requete_SQL($strSQL);
return $resultat;
}
?> |
Erreur de syntaxe
Répondre avec citation
Partager