ReceiveImageFromDB

ReceiveImageFromDB.cpp

void ReceiveImageFromDB() {
	MYSQL *conn;
	MYSQL_RES *result;
	MYSQL_ROW row;

	unsigned long *lengths;

	conn = mysql_init(NULL);
	mysql_real_connect(conn, "IP", "ID", "PASSWORD", "videosummary", PORT, NULL, 0);

	mysql_query(conn, "SELECT background FROM videosummary_table_list WHERE name='sample_03_0250'");
	result = mysql_store_result(conn);

	row = mysql_fetch_row(result);
	lengths = mysql_fetch_lengths(result);

	std::vector<char> v(row[0], row[0] + lengths[0]);

	mysql_free_result(result);
	mysql_close(conn);

	cv::Mat imageRecieved = cv::imdecode(cv::Mat(v), CV_LOAD_IMAGE_COLOR);
	cv::imshow("hi", imageRecieved);
	cv::waitKey();
}