Mercurial > garten

annotate db.h @ 5:26ca6c79fc22

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added a Makefile (which needs improvement)
author meillo@marmaro.de
date Wed, 14 May 2008 21:10:45 +0200
parents 32c4212f05d9
children 176ee28e7464
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
1 /*
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
2 * data for the database connection
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
3 */
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
4
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
5 char* server = "localhost";
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
6 char* user = "garten";
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
7 char* password = "gras";
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
8 char* database = "garten";
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
9
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
10 MYSQL* conn;
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
11 MYSQL_RES* result;
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
12 MYSQL_ROW row;
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
13
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
14
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
15 void db_connect() {
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
16 conn = mysql_init(NULL);
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
17
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
18 /* Connect to database */
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
19 if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) {
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
20 fprintf(stderr, "%s\n", mysql_error(conn));
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
21 exit(1);
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
22 }
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
23 }
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
24
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
25
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
26 void db_close() {
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
27 /* close connection */
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
28 mysql_close(conn);
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
29 }
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
30
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
31
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
32 void db_query(char* query) {
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
33 int error;
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
34 /* send SQL query */
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
35 error = mysql_query(conn, query);
4
32c4212f05d9 less verbosity on queries; activation of weather
meillo@marmaro.de
parents: 0
diff changeset
36 /*printf("query: %s\nerror: %d / %d\n", query, error, mysql_errno(conn));*/
0
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
37 if (error != 0) {
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
38 fprintf(stderr, "E: %s\n", mysql_error(conn));
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
39 }
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
40 }