Hello All,
I've been working on a program which writes to MySQL. It needs some variables posting into the database and I'm having trouble elegantly constructing a char * string to send to the MySQL connector.
Here's what I'm doing at present, apologies for my awful code, it works but seems unnecessarily long-winded and ugly. Does anyone know of a more elegant way to insert variables into a char * string? If there were a need for lots of SQL queries this method could get ugly very quickly!
Code:
char *arg1a = "select * from database where field1 = '";
char *arg1b = "' and field2 = '";
char *arg1c = "'";
char *sqlarg;
sqlarg = (char *)malloc((strlen(variable1) + strlen(variable2) + strlen(arg1a) + strlen(arg1b) + strlen(arg1c) + 1)
*sizeof(char));
strcpy(arg1, arg1a);
strcat(arg1, variable1);
strcat(arg1, arg1b);
strcat(arg1, variable2);
strcat(arg1, arg1c);
/* completed query now stored in sqlarg */
Thanks for any pointers (heehee)