Mysqldemo.c

/* compile with 
sh -c "gcc -o mysqldemo `/usr/local/mysql/bin/mysql_config --cflags` mysqldemo.c `/usr/local/mysql/bin/mysql_config --libs`"
*/
#include <mysql.h> /* Headers for MySQL usage */
#include <stdio.h>
#include <stdlib.h>
#include <string.h>

static MYSQL demo_db;

int main(int argc, char **argv){
  int insert_id;
  char *encdata, *query;
  int datasize;
  MYSQL_RES *res; /* To be used to fetch information into */
  MYSQL_ROW row;

  if(argc<2){
    printf("Please supply a string for insertion into the database\n");
    exit(0);
  }

  if(!mysql_real_connect(&demo_db, "127.0.0.1", "bob", "", "", 0, NULL, 0)){ 
   /* Make connection with 
      mysql_connect(MYSQL db, char *host, char *username, char *password, database, 0, NULL,0 */
    printf(mysql_error(&demo_db));
    exit(1);
  }

  if(mysql_select_db(&demo_db, "demodb")){ /* Select the database we want to use */
    printf(mysql_error(&demo_db));
    exit(1);
  }

  encdata=malloc(strlen(argv[1])+1); /* Create a buffer to write our slash-encoded data int; it must
 be at least twice the size of the input string plus one byte for the null terminator */
  datasize=mysql_real_escape_string(&demo_db, encdata, argv[1], strlen(argv[1])); /* Escape any MySQ
L-unsafe characters */
  query=malloc(datasize+255); /*Make sure we have enough space for the query */
  sprintf(query, "INSERT INTO demotable(demodata) VALUES('%s')", encdata); /* Build query */
  if(mysql_real_query(&demo_db, query, strlen(query)+255)){ /* Make query */
     printf(mysql_error(&demo_db));
     exit(1);
  }
  free(query);  insert_id=mysql_insert_id(&demo_db); /* Find what id that data was given */

  query=malloc(255);
  sprintf(query, "SELECT demodata FROM demotable WHERE id='%d'", insert_id);
  if(mysql_real_query(&demo_db, query, 255)){ /* Make query */
     printf(mysql_error(&demo_db));
     exit(1);
  }

  res=mysql_store_result(&demo_db); /* Download result from server */
  row=mysql_fetch_row(res); /* Get a row from the results */
  printf("You inserted \"%s\".\n", row[0]);
  mysql_free_result(res); /* Release memory used to store results. */
  mysql_close(&demo_db);

  return 0;
}