Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //My Dictionary of objects.
- -(NSMutableDictionary *)getAllPOI{
- //select sponser details
- //create sql string
- NSString *sql = [NSString stringWithFormat:@"SELECT * FROM POI;"];
- //create sql statement
- sqlite3_stmt *statment;
- //create array to stire all the entires in.
- NSMutableDictionary *dic =[[NSMutableDictionary alloc]init ];
- //check to make sure statement runs ok
- if (sqlite3_prepare_v2(db, [sql UTF8String], -1, &statment, nil) == SQLITE_OK) {
- //foreach row
- while (sqlite3_step(statment)==SQLITE_ROW) {
- POIDataObject * mydata = [[POIDataObject alloc] init];
- char *field0 = (char *) sqlite3_column_text(statment, 0);
- char *field1 = (char *) sqlite3_column_text(statment, 1);
- char *field2 = (char *) sqlite3_column_text(statment, 2);
- char *field3 = (char *) sqlite3_column_text(statment, 3);
- char *field4 = (char *) sqlite3_column_text(statment, 4);
- char *field5 = (char *) sqlite3_column_text(statment, 5);
- char *field6 = (char *) sqlite3_column_text(statment, 6);
- char *field7 = (char *) sqlite3_column_text(statment, 7);
- char *field8 = (char *) sqlite3_column_text(statment, 8);
- char *field9 = (char *) sqlite3_column_text(statment, 9);
- char *field10 = (char *) sqlite3_column_text(statment, 10);
- char *field11 = (char *) sqlite3_column_text(statment, 11);
- char *field13 = (char *) sqlite3_column_text(statment, 13);
- mydata.poiID = [[NSString alloc]initWithUTF8String:field0];
- mydata.name = [[NSString alloc]initWithUTF8String:field1];
- mydata.catID = [[NSString alloc]initWithUTF8String:field2];
- mydata.description = [[NSString alloc]initWithUTF8String:field3];
- mydata.latitude = [[NSString alloc]initWithUTF8String:field4];
- mydata.longitude = [[NSString alloc]initWithUTF8String:field5];
- mydata.www = [[NSString alloc]initWithUTF8String:field6];
- mydata.email = [[NSString alloc]initWithUTF8String:field7];
- mydata.phone = [[NSString alloc]initWithUTF8String:field8];
- mydata.status = [[NSString alloc]initWithUTF8String:field9];
- mydata.retailer = [[NSString alloc]initWithUTF8String:field10];
- mydata.sponsor = [[NSString alloc]initWithUTF8String:field11];
- mydata.baner = [[NSString alloc]initWithUTF8String:field13];
- [dic setObject:mydata forKey:mydata.poiID];
- }
- }
- NSLog(@"pois: %@",[dic objectForKey:@"1"]);
- return dic;
- }
- NSMutableDictionary *allPOIs = [[NSMutableDictionary alloc]init];
- allPOIs = [dataBase getAllPOI];
- for (NSMutableDictionary *pois in allPOIs) {
- NSLog(@"The POI sub dic: %@",pois);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement