Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- int main(int argc, char ** argv){
- MYSQL *conn;
- bddConnect(&conn);
- functionAddToStruct(conn);
- ...................
- }
- void bddConnect(MYSQL **conn){
- //Connexion A la bdd de facon plus sofistiquer
- static char *host = "localhost";
- static char *user = "root";
- static char *password = "";
- static char *dbname = "training_life";
- unsigned int port = 3306;
- static char *unix_socket = NULL;
- unsigned int flag = 0;
- *conn = mysql_init(NULL);
- if(!(mysql_real_connect(*conn, host, user, password, dbname, port, unix_socket, flag))){
- fprintf(stderr, "\n Error : %s [%d]\n", mysql_error(conn), mysql_errno(conn));
- exit(1);
- }
- printf("Connexion Successful ! ");
- }
- ------------------------------------
- // exemple d'utilisation :
- void functionAddToStruct(MYSQL *conn){
- MYSQL_RES *res;
- MYSQL_ROW row;
- char *sqlExercice[500];
- //Afficher tout le tableau
- // for(int i;i=0;i++){
- int min=241;
- int max=281;
- for(int i=min;i<max;i++){
- sprintf(sqlExercice,"SELECT * FROM list_exercice WHERE id=%d",i);
- // printf("%s",sqlExercice);
- mysql_query(conn,sqlExercice);
- res = mysql_store_result(conn);
- while(row = mysql_fetch_row(res)){
- // printf("\n%s\t%s\n", row[0], row[1]);
- if(i<min+5|| (i>min+19&&i<min+24))
- addExercice(&start2,start,row[1],row[2],"Jambe");
- else if(i<min+9|| (i>min+23&&i<min+28))
- addExercice(&start2,start,row[1],row[2],"Pec");
- else if(i<min+13|| (i>min+27&&i<min+32))
- addExercice(&start2,start,row[1],row[2],"Epaule");
- else if(i<min+17|| (i>min+31&&i<min+36))
- addExercice(&start2,start,row[1],row[2],"Bras");
- else
- addExercice(&start2,start,row[1],row[2],"Dos");
- }
- }
- for(int w=0;w<40;w++){
- printf("\n name : %s ------------%d------------- muscle : %s",start2->name,w,start2->muscleTest->label);
- start2=start2->next->next;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement