mardi 7 avril 2015

retrieve data from sqlite in iOS

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