1 /*

2 * data for the database connection

3 */

4

5 char* server = "localhost";

6 char* user = "garten";

7 char* password = "gras";

8 char* database = "garten";

9

10 MYSQL* conn;

11 MYSQL_RES* result;

12 MYSQL_ROW row;

13

14

15 void db_connect() {

16 conn = mysql_init(NULL);

17

18 /* Connect to database */

19 if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) {

20 fprintf(stderr, "%s\n", mysql_error(conn));

21 exit(1);

22 }

23 }

24

25

26 void db_close() {

27 /* close connection */

28 mysql_close(conn);

29 }

30

31

32 void db_query(char* query) {

33 int error;

34 /* send SQL query */

35 error = mysql_query(conn, query);

36 printf("query: %s\nerror: %d / %d\n", query, error, mysql_errno(conn));

37 if (error != 0) {

38 fprintf(stderr, "E: %s\n", mysql_error(conn));

39 }

40 }