cdbc

Icon based on "Database free icon" by smashicons from www.flaticon.com and "ready" by Arbcom from https://commons.wikimedia.org

Example code

 #include "cdbc.h"

 int main(int argc, char **argv) {
     CDBC cdbc;
     CDBC_QUERY q;
     CDBC_RESULT res;
     char *row_value;
     int id = 1;

     // initialize CDBC and connect
     cdbc = cdbc_init();
     cdbc_connect(cdbc, "MySQL", "DATABASE=mydb", "127.0.0.1", 3306, "username", "password");

     // prepare SQL query
     q = cdbc_prepare(cdbc, "SELECT * FROM table WHERE id = ?");

     // bind input parameters
     cdbc_bind_param(q, 1, CDBC_C_LONG, id, sizeof(id));

     // execute SQL query
     cdbc_execute(q);

     // get pointer to row in resultset
     row_value = cdbc_c_name(q, "row_name");

     // fetch data
     res = cdbc_fetch(q);
     while (res) {
         printf("%s\n", row_value);
         res = cdbc_fetch(q);
     }

     // clean up
     cdbc_finish(q);
     cdbc_disconnect(cdbc);
     cdbc_cleanup(cdbc);

     return 0;
 }

Have a look at https://github.com/fnordahl/cdbc/blob/master/tests/test.c for more a more complete example with error handling etc.

The functional tests (https://github.com/fnordahl/cdbc/blob/master/.travis.yml) for this repository contain some hints about consuming the library from your snap: https://github.com/fnordahl/cdbc/blob/master/tests/snap/snapcraft.yaml