mysql_row结构体_C语言查询MySQL数据库如何将得到的数据放入结构体数组中？

intmysql_select(intconnfd,MSG*pbuf,MYSQL*conn_ptr){intres,i,j,m;charsqlstr[128];charbuf[128];//char*cData;MYSQL_RES*res_ptr;MYSQL_ROWsqlrow;sprintf(sqlstr,"select*fromDoo...

int mysql_select(int connfd,MSG *pbuf,MYSQL *conn_ptr)

{

int res, i, j, m;

char sqlstr[128];

char buf[128];

//char *cData;

MYSQL_RES *res_ptr;

MYSQL_ROW sqlrow;

sprintf(sqlstr, "select * from Door_Kind where Kind_Door_Name = '%s'", pbuf->name);

res = mysql_query(conn_ptr, sqlstr);

if (!res) {

res_ptr = mysql_store_result(conn_ptr);

if(res_ptr) {

printf("%lu Rows\n",(unsigned long)mysql_num_rows(res_ptr));

j = mysql_num_fields(res_ptr);

while((sqlrow = mysql_fetch_row(res_ptr))) { //依次取出记录

//strncpy(pbuf->data, (char *)sqlrow, j);

for(i = 0; i < j; i++) {

pbuf->data[i] =( (char *)&sqlrow[i] );

printf("sqlrow[%d] = %s\n", i,sqlrow[i]);

}

}

send(connfd, pbuf->data, strlen(pbuf->data), 0);

展开