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
|
void Requete_ecrire(char client[15],char ip[15])
{
MYSQL *mySQL;
mySQL = mysql_init(NULL);
if (!mysql_real_connect( mySQL,"mysql.alwaysdata.com","***","****","****",0,NULL,0))
{
ShowMessage("Erreur de connexion à la base de données !");
}
else
{
char *reqSQL= new char [100]; // Taille de la requête.
sprintf (reqSQL, "SELECT * FROM bdd WHERE client = '%s'", client);
mysql_query (mySQL, reqSQL);
MYSQL_RES *myRES = mysql_store_result (mySQL);
if(mysql_num_rows(myRES) != 0)
{
sprintf(reqSQL,"UPDATE bdd SET ip='%s' WHERE client='%s')",ip,client);
if (mysql_query (mySQL, reqSQL) != 0)
MessageBox(NULL,"Impossible de modifier le client.","Erreur: Modification dans la BDD.",MB_OK |MB_ICONERROR);
}
else
{
sprintf(reqSQL,"INSERT INTO bdd (client,ip) VALUES ('%s','%s')",client,ip);
if (mysql_query (mySQL, reqSQL) != 0)
MessageBox(NULL,"Impossible d'enregistrer un nouveau client.","Erreur: Ecriture dans la BDD.",MB_OK |MB_ICONERROR);
}
}
mysql_close (mySQL);
} |
