存储:
const char *data_source_1 = (char*)newmat.data;
char *data_1;
data_1 = (char*)malloc((2*width*height*3+1)*sizeof(char)); mysql_real_escape_string(&my_connection, data_1,data_source_1, width*height*3);
const char* str_4 = str_1.c_str();
size_t st_len_1 = strlen(str_4); char *query_1;
query_1 = (char*)malloc((st_len_1+2*width*height*3+1)*sizeof(char)); //char query[st_len + 2*size+1];
int len_1 = _snprintf(query_1, st_len_1+2*width*height*3+1, str_4, data_1)
hr = mysql_real_query(&my_connection, query_1, len_1);取数据:
unsigned int width;
sscanf(sql_row[2], "%u", &width); unsigned int height;
sscanf(sql_row[3], "%u", &height);
IplImage *iplimage = cvCreateImage(cvSize(width, height), 8, 3);
memcpy(iplimage->imageData,sql_row[1],width*height*3); cv::Mat MatImg(iplimage); cv::imshow( "result", MatImg );
waitKey(0);
const char *data_source_1 = (char*)newmat.data;
char *data_1;
data_1 = (char*)malloc((2*width*height*3+1)*sizeof(char)); mysql_real_escape_string(&my_connection, data_1,data_source_1, width*height*3);
const char* str_4 = str_1.c_str();
size_t st_len_1 = strlen(str_4); char *query_1;
query_1 = (char*)malloc((st_len_1+2*width*height*3+1)*sizeof(char)); //char query[st_len + 2*size+1];
int len_1 = _snprintf(query_1, st_len_1+2*width*height*3+1, str_4, data_1)
hr = mysql_real_query(&my_connection, query_1, len_1);取数据:
unsigned int width;
sscanf(sql_row[2], "%u", &width); unsigned int height;
sscanf(sql_row[3], "%u", &height);
IplImage *iplimage = cvCreateImage(cvSize(width, height), 8, 3);
memcpy(iplimage->imageData,sql_row[1],width*height*3); cv::Mat MatImg(iplimage); cv::imshow( "result", MatImg );
waitKey(0);
图片另存
MYSQL里面存储图片的索引目录