Effectuer des requêtes sur un serveur mysql

#include "mysql.h" MYSQL *mysqlOpenDB(char *server, char *db, char *user, char *pwd){ MYSQL *myH; if(NULL == (myH = mysql_init(NULL))){ fprintf(stderr, "erreur lors de l'ouverture : %s\n", mysql_error(myH)); } if(mysql_real_connect(myH, server, user, pwd, db, 0, NULL, 0) == NULL){ fprintf(stderr, "erreur lors de la connexion : %s\n", mysql_error(myH)); } return myH; } void mysqlExecReq (MYSQL *myH, char *req){ if(mysql_query(myH, req) != 0){ fprintf(stderr, "Echec de la requete : %s\n", mysql_error(myH)); mysql_close(myH); } } void mysqlCloseDB(MYSQL *db){ mysql_close(db); }
Ligne de compilation
gcc -Wall -lmysqlclient plop.c -o prog