Debian Codegraph @

doc/programmers-guide/quickstart-code.html

raw
1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
2 <HTML
3 ><HEAD
4 ><TITLE
5 >Generic Example Program</TITLE
6 ><META
7 NAME="GENERATOR"
8 CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
9 REL="HOME"
10 TITLE="Database Independent Abstraction Layer for C"
11 HREF="index.html"><LINK
12 REL="UP"
13 TITLE="libdbi in a Nutshell (Quickstart Guide)"
14 HREF="quickstart.html"><LINK
15 REL="PREVIOUS"
16 TITLE="Quick Overview"
17 HREF="quickstart-debriefing.html"><LINK
18 REL="NEXT"
19 TITLE="Loading libdbi at runtime"
20 HREF="loadinglibdbi.html"></HEAD
21 ><BODY
22 CLASS="SECTION"
23 BGCOLOR="#FFFFFF"
24 TEXT="#000000"
25 LINK="#0000FF"
26 VLINK="#840084"
27 ALINK="#0000FF"
28 ><DIV
29 CLASS="NAVHEADER"
30 ><TABLE
31 SUMMARY="Header navigation table"
32 WIDTH="100%"
33 BORDER="0"
34 CELLPADDING="0"
35 CELLSPACING="0"
36 ><TR
37 ><TH
38 COLSPAN="3"
39 ALIGN="center"
40 >Database Independent Abstraction Layer for C: libdbi Programmer's Guide</TH
41 ></TR
42 ><TR
43 ><TD
44 WIDTH="10%"
45 ALIGN="left"
46 VALIGN="bottom"
47 ><A
48 HREF="quickstart-debriefing.html"
49 ACCESSKEY="P"
50 >Prev</A
51 ></TD
52 ><TD
53 WIDTH="80%"
54 ALIGN="center"
55 VALIGN="bottom"
56 >Chapter 3. libdbi in a Nutshell (Quickstart Guide)</TD
57 ><TD
58 WIDTH="10%"
59 ALIGN="right"
60 VALIGN="bottom"
61 ><A
62 HREF="loadinglibdbi.html"
63 ACCESSKEY="N"
64 >Next</A
65 ></TD
66 ></TR
67 ></TABLE
68 ><HR
69 ALIGN="LEFT"
70 WIDTH="100%"></DIV
71 ><DIV
72 CLASS="SECTION"
73 ><H1
74 CLASS="SECTION"
75 ><A
76 NAME="QUICKSTART-CODE"
77 >3.2. Generic Example Program</A
78 ></H1
79 ><P
80 >The following listing shows how to establish a connection to a MySQL database server and retrieve the results of a SQL query. Only a small number of functions offered by libdbi are shown here. For a more extensive example check out the test program <TT
81 CLASS="FILENAME"
82 >tests/test_dbi.c</TT
83 > in the <A
84 HREF="http://libdbi-drivers.sourceforge.net"
85 TARGET="_top"
86 >libdbi-drivers</A
87 > source tarball.</P
88 ><TABLE
89 BORDER="0"
90 BGCOLOR="#E0E0E0"
91 WIDTH="100%"
92 ><TR
93 ><TD
94 ><FONT
95 COLOR="#000000"
96 ><PRE
97 CLASS="PROGRAMLISTING"
98 >#include &#60;stdio.h&#62;
99 #include &#60;dbi/dbi.h&#62;
100
101 int main() {
102 dbi_conn conn;
103 dbi_result result;
104 dbi_inst instance;
105
106 double threshold = 4.333333;
107 unsigned int idnumber;
108 const char *fullname;
109
110 dbi_initialize_r(NULL, &#38;instance);
111 conn = dbi_conn_new_r("mysql", instance);
112
113 dbi_conn_set_option(conn, "host", "localhost");
114 dbi_conn_set_option(conn, "username", "your_name");
115 dbi_conn_set_option(conn, "password", "your_password");
116 dbi_conn_set_option(conn, "dbname", "your_dbname");
117 dbi_conn_set_option(conn, "encoding", "UTF-8");
118
119 if (dbi_conn_connect(conn) &#60; 0) {
120 printf("Could not connect. Please check the option settings\n");
121 }
122 else {
123 result = dbi_conn_queryf(conn, "SELECT id, name FROM coders "
124 "WHERE hours_of_sleep &#62; %0.2f", threshold);
125
126 if (result) {
127 while (dbi_result_next_row(result)) {
128 idnumber = dbi_result_get_uint(result, "id");
129 fullname = dbi_result_get_string(result, "name");
130 printf("%i. %s\n", idnumber, fullname);
131 }
132 dbi_result_free(result);
133 }
134 dbi_conn_close(conn);
135 }
136
137 dbi_shutdown_r(instance);
138
139 return 0;
140 }</PRE
141 ></FONT
142 ></TD
143 ></TR
144 ></TABLE
145 ><P
146 >Compile with: gcc -lm -ldl -ldbi -o foo foo.c</P
147 ><DIV
148 CLASS="NOTE"
149 ><BLOCKQUOTE
150 CLASS="NOTE"
151 ><P
152 ><B
153 >Note: </B
154 >The <CODE
155 CLASS="OPTION"
156 >-ldl</CODE
157 > option is not required on systems that implement the dynamic linking in their libc (like FreeBSD). You may also have to throw in something like <CODE
158 CLASS="OPTION"
159 >-I/usr/local/include</CODE
160 > and <CODE
161 CLASS="OPTION"
162 >-L/usr/local/lib</CODE
163 > to help gcc and ld find the libdbi headers and libraries.</P
164 ></BLOCKQUOTE
165 ></DIV
166 ><P
167 >Of course, a complete program should check for errors more thoroughly. This example keeps error-checking at a minimum for the sake of clarity. There are also other ways to retrieve data after a successful query. Keep reading on to see the rest.</P
168 ></DIV
169 ><DIV
170 CLASS="NAVFOOTER"
171 ><HR
172 ALIGN="LEFT"
173 WIDTH="100%"><TABLE
174 SUMMARY="Footer navigation table"
175 WIDTH="100%"
176 BORDER="0"
177 CELLPADDING="0"
178 CELLSPACING="0"
179 ><TR
180 ><TD
181 WIDTH="33%"
182 ALIGN="left"
183 VALIGN="top"
184 ><A
185 HREF="quickstart-debriefing.html"
186 ACCESSKEY="P"
187 >Prev</A
188 ></TD
189 ><TD
190 WIDTH="34%"
191 ALIGN="center"
192 VALIGN="top"
193 ><A
194 HREF="index.html"
195 ACCESSKEY="H"
196 >Home</A
197 ></TD
198 ><TD
199 WIDTH="33%"
200 ALIGN="right"
201 VALIGN="top"
202 ><A
203 HREF="loadinglibdbi.html"
204 ACCESSKEY="N"
205 >Next</A
206 ></TD
207 ></TR
208 ><TR
209 ><TD
210 WIDTH="33%"
211 ALIGN="left"
212 VALIGN="top"
213 >Quick Overview</TD
214 ><TD
215 WIDTH="34%"
216 ALIGN="center"
217 VALIGN="top"
218 ><A
219 HREF="quickstart.html"
220 ACCESSKEY="U"
221 >Up</A
222 ></TD
223 ><TD
224 WIDTH="33%"
225 ALIGN="right"
226 VALIGN="top"
227 >Loading libdbi at runtime</TD
228 ></TR
229 ></TABLE
230 ></DIV
231 ></BODY
232 ></HTML
233 >