I'm trying to get some user data into an INSERT query using the Mysql C API (don't know if this belongs rather in the Mysql forum, let me know...)
I have the following code taking some pointers from the Mysql webpage forum, but to no avail:
#include <mysql.h>
#include <stdio.h>
#include <stdlib.h>
int main()
{
char *server = "localhost";
char *user = "root";
char *password = /* password to acces mysql */;
char *database = "palabra";
char Name[] = "test";
char *cmd;
cmd=malloc(1024);
sprintf(cmd, "INSERT INTO prueba VALUES(%s)", Name);
MYSQL *conn;
conn=mysql_init(NULL);
mysql_real_connect(conn, server, user, password, database, 0, NULL, 0);
mysql_query(conn, "INSERT INTO prueba VALUES(Name)");
mysql_close(conn);
return 0;
}The code compiles without error, but the table is unchanged with nothing inserted to it.
More over, I don't really know the sprintf part too well, or why it's used (like I said I took pointers from other forums just to try stuff), since it's not used later when the mysql_query() is called.
T
