linux学习9mysql图片存储

最新推荐文章于 2024-02-02 17:23:52 发布

VIP文章 dandan_xt

最新推荐文章于 2024-02-02 17:23:52 发布

阅读量167

点赞数

文章标签： linux c语言 mysql

本文链接：https://blog.csdn.net/weixin_42607200/article/details/123877264

版权

read_image

int read_image(char *filename, char *buffer) {
   

	if (filename == NULL || buffer == NULL) return -1;
	FILE *fp = fopen(filename, "rb");
	if (fp == NULL) {
   
		printf("fopen failed\n");
		return -2;
	}

	//file size
	fseek(fp, 0, SEEK_END);//fp移到最末尾
	int length = ftell(fp);//file size
	fseek(fp, 0, SEEK_SET);//fp指向最开始

	int size = fread(buffer, 1, length, fp);//读出来的数据存储到buffer
	if (size != length) {
   
		printf("fread failed: %d\n",size);
		return-3;
	}

	fclose(fp);
    
	return size;





}

写入磁盘

//filename
//buffer
//length
int write_image(char *filename,char *buffer,int length) {
   

	if (filename == NULL || buffer == NULL || length <= 0) return -1;

	FILE *fp = fopen(filename, "wb+");//打开文件方式是写的方式,+号表示如果没有创建
	if (fp == NULL) {
   
		printf("fopen failed\n");
		return -2;
	}

	int size = fwrite(buffer, 1, length, fp);
	if (size != length) {
   
		printf("fwrite failed: %d\n",size);
		return -3;
	}

	fclose(fp);
}

在这里插入图片描述

mysql_write

SHOW DATABASES;
USE KING_DB;
SHOW TABLES;
SELECT * FROM TBL_USER;

ALTER TABLE TBL_USER ADD U_IMG BLOB;

在这里插入图片描述

int mysql_write(MYSQL *handle, char *buffer, int length) {
   

	if (handle == NULL || buffer == NULL || length <= 0) return -1;

	MYSQL_STMT *stmt = mysql_stmt_init(handle);
	int ret = mysql_stmt_prepare(stmt, SQL_INSERT_IMG_USER, strlen(SQL_INSERT_IMG_USER));//返回0成功
	if (ret) {
   
		printf("mysql_stmt_prepare : %s\n", mysql_error(handle));
		return -2;
	}

	MYSQL_BIND param = {
    0 };
	param.buffer_type = MYSQL_TYPE_LONG_BLOB;
	param.buffer = NULL;
	param.is_null = 0;
	param.length = NULL;

	ret = mysql_stmt_bind_param(stmt, &param);
	if (ret) {
   
		printf("mysql_stmt_bind_param : %s\n", mysql_error(handle));
		return -3;
	}

	ret = mysql_stmt_send_long_data(stmt, 0, buffer, length);
	if (ret) {