php存sqlite图片,往sqlite中写入和读取图片二进制数据的代码

NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);

NSString *dataPath = [[paths objectAtIndex:0] stringByAppendingPathComponent:@”sqlite.sqlite”];

NSData *image=UIImagePNGRepresentation([UIImage imageNamed:@"01_02.png"]);

NSString *aaa=[[NSString alloc]initWithFormat:@”update cards set c_image=? where id=1″];

sqlite3 *database;

if (sqlite3_open([dataPath UTF8String], &database) == SQLITE_OK){

sqlite3_stmt * compliedStatement;

sqlite3_prepare(database,[aaa UTF8String],-1,&compliedStatement,0);

sqlite3_bind_blob(compliedStatement, 1, [image bytes], [image length], NULL);

int result=sqlite3_step(compliedStatement);

if (result==SQLITE_DONE) {

}

sqlite3_finalize(compliedStatement);

}

sqlite3_close(database);

[aaa release];

从sqlite中读取图片二进制数据的代码:

NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);

NSString *dataPath = [[paths objectAtIndex:0] stringByAppendingPathComponent:@”sqlite.sqlite”];

sqlite3 *database;

if (sqlite3_open([dataPath UTF8String], &database) == SQLITE_OK){

const char *sqlStatement=”select c_image from cards where id=1″;

sqlite3_stmt *compliedStatement;

if(sqlite3_prepare(database, sqlStatement, -1, &compliedStatement, NULL)==SQLITE_OK)

{

while (sqlite3_step(compliedStatement)==SQLITE_ROW) {

int bytes = sqlite3_column_bytes(compliedStatement, 0);

const void *value = sqlite3_column_blob(compliedStatement, 0);

if( value != NULL && bytes != 0 ){

NSData *data = [NSData dataWithBytes:value length:bytes];

UIImage *image=[UIImage imageWithData:data];

[imageView setImage:image];

}

else{

}

}

}

sqlite3_finalize(compliedStatement);

}

sqlite3_close(database);