#include <mysql.h>
#include <stdio.h>

main() {
  MYSQL *conn;
  MYSQL_RES *res;
  MYSQL_ROW row;

  char *server = "localhost";
  char *user = "root";

  char *password = "password"; 
  char *database = "composant_live";

  conn = mysql_init(NULL);


  if (!mysql_real_connect(conn, server,
        user, password, database, 0, NULL, 0)) {
      fprintf(stderr, "%s\n", mysql_error(conn));

  }


  if (mysql_query(conn, "SELECT etat FROM composant WHERE id LIKE '1'")) {
      fprintf(stderr, "%s\n", mysql_error(conn));

  }

  res = mysql_use_result(conn);


  printf("Etat :\n");
  while ((row = mysql_fetch_row(res)) != NULL)
  printf("%s °C\n", row[0]);

char s_Mail[] = "echo row[0] | mail -s \"Rapport Journalier du système\" destinatire@domaine.com -- -f expediteur@domaine.com";
        system(s_Mail);

  mysql_free_result(res);
  mysql_close(conn);
}

#include <stdio.h>
#include <stdlib.h>
#include <time.h>
#include <mysql/mysql.h>
 
 
 
int main(int argc, char **argv)
{
 
            //Déclaration de l'objet de type MYSQL
            MYSQL mysql;
            //Initialisation de MySQL
            mysql_init(&mysql);
            //Options de connexion
            mysql_options(&mysql,MYSQL_READ_DEFAULT_GROUP,"option");
char * etat_activee = "etat_activee";


            //Si la connexion réussie...
            if(mysql_real_connect(&mysql,"localhost","root","password","composant_live",0,NULL,0))
            {
                //On déclare un tableau de char pour y stocker la requete
                char requete[150] = "";
 
                //On stock la requete dans notre tableau de char
                sprintf(requete, "INSERT INTO ballon VALUES('', '1')", etat_activee);
 
 
                //On execute la requete
                mysql_query(&mysql, requete);
 
 
                //Fermeture de MySQL
                mysql_close(&mysql);
            }
            else
            {
                printf("Une erreur s'est produite lors de la connexion a la BDD!");
            }
 
 
 
    return 0;
}