Im using a library to do this. This one: libmySQL.lib
This is my code:
It should work since it came from a tutorial.Code:#include <mysql.h> #include <stdio.h> main() { MYSQL *conn; MYSQL_RES *res; MYSQL_ROW row; char *server = "localhost"; char *user = "root"; char *password = ""; char *database = "KKI"; conn = mysql_init(NULL); /* Connect to database */ if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) { fprintf(stderr, "%s\n", mysql_error(conn)); exit(0); } /* send SQL query */ if (mysql_query(conn, "SELECT * FROM KKI_users WHERE ID=1")) { fprintf(stderr, "%s\n", mysql_error(conn)); exit(0); } res = mysql_use_result(conn); /* output fields 1 and 2 of each row */ while ((row = mysql_fetch_row(res)) != NULL) printf("%s %s\n", row[1], row[2]); /* Release memory used to store results and close connection */ mysql_free_result(res); mysql_close(conn); }
This is my compiler-log:
I'm using Dev-C++ 4.9.9.2. I have uploaded both mysql.h and mysql_com.hCode:Compiler: Default compiler Building Makefile: "C:\test3\Makefile.win" Bezig met uitvoeren van make... make.exe -f "C:\test3\Makefile.win" all gcc.exe -c main.c -o main.o -I"C:/Dev-Cpp/include" In file included from C:/Dev-Cpp/include/mysql.h:68, from main.c:1: C:/Dev-Cpp/include/mysql_com.h:115: error: syntax error before "SOCKET" C:/Dev-Cpp/include/mysql_com.h:115: warning: no semicolon at end of struct or union C:/Dev-Cpp/include/mysql_com.h:130: error: syntax error before '}' token C:/Dev-Cpp/include/mysql_com.h:130: warning: data definition has no type or storage class C:/Dev-Cpp/include/mysql_com.h:160: error: syntax error before '*' token C:/Dev-Cpp/include/mysql_com.h:161: error: syntax error before '*' token C:/Dev-Cpp/include/mysql_com.h:162: error: syntax error before '*' token C:/Dev-Cpp/include/mysql_com.h:163: error: syntax error before '*' token C:/Dev-Cpp/include/mysql_com.h:164: error: syntax error before '*' token C:/Dev-Cpp/include/mysql_com.h:165: error: syntax error before '*' token C:/Dev-Cpp/include/mysql_com.h:167: error: syntax error before '*' token C:/Dev-Cpp/include/mysql_com.h:168: error: syntax error before '*' token In file included from main.c:1: C:/Dev-Cpp/include/mysql.h:141: error: syntax error before "NET" C:/Dev-Cpp/include/mysql.h:141: warning: no semicolon at end of struct or union C:/Dev-Cpp/include/mysql.h:163: error: syntax error before '}' token C:/Dev-Cpp/include/mysql.h:163: warning: data definition has no type or storage class C:/Dev-Cpp/include/mysql.h:176: error: syntax error before "MYSQL" C:/Dev-Cpp/include/mysql.h:176: warning: no semicolon at end of struct or union C:/Dev-Cpp/include/mysql.h:178: error: syntax error before '}' token C:/Dev-Cpp/include/mysql.h:178: warning: data definition has no type or storage class C:/Dev-Cpp/include/mysql.h:183: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:184: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:185: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:186: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:188: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:189: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:190: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:192: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:193: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:194: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:195: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:196: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:197: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:198: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:199: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:201: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:201: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:201: warning: data definition has no type or storage class C:/Dev-Cpp/include/mysql.h:209: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:209: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:210: warning: data definition has no type or storage class C:/Dev-Cpp/include/mysql.h:211: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:214: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:214: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:220: warning: data definition has no type or storage class C:/Dev-Cpp/include/mysql.h:229: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:230: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:231: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:232: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:233: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:234: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:236: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:238: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:239: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:240: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:241: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:242: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:244: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:245: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:246: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:247: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:249: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:250: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:251: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:251: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:251: warning: data definition has no type or storage class C:/Dev-Cpp/include/mysql.h:252: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:252: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:252: warning: data definition has no type or storage class C:/Dev-Cpp/include/mysql.h:253: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:253: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:254: warning: data definition has no type or storage class C:/Dev-Cpp/include/mysql.h:255: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:255: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:255: warning: data definition has no type or storage class C:/Dev-Cpp/include/mysql.h:256: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:256: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:256: warning: data definition has no type or storage class C:/Dev-Cpp/include/mysql.h:257: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:257: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:257: warning: data definition has no type or storage class C:/Dev-Cpp/include/mysql.h:258: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:260: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:261: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:263: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:264: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:266: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:267: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:268: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:271: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:275: error: syntax error before '*' token C:/Dev-Cpp/include/mysql.h:284: error: syntax error before ')' token C:/Dev-Cpp/include/mysql.h:285: error: syntax error before '*' token main.c: In function `main': main.c:5: error: `conn' undeclared (first use in this function) main.c:5: error: (Each undeclared identifier is reported only once main.c:5: error: for each function it appears in.) main.c:6: error: `res' undeclared (first use in this function) make.exe: *** [main.o] Error 1 Uitvoering voltooid
I'm a newbie in the C++ language and im just using it to make a dll so i can get an easier access to a mysql server in VB6.
