#include <mysql.h>
#include <my_global.h>
#include <string.h>
int main(int argc, char **argv)
{
  MYSQL *conn;
  MYSQL_RES *result;
  MYSQL_ROW row;
  MYSQL_FIELD *field;
  int num_fields;
  int i;
  /* Change me */
   char *server = "localhost";
   char *user = "root";
   char *password = "sadi";
   char *database = "testdb";
   char Title[100];
   char Author[60];
   char query[150];
   int Id;
   conn = mysql_init(NULL);

   /* Connect to database */
   if (!mysql_real_connect(conn, server,
         user, password,database,0, NULL, 0)) {
      fprintf(stderr, "%s\n", mysql_error(conn));
      exit(1);
   }

   scanf("%d",&Id);
   printf("title: ");
   scanf("%s",Title);
   printf("Author: ");
   scanf("%s",Author);
   int quantity;
   scanf("%d",&quantity);
   sprintf(query,"INSERT INTO Books values(%d,'%s','%s',%d)",Id,Title,Author,quantity);
   printf("%s",query);






mysql_query(conn, query);



  result= mysql_use_result(conn);

    /*output table name*/
   mysql_query(conn, "SELECT * FROM Books");
  result = mysql_store_result(conn);

  num_fields = mysql_num_fields(result);
  while ((row = mysql_fetch_row(result)))
  {
      for(i = 0; i < num_fields; i++)
      {
          if (i == 0) {
             while(field = mysql_fetch_field(result)) {
                printf("%s\t", field->name);
             }
          printf("\n");
          }
          printf("%s\t", row[i] ? row[i] : "NULL");
      }
  }
  printf("\n");

   /* close connection */
   mysql_free_result(result);
   mysql_close(conn);

  return 0;
}