Bonjour, je dois utiliser l'API de mysql pour pouvoir communiquer avec ma base, cependant le programme plante quand la fonction mysql_store_result est appelée. (fonction?!)
Quelqu'un saurait pourquoi? merci
voilà le code en question.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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 #include <stdio.h> #include <stdlib.h> #include <winsock.h> #include <mysql/mysql.h> int main(void){ MYSQL mysql; mysql_init(&mysql); mysql_options(&mysql,MYSQL_READ_DEFAULT_GROUP,"option"); if(mysql_real_connect(&mysql,"localhost","root","root","test",0,NULL,0)){ mysql_query(&mysql, "SELECT * FROM test"); MYSQL_RES *result = NULL; MYSQL_ROW row; unsigned int i = 0; unsigned int num_champs = 0; result = mysql_store_result(&mysql); num_champs = mysql_num_fields(result); system("pause"); while ((row = mysql_fetch_row(result))){ unsigned long *lengths; lengths = mysql_fetch_lengths(result); for(i = 0; i < num_champs; i++){ printf("[%.*s] ", (int) lengths[i], row[i] ? row[i] : "NULL"); } printf("\n"); } system("pause"); mysql_free_result(result); mysql_close(&mysql); } else{ printf("stop"); } return 0; }
Partager