First I have to say I´m new in iOS Development. I want to retrieve data from sqlite and show in NSLog AND I want to put all Array into a NSMutableArray. I can not see any result really don´t know what happen.
Here is my Code:
@interface ViewController ()
{
NSMutableArray *totalStrings;
}
@property(strong, nonatomic)NSMutableArray *entries;
@end
@implementation ViewController;
@synthesize entries;
- (void)viewDidLoad {
entries = [[NSMutableArray alloc]init];
NSString *ask = [NSString stringWithFormat:@"SELECT name,address, phone FROM users"];
sqlite3_stmt *statement;
const char *query_statement = [ask UTF8String];
if(sqlite3_prepare_v2(_DB, query_statement, -1, &statement, nil) == SQLITE_OK){
while(sqlite3_step(statement) == SQLITE_ROW)
{
NSString *nameField = [[NSString alloc] initWithUTF8String:(const char *)
sqlite3_column_text(statement, 0)];
NSString *addressField = [[NSString alloc] initWithUTF8String:(const char *)
sqlite3_column_text(statement, 1)];
NSString *phoneField = [[NSString alloc] initWithUTF8String:(const char *)
sqlite3_column_text(statement, 2)];
NSString *strrr =[[NSString alloc]initWithFormat:@"%@", addressField];
[entries addObject:strrr];
/////////SHOWING LOG
NSLog(@"%@",nameField);
NSLog(@"%@",addressField);
NSLog(@"%@",phoneField);
}
sqlite3_finalize(statement);
sqlite3_close(_DB);
}
//AND PUT THOSE RESULTS INTO THIS ARRAY ( I WILL USE THIS LATER)
//I want it to be this format: totalStrings=[[NSMutableArray alloc]initWithObjects:@"test1",@"test2",@"test3", nil];
totalStrings=[[NSMutableArray alloc]initWithObjects:entries, nil];
Could somebody point me what should I do ?
Aucun commentaire:
Enregistrer un commentaire