API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 27th, 2019
93
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.20 KB | None | 0 0
raw download clone embed print report
  1. #include <stdio.h>
  2. #include <stdlib.h>
  3. #include <winsock.h>
  4. #include <MYSQL/mysql.h>
  5. #include "header.h"
  6.  
  7. MYSQL *conn;
  8.  
  9.  
  10. int addMuscle(Muscle ** start,int selected,char * label){
  11. Muscle * inter;
  12. inter=malloc(sizeof(Muscle) * MAX_PATH+1);
  13. if(inter==NULL) return 0;
  14. inter->selected=selected;
  15.  
  16. inter->label=label;
  17. inter->next=*start;
  18. *start=inter;
  19. return 1 ;
  20. }
  21.  
  22. void functionAddToStruct(MYSQL *conn){
  23. Muscle * start=NULL;
  24. addMuscle(&start,1, "Jambe" );
  25. addMuscle(&start,1, "Dos" );
  26. addMuscle(&start,0, "Pec" );
  27. addMuscle(&start,0, "Epaule" );
  28. addMuscle(&start,0, "Bras" );
  29.  
  30.  
  31.  
  32.  
  33. Exercice * start2=NULL;
  34. //addExercice(&start2,start,"b","bDef","dos");
  35. //addExercice(&start2,start,"c","cDef","pec");
  36. //addExercice(&start2,start,"d","dDef","epaule");
  37. //addExercice(&start2,start,"e","eDef","bras");
  38. // showExo (start2, -1);
  39.  
  40.  
  41. MYSQL_RES *res;
  42. MYSQL_ROW row;
  43. char *sqlExercice[500];
  44. //Afficher tout le tableau
  45. // for(int i;i=0;i++){
  46. int min=241;
  47. int max=281;
  48. for(int i=min;i<=max;i++){
  49.  
  50. sprintf(sqlExercice,"SELECT * FROM list_exercice WHERE id=%d",i);
  51. // printf("%s",sqlExercice);
  52. mysql_query(conn,sqlExercice);
  53. res = mysql_store_result(conn);
  54.  
  55. while(row = (mysql_fetch_row(res))){
  56. // printf("\n%s\t%s\n", row[0], row[1]);
  57. if(i<min+5|| ( i>min+19 && i<min+24 ) )
  58. addExercice(&start2,start,row[1],row[2],"Jambe");
  59. else if(i<min+9|| (i>min+23&&i<min+28))
  60. addExercice(&start2,start,row[1],row[2],"Pec");
  61. else if(i<min+13|| (i>min+27&&i<min+32))
  62. addExercice(&start2,start,row[1],row[2],"Epaule");
  63. else if(i<min+17|| (i>min+31&&i<min+36))
  64. addExercice(&start2,start,row[1],row[2],"Bras");
  65. else
  66. addExercice(&start2,start,row[1],row[2],"Dos");
  67. }
  68. }
  69.  
  70.  
  71. while (start2 != NULL) {
  72. printf("\n -----------------WHILE 1 ----------- ", start2->name);
  73. printf("\n %s start2->name \t ", start2->name);
  74. printf("\n %s start2->name \t ", start2->name);
  75.  
  76. start2 = start2->next;
  77. }
  78. printf("WHILE 1 FINIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII");
  79. while (start2 != NULL) {
  80. if(!start2->muscleTest->selected){
  81. start2=deleteExercice(start2);
  82. }
  83. start2 = start2->next;
  84. } printf("DELETE FINIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII");
  85.  
  86.  
  87. while (start2 != NULL) { printf("\n -----------------WHILE 2 ----------- ", start2->name);
  88.  
  89. printf("\n %s start2->name \t ", start2->name);
  90.  
  91. start2 = start2->next;
  92. }
  93.  
  94.  
  95.  
  96. if(start2!=NULL)printf("mbite");
  97. printf("\n<----start2----ANTO---------->%p \t ", start2);
  98. printf("\n<---start2->description----ANTO---------->%s \t ", start2->description);
  99. printf("\n<---start2->muscleTestlabel-----ANTO---------->%p \t ", start2->muscleTest);
  100. printf("\n<---start2->namelabel-----ANTO---------->%s \t ", start2->name);
  101. printf("\n<----start2->next----ANTO---------->%p \t ", start2->next);
  102.  
  103.  
  104. while (start != NULL) {
  105. if(start->selected){
  106. printf("\n------------------IN THE FIRST WHILE / WITH THE IF-------------------------\n");
  107. printf("\n %s start->label \t ", start->label);
  108. printf(" %d start->selected \n", start->selected);
  109. type1(1,start2,start,1);
  110. }
  111. start = start->next;
  112. }
  113.  
  114.  
  115.  
  116. }
  117.  
  118.  
  119. int type1(int day, Exercice * exercice,Muscle * muscle,int nb_muscle){
  120.  
  121. printf("%d",day);
  122. printf("\nexercice->name:%s",exercice->name);
  123. printf("\nmuscle->name :%s ",muscle->label);
  124.  
  125. printf("\n -______________testsStart1________________-");
  126.  
  127. int j=1;
  128. int i=0;
  129. if (nb_muscle == 2){
  130. i = 2;
  131. }
  132.  
  133. if (nb_muscle > 3)
  134. i = 3;
  135.  
  136.  
  137. printf("\nmuscle->name :%s ",muscle->label);
  138. int test=strcmp(test,"Bras");
  139. printf("\n %s = 'Bras' \n",muscle->label);
  140. printf("\n test = %d \n",test);
  141. while(j!=day+1)
  142. {
  143. printf("\n -______________IN THE WHILE________________- \n");
  144. printf("\n __day = %d // j = %d // i = %d__ \n",day,j,i);
  145.  
  146. if (strcmp(muscle->label,"Jambe") ==0){
  147. if (i == 0)
  148. printf("Jour : %d --------------------------------- \n",j);
  149. while(i!=4){
  150. printf("titre : %s description : %s\n",j,exercice->name,exercice->description);
  151. exercice->next;
  152. i++;
  153. }
  154. }
  155. if (strcmp(muscle->label,"Pec") ==0){
  156. if (i == 0)
  157. printf("Jour : %d --------------------------------- \n",j);
  158. while(i!=4){
  159. printf("titre : %s description : %s\n",j,exercice->name,exercice->description);
  160. exercice->next;
  161. i++;
  162. }
  163. }
  164. if (strcmp(muscle->label,"Dos") ==0){
  165. if (i == 0){
  166. printf("Jour : %d -----------test---------------------- \n",j);
  167.  
  168. }
  169. while(i<4){
  170.  
  171.  
  172. printf("\n __day = %d // j = %d // i = %d__ \n",day,j,i);
  173.  
  174. printf("titre : %s description : %s\n",exercice->name,exercice->description);
  175.  
  176. exercice=exercice->next;
  177. i++;
  178.  
  179. }
  180. }
  181. if (strcmp(muscle->label,"Bras") ==0){
  182. if (i == 0)
  183. printf("\nJour : %d --------------------------------- \n\n",j);
  184. while(i!=4){
  185. printf("titre : %s ------------------- \n description : %s \n\n ",exercice->name,exercice->description);
  186. exercice=exercice->next;
  187. i++;
  188. }
  189. }
  190. if (strcmp(muscle->label,"Epaule") ==0){
  191. if (i == 0)
  192. printf("Jour : %d --------------------------------- \n\n",j);
  193. while(i!=4){
  194. printf("titre : %s description : %s",j,exercice->name,exercice->description);
  195. exercice->next;
  196. i++;
  197. }
  198. }
  199. printf("\n -______________IN THE WHILE________________-");
  200.  
  201. j++;
  202. }
  203.  
  204. }
  205.  
  206. void type2(int day, Exercice * exercice,Muscle * muscle,Muscle * muscle2,int nb_muscle){
  207. int j = 1;
  208. while (j != day+1)
  209. {
  210. printf("Jour : %d --------------------------------- \n", j);
  211. type1(1,exercice,muscle,2);
  212. type1(1,exercice,muscle2,2);
  213. j++;
  214. }
  215.  
  216. }
  217.  
  218. void type3(int day, Exercice * exercice,Muscle * muscle,Muscle * muscle2,Muscle * muscle3,int nb_muscle) {
  219. int j = 1;
  220. if (day <= 2 || day == 4)
  221. while (j != day+1)
  222. {
  223. printf("Jour : %d --------------------------------- \n", j);
  224. type1(1,exercice,muscle,3);
  225. type1(1,exercice,muscle2,3);
  226. type1(1,exercice,muscle3,3);
  227. printf("Cardio");
  228. j++;
  229. }
  230. if (day == 3) {
  231. printf("Jour : 1 --------------------------------- \n");
  232. type1(1,exercice,muscle,1);
  233. printf("Jour : 2 --------------------------------- \n");
  234. type1(1,exercice,muscle2,1);
  235. printf("Jour : 3 --------------------------------- \n");
  236. type1(1,exercice,muscle3,1);
  237. }
  238. if (day == 5) {
  239. printf("Jour : 1 --------------------------------- \n");
  240. type1(1,exercice,muscle,1);
  241. printf("Jour : 2 --------------------------------- \n");
  242. type1(1,exercice,muscle2,1);
  243. printf("Jour : 3 --------------------------------- \n");
  244. type1(1,exercice,muscle3,1);
  245. printf("Jour : 4 --------------------------------- \n");
  246. type1(1,exercice,muscle,3);
  247. type1(1,exercice,muscle2,3);
  248. type1(1,exercice,muscle3,3);
  249. printf("Cardio");
  250. printf("Jour : 5 --------------------------------- \n");
  251. type1(1,exercice,muscle,3);
  252. type1(1,exercice,muscle2,3);
  253. type1(1,exercice,muscle3,3);
  254. printf("Cardio");
  255. }
  256. }
  257.  
  258. void type4(int day, Exercice * exercice,Muscle * muscle,Muscle * muscle2,Muscle * muscle3,Muscle * muscle4,int nb_muscle) {
  259. int j = 1;
  260. if (day <= 2)
  261. while (j != day+1)
  262. {
  263. printf("Jour : %d --------------------------------- \n", j);
  264. type1(1,exercice,muscle,4);
  265. type1(1,exercice,muscle2,4);
  266. type1(1,exercice,muscle3,4);
  267. type1(1,exercice,muscle4,4);
  268. j++;
  269. }
  270. if (day == 3)
  271. {
  272. printf("Jour : 1 --------------------------------- \n");
  273. type2(1,exercice,muscle,muscle2,2);
  274. printf("Jour : 2 --------------------------------- \n");
  275. type2(1,exercice,muscle3,muscle4,2);
  276. printf("Jour : 3 --------------------------------- \n");
  277. type1(1,exercice,muscle,4);
  278. type1(1,exercice,muscle2,4);
  279. type1(1,exercice,muscle3,4);
  280. type1(1,exercice,muscle4,4);
  281. }
  282. if (day == 4)
  283. {
  284. printf("Jour : 1 --------------------------------- \n");
  285. type1(1,exercice,muscle,1);
  286. printf("Jour : 1 --------------------------------- \n");
  287. type1(1,exercice,muscle2,1);
  288. printf("Jour : 1 --------------------------------- \n");
  289. type1(1,exercice,muscle3,1);
  290. printf("Jour : 1 --------------------------------- \n");
  291. type1(1,exercice,muscle4,1);
  292. }
  293. if (day == 5)
  294. {
  295. printf("Jour : 1 --------------------------------- \n");
  296. type2(1,exercice,muscle,muscle2,2);
  297. printf("Jour : 2 --------------------------------- \n");
  298. type2(1,exercice,muscle,muscle2,2);
  299. printf("Jour : 3 --------------------------------- \n");
  300. type2(1,exercice,muscle3,muscle4,2);
  301. printf("Jour : 4 --------------------------------- \n");
  302. type2(1,exercice,muscle3,muscle4,2);
  303. printf("Jour : 5 --------------------------------- \n");
  304. type1(1,exercice,muscle,4);
  305. type1(1,exercice,muscle2,4);
  306. type1(1,exercice,muscle3,4);
  307. type1(1,exercice,muscle4,4);
  308. }
  309. }
  310.  
  311. void type5(int day, Exercice * exercice,Muscle * muscle,Muscle * muscle2,Muscle * muscle3,Muscle * muscle4,Muscle * muscle5,int nb_muscle) {
  312. int j = 1;
  313.  
  314. if (day <= 3)
  315. {
  316. while (j != day+1)
  317. {
  318. printf("Jour : %d --------------------------------- \n", j);
  319. type1(1,exercice,muscle,5);
  320. type1(1,exercice,muscle2,5);
  321. type1(1,exercice,muscle3,5);
  322. type1(1,exercice,muscle4,5);
  323. type1(1,exercice,muscle5,5);
  324. j++;
  325. }
  326. }
  327. if (day == 4)
  328. {
  329. printf("Jour : 1 --------------------------------- \n");
  330. type2(1,exercice,muscle,muscle2,2);
  331. printf("Jour : 2 --------------------------------- \n");
  332. type2(1,exercice,muscle3,muscle4,2);
  333. printf("Jour : 3 --------------------------------- \n");
  334. type2(1,exercice,muscle4,muscle,2);
  335. printf("Jour : 4 --------------------------------- \n");
  336. type2(1,exercice,muscle2,muscle5,2);
  337. }
  338. if (day == 5)
  339. {
  340. printf("Jour : 1 --------------------------------- \n");
  341. type1(1,exercice,muscle,1);
  342. printf("Jour : 2 --------------------------------- \n");
  343. type1(1,exercice,muscle2,1);
  344. printf("Jour : 3 --------------------------------- \n");
  345. type1(1,exercice,muscle3,1);
  346. printf("Jour : 4 --------------------------------- \n");
  347. type1(1,exercice,muscle4,1);
  348. printf("Jour : 5 --------------------------------- \n");
  349. type1(1,exercice,muscle5,1);
  350. }
  351. }
  352.  
  353. int addExercice(Exercice ** start, Muscle * start2,char * name, char * description, char * muscle){
  354. Exercice * inter=NULL;
  355. inter=malloc(sizeof(Exercice) * MAX_PATH+1);
  356. if(inter==NULL) return 0;
  357. inter->description=description;
  358. inter->name=name;
  359.  
  360. inter->muscleTest=searchMuscle(start2,muscle);
  361.  
  362. inter->next=*start;
  363. *start=inter;
  364. return 1 ;
  365. }
  366.  
  367. Exercice * deleteExercice(Exercice* start){
  368. if (start == NULL) return NULL;
  369. Exercice * tmp;
  370. tmp=start->next;
  371. free(start);
  372. return tmp;
  373. }
  374.  
  375.  
  376. Muscle * deleteMuscle(Muscle* start){
  377. if (start == NULL) return NULL;
  378. Muscle * tmp;
  379. tmp=start;
  380. free(start);
  381. return tmp;
  382. }
  383.  
  384. int showMuscle(Muscle* start, int n) {
  385. // Muscle* tmp = start;
  386. if (start == NULL) return 0;
  387.  
  388. if(n==0) {
  389. while(start->next!=NULL) {
  390. if(start->selected==1){
  391. printf("%s \n", start->label);
  392. }
  393. start = start->next;
  394.  
  395. }
  396. }else{
  397. while(n>0){
  398. if(start->selected==1){
  399. printf("%s \n", start->label);
  400. }
  401. start = start->next;
  402. n--;
  403. }
  404. }
  405. return 1;
  406. }
  407.  
  408. int showExo(Exercice* start, int n) {
  409. // Muscle* tmp = start;
  410. if (start == NULL) return 0;
  411. if(n==-1) {
  412. do{
  413. if(start->muscleTest->selected==1){
  414. printf("%s : ", start->name);
  415. printf("%s \n", start->muscleTest->label);
  416. }
  417. start = start->next;
  418. }while(start!=NULL) ;
  419. }else{
  420. while(n>0){
  421. // if(start->selected==1){
  422. printf("%s : ", start->name);
  423. printf("%s \n", start->muscleTest->label);
  424. // }
  425. start = start->next;
  426. n--;
  427. }
  428. }
  429. return 1;
  430. }
  431.  
  432. Muscle * searchMuscle(Muscle * start,const char * search){
  433. while(start!=NULL){
  434. if( start->label==search){
  435. return start;
  436. }
  437. start=start->next;
  438. }
  439. return NULL;
  440. }
  441.  
  442. void bddConnect(MYSQL **conn){
  443.  
  444. //Connexion A la bdd de facon plus sofistiquer
  445. static char *host = "localhost";
  446. static char *user = "root";
  447. static char *password = "";
  448. static char *dbname = "training_life";
  449.  
  450. unsigned int port = 3306;
  451. static char *unix_socket = NULL;
  452. unsigned int flag = 0;
  453.  
  454.  
  455. *conn = mysql_init(NULL);
  456. if(!(mysql_real_connect(*conn, host, user, password, dbname, port, unix_socket, flag))){
  457. fprintf(stderr, "\n Error : %s [%d]\n", mysql_error(conn), mysql_errno(conn));
  458. exit(1);
  459. }
  460. printf("test");
  461.  
  462. printf("Connexion Successful ! ");
  463.  
  464.  
  465. }
  466.  
  467. int main(int argc, char ** argv){
  468.  
  469. bddConnect(&conn);
  470.  
  471.  
  472. functionAddToStruct(conn);
  473.  
  474.  
  475. /*
  476. printf("test123 : %d", start2->muscleTest);
  477. printf("test123 : %s", start2->name);
  478. printf("test123 : %s", start2->description);
  479.  
  480. addExercice(&start2,"developper couche", "allonge avec une barre",&start->bras );
  481. addExercice(&start2,"pompe", "au sol","bras" );
  482. showMuscle (start2, 0);
  483.  
  484.  
  485. void (* pointeurSurFonction)(int, int, char *, void);
  486. pointeurSurFonction=function2;
  487. (*pointeurSurFonction)(1,2,"test",function);
  488.  
  489. */
  490.  
  491. /*
  492. */
  493. mysql_close(conn);
  494.  
  495.  
  496. mysql_free_result(conn);
  497.  
  498.  
  499.  
  500.  
  501.  
  502. return 0;
  503. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!