//**********************************************************************************
//**********************************************************************************
//**********************************************************************************

SpeakersBean *speaker = [SpeakersBean new];
NSMutableArray *mobileArrya=[NSMutableArray new];
NSMutableArray *phoneArray=[NSMutableArray new];
//Database delete queries
//NSString *deleteSpeakersTable = @"DELETE FROM SPEAKERS";

//clear speakers table
//[dbobj clearTables:deleteSpeakersTable];
//printf("
Table Speakers Deleted
");

mobileArrya=[myresult objectForKey:@"mobiles"];
phoneArray=[myresult objectForKey:@"phones"];
//ID, FIRSTNAME , LASTNAME , COMPANYNAME , TITLE , PHONES , MOBILES , MIDDLENAME , BIOGRAPHY , IMAGE , GENDER
speaker.firstName=@"dddd";
speaker.lastName=@"dddd";
speaker.companyName=@"dddd";
speaker.title=@"dddd";
speaker.biography=@"dddd";
speaker.middleName=@"dddd";
speaker.gender=@"dddd";
NSString *mobile=[NSString new];

if([mobileArrya count]==0){
mobile=@"no mobile";
printf("mobile arr is null");
}else{
mobile=[mobileArrya objectAtIndex:0];
}
NSString *phone=[NSString new];
if([phoneArray count]==0){
phone=@"no phone";
}else{
phone=[phoneArray objectAtIndex:0];
}


speaker.phone=phone;
speaker.mobile=mobile;


NSData *profileimge=[NSData dataWithContentsOfURL:[NSURL URLWithString:[myresult objectForKey:@"imageURL"]]];
speaker.img=profileimge;

// insert here database

[dbobj insertInSpeakers:speaker];

//select from speakers
NSMutableArray *tmp = [NSMutableArray new];
tmp = [dbobj selectFromSpeakers];
SpeakersBean *speakerr = [tmp objectAtIndex:0];
printf("nameeeeeeee: %s", [speakerr.firstName UTF8String]);

//**********************************************************************************
//**********************************************************************************
//**********************************************************************************