String processing/manipulation is a bit different in C but not to bad once you get used to it and how C works. Database connectivity in C is much like that in PHP. Here is a C snippit:
MYSQL mysql;
int dbconnect (void) {
if (!(mysql_connect(&mysql,"localhost","mysql","password"))) {
log("unable to connect to mysql database...aborting");
return(-1);
}
if (mysql_select_db(&mysql,"database")) {
log("unable to find database 'scanalyze'...aborting");
return(-1);
}
return(0);
}
so its not that much different, and the query process is almost the same too. Check out the docs on libmysqlclient.
-Chris