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
| <?
$hote = "localhost";
$login = "aaaa";
$mdp = "bbb";
$base= "ccc";
mysql_connect($hote, $login, $mdp) or die ("Impossible de se connecter au serveur");
mysql_select_db($base) or die ("Impossible de récupérer la base de données");
$nom=strtoupper(rawurlencode($_POST[nom]));
$prenom=rawurlencode($_POST[prenom]);
$ville=strtoupper(rawurlencode($_POST[ville]));
$adr=rawurlencode(nl2br($_POST[adresse]));
$code=rawurlencode($_POST[codepostal]);
$tel=rawurlencode($_POST[tel]);
$query="SELECT * FROM clients WHERE nom='$nom' AND prenom='$prenom'";
$result=mysql_query($query);
$nb=mysql_num_rows($result);
if ($nb==0) {
$queryA="INSERT INTO `clients` ( `cli_id` , `nom` , `prenom` , `adresse` , `code` , `ville` , `tel` , `mail` , `prov` , `ip` , `origine` , `abon` )
VALUES ('', '$nom', '$prenom', '$adr', '$code', '$ville', '$tel', '$_POST[email]', '".$_POST[prov]."', '$REMOTE_ADDR', '$HTTP_REFERER', '')";
mysql_query($queryA);
$queryB="SELECT * FROM clients WHERE nom='$nom' AND prenom='$prenom'";
$resultB=mysql_query($queryB);
$rowB=mysql_fetch_array($resultB);
$cli_id=$rowB[cli_id];
.... |
