cdbc

 #include "cdbc.h"

 int main(int argc, char **argv) {

     CDBC cdbc;

     CDBCQUERY q;

     CDBCRESULT res;

     char *rowvalue;

     int id = 1;

     // initialize CDBC and connect

     cdbc = cdbcinit();

     cdbcconnect(cdbc, "MySQL", "DATABASE=mydb", "127.0.0.1", 3306, "username", "password");

     // prepare SQL query

     q = cdbcprepare(cdbc, "SELECT * FROM table WHERE id = ?");

     // bind input parameters

     cdbcbindparam(q, 1, CDBCCLONG, id, sizeof(id));

     // execute SQL query

     cdbcexecute(q);

     // get pointer to row in resultset

     rowvalue = cdbccname(q, "rowname");

     // fetch data

     res = cdbcfetch(q);

     while (res) {

         printf("%s\n", rowvalue);

         res = cdbcfetch(q);

     }

     // clean up

     cdbcfinish(q);

     cdbcdisconnect(cdbc);

     cdbc_cleanup(cdbc);

     return 0;

 }