1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
| char esp[30]="tortue";
printf("%s",esp);//Contrôle si esp contient bien "tortue"
MYSQL mysql;
//Initialisation
mysql_init(&mysql);
mysql_options(&mysql, MYSQL_READ_DEFAULT_GROUP,"option");
//Ouverture de la connexion
if(mysql_real_connect(&mysql, "localhost", "root", "paolo4vigo", "game",0,NULL,0 ))
{
//Requete qui fonctionne
//mysql_query(mysql, "SELECT * FROM animal WHERE espece = 'chat'");
//Requete qui fonctionne
char requete[150];
//sprintf (requete,"SELECT * FROM animal WHERE espece = ('%s')","chat");
//Requete qui ne fonctionne pas (liste vide)
sprintf (requete,"SELECT * FROM animal WHERE espece = ('%s')", esp);
mysql_query(&mysql, requete); |
