/*
 * data for the database connection
 */

char* server = "localhost";
char* user = "garten";
char* password = "gras";
char* database = "garten";

MYSQL* conn;
MYSQL_RES* result;
MYSQL_ROW row;


void db_connect() {
	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(1);
	}
}


void db_close() {
	/* close connection */
	mysql_close(conn);
}


void db_query(char* query) {
	int error;
	/* send SQL query */
	error = mysql_query(conn, query);
	printf("query: %s\nerror: %d / %d\n", query, error, mysql_errno(conn));
	if (error != 0) {
		fprintf(stderr, "E: %s\n", mysql_error(conn));
	}
}