Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -(void) readtheDB {
- // Open the database.
- if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {
- NSString *updateQuery = [[NSString alloc] initWithFormat:@"SELECT * FROM people"];
- const char *query = [updateQuery UTF8String];
- [updateQuery release];
- sqlite3_stmt *statement;
- int res = (sqlite3_prepare_v2( database, query, -1, &statement, NULL));
- if(res == SQLITE_OK) {
- while(sqlite3_step(statement) == SQLITE_ROW) {
- // Read the data from the result row
- NSString *aUser = [NSString stringWithUTF8String:(char *)sqlite3_column_text(statement, 0)];
- NSString *aPass = [NSString stringWithUTF8String:(char *)sqlite3_column_text(statement, 1)];
- NSString *url = [NSString stringWithUTF8String:(char *)sqlite3_column_text(statement, 2)];
- NSLog(aUser);
- NSLog(aPass);
- }
- sqlite3_finalize(statement);
- }else {
- NSLog(@"Failed to prepare read query with error code: %d", res);
- }
- }else {
- NSLog(@"Failed to open the database");
- }
- sqlite3_close(database);
- }
Add Comment
Please, Sign In to add comment