[sqlite] put jpg into sqlite database

[YAN HONG YE]

this following code is my import girl.jpg to my sqlite database, but I don't 
know why JPG didn't up to the bin.db.

#include <string.h>
#include<stdio.h>
#include<stdlib.h>
#include"sqlite3.h"

#pragma comment(lib, "sqlite3.lib")

sqlite3 * db; 

sqlite3_stmt *stat; 
int main(int argc, char **argv)
{
char *zErrMsg=0; 
FILE *fp=NULL; 
long filesize=0; 
char* ffile=NULL; 
char* buf=NULL;
sqlite3_open("Bin.db",&db);
if(db==NULL)
{ return 0;} 
fp=fopen("girl.jpg","rb");
if(fp!=NULL) 
{fseek(fp,0,SEEK_END);
filesize=ftell(fp);
fseek(fp,0,SEEK_SET);
ffile=(char*)malloc(filesize);
        
size_t sz=fread(ffile,sizeof(char),filesize,fp);
printf("%s",ffile);
printf("%d",filesize);
fclose(fp);
} 

sqlite3_exec(db,"create table image (filename varchar(128) unique,img 
blob);",0,0,&zErrMsg); 

sqlite3_prepare(db,"insert into image values  ('girl.jpg',?)",-1,&stat,0); 

sqlite3_bind_blob(stat,1,ffile,filesize,NULL); 

sqlite3_step(stat); 
free(ffile); 

sqlite3_finalize(stat); 

sqlite3_close(db); 


  
    return 0;
}
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users