Mysqldemo.c
Allikas: Lambda
/* 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; }