Bonjour,
je ne suis pas du tout programmeur mais il faut que fasse un exe qui me permette d'insérer des datas dans une base mysql.
Tout d'abors j'aimerais déjà arriver à me connecter à cette base. Pour cela j'ai récuperer ce script mais il y a une erreur et je ne comprends pas.... :-(
//-----------------------------------------------------------------------------
#include <windows.h>
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include "C:\Dev-Cpp\include\mysql\include\mysql.h"
//-----------------------------------------------------------------------------
static void exiterr(int exitcode);
//-----------------------------------------------------------------------------
MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW row;
//-----------------------------------------------------------------------------
int main(){
unsigned int i = 0;
if (!(mysql_connect(&mysql,"localhost","root","")))
exiterr(1);
if (mysql_select_db(&mysql,"planning"))
exiterr(2);
if (mysql_query(&mysql,"SELECT * FROM personnel"))
exiterr(3);
if (!(res = mysql_store_result(&mysql)))
exiterr(4);
while((row = mysql_fetch_row(res))) {
for (i=0 ; i < mysql_num_fields(res); i++){
printf("%s ",row[i]);
}
printf("\n");
}
if (!mysql_eof(res))
exiterr(5);
mysql_free_result(res);
mysql_close(&mysql);
printf("\n\nStrike any key to exit :");
getchar();
}
//-----------------------------------------------------------------------------
static void exiterr(int exitcode){
fprintf( stderr, "%s\n", mysql_error(&mysql) );
printf("Strike ENTER to exit");
getchar();
exit( exitcode );
}
//-----------------------------------------------------------------------------
//-----------------------------------------------------------------------------
Et voilà les erreurs que j'ai
C:\DOCUME~1\DUPRAT~1.RDT\LOCALS~1\Temp\ccktbaaa.o(.text+0x51) In function `main':
[Linker error] undefined reference to
`mysql_connect@16' [Linker error] undefined reference to
`mysql_select_db@8' [Linker error] undefined reference to
`mysql_query@8' [Linker error] undefined reference to
`mysql_store_result@4' [Linker error] undefined reference to
`mysql_fetch_row@4' [Linker error] undefined reference to
`mysql_num_fields@4' [Linker error] undefined reference to
`mysql_eof@4' [Linker error] undefined reference to
`mysql_free_result@4' [Linker error] undefined reference to
`mysql_close@4' C:\DOCUME~1\DUPRAT~1.RDT\LOCALS~1\Temp\ccktbaaa.o(.text+0x1b0) In function `exiterr':
[Linker error] undefined reference to
`mysql_error@4' C:\DOCUME~1\DUPRAT~1.RDT\LOCALS~1\Temp\ccktbaaa.o(.text+0x1b0) ld returned 1 exit status
HELP PLEASE!!!!...