i'm making a view lyric apps,
and i have a feature "Favourite lyric" in my apps,
but when i compile my add to favourite, it doesn't work,
it's print Error
i guess it doesn't work in here sqlite3_step(stmt)==SQLITE_DONE
here's my insert fav method :
-(void)insertFav:(Favorite*)fav{
fileMgrs = [NSFileManager defaultManager];
sqlite3_stmt *stmt=nil;
NSString *sqlQuery=[NSString stringWithFormat:@"INSERT INTO listfavorite (email,id) VALUES ('%@','%d') ;",fav.email,fav.id];
NSLog(@"query:%@",sqlQuery);
const char *sql =[sqlQuery cStringUsingEncoding:NSUTF8StringEncoding];
//Open db
NSString *cruddatabase = [self.GetCacheDirectory stringByAppendingPathComponent:@"mydatabase.sqlite"];
sqlite3_open([cruddatabase UTF8String], &db);
sqlite3_prepare_v2(db, sql, -1, &stmt, NULL);
if(sqlite3_step(stmt)==SQLITE_DONE)
{
NSLog(@"masuk woy");
}
else{
NSLog(@"ERROR");
}
sqlite3_reset(stmt);
sqlite3_finalize(stmt);
sqlite3_close(db);
}
Here's my listfavorite database table : database
Aucun commentaire:
Enregistrer un commentaire