Effectuer des requêtes sur un serveur mysql

Portrait de trax
#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