//DBManager.h

//update speakers data
-(void) updateSpeaker :(int) speakerId :(NSData*) speakerImage;

//DBManager.m

//update speaker data
-(void)updateSpeaker:(int)speakerId :(NSData *)speakerImage{
sqlite3_stmt *updateStmt = NULL;
const char *dbpath = [_databasePath UTF8String];

if(sqlite3_open(dbpath, &_contactDB) == SQLITE_OK){


const char *sql = "UPDATE SPEAKERS Set IMAGE = ? WHERE ID = ?";

if(sqlite3_prepare_v2(_contactDB, sql, -1, &updateStmt, NULL)==SQLITE_OK){
//update image
sqlite3_bind_blob(updateStmt, 1, [speakerImage bytes], [speakerImage length], SQLITE_TRANSIENT);
sqlite3_bind_int(updateStmt, 2, speakerId);
}
}
char* errmsg;
sqlite3_exec(_contactDB, "COMMIT", NULL, NULL, &errmsg);

if(SQLITE_DONE != sqlite3_step(updateStmt)){
NSLog(@"Error while updating. %s", sqlite3_errmsg(_contactDB));
}
else{
printf("
Speaker data updated successfully
");
}
sqlite3_finalize(updateStmt);
sqlite3_close(_contactDB);
}