289 char* stmtdata=
"INSERT INTO rundata (runid,name,description,data) values (?,?,?,?)";
296 mysql_stmt_prepare(stmt,stmtdata,strlen(stmtdata));
298 memset(bind,0,
sizeof(bind));
299 bind[0].buffer_type = MYSQL_TYPE_LONG;
300 #if MYSQL_VERSION_ID >= 50100 301 bind[0].buffer = (
char*) &runid;
303 bind[0].buffer = (gptr) &runid;
306 bind[1].buffer_type = MYSQL_TYPE_STRING;
307 bind[1].buffer = name;
308 bind[1].buffer_length = strlen(name);
310 bind[2].buffer_type = MYSQL_TYPE_STRING;
311 bind[2].buffer = desc;
312 bind[2].buffer_length = strlen(desc);
314 solstring =
calloc(len*(50+1)+1,
sizeof(
char));
315 tmpstring =
calloc(256,
sizeof(
char));
317 sprintf(tmpstring,
"%+f %+f %+f %+f %+f\n",points[i].x,points[i].y,points[i].z,
CREAL(data[i]),
CIMAG(data[i]));
318 strcat(solstring,tmpstring);
323 bind[3].buffer_type = MYSQL_TYPE_STRING;
324 bind[3].buffer = solstring;
325 bind[3].buffer_length = strlen(solstring);
326 mysql_stmt_bind_param(stmt,bind);
328 mysql_stmt_execute(stmt);
330 mysql_stmt_close(stmt);
MYSQL * connection
Definition: mysqlsave.c:36
#define CREAL(x)
Definition: functions.h:49
#define CIMAG(x)
Definition: functions.h:50
#define calloc(n, size)
Definition: allocation.h:37