IPhone Desk

How to attach database with other database in SQLite

2011-11-05T02:41:00.000-07:00

To Attach DB with another DB, i use below code................

Create first database:

[self createEditableCopyOfDatabaseIfNeeded];

Create second database:

[self createEditableCopyOfDatabaseIfNeeded_New];

Attach Database second with first:

[self AttachDB];

use of both data base in single SQL:

[self inserttblData];

-(void) AttachDB

{

BOOL success;

NSFileManager *fileManager=[[NSFileManager defaultManager]autorelease];

NSArray *paths= NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);

success = [fileManager fileExistsAtPath:[[paths objectAtIndex:0] stringByAppendingPathComponent:@"database2.sqlite3"]];

if(success)

{

NSString *sql = [NSString stringWithFormat:@"ATTACH DATABASE \"%@\" AS newdb",[[paths objectAtIndex:0] stringByAppendingPathComponent:@"database2.sqlite3"]];

// here database is an sqlite object and which refer database1

int intReturnValue = sqlite3_exec(database, [sql UTF8String], NULL, NULL, NULL);

if(intReturnValue == 1)

{

NSAssert1(0, @"Error: failed to attach database with message '%s'.", sqlite3_errmsg(database));

}

else

{

NSLog(@"Done");

}

-(int)inserttblData

{

int i=0;

@try

{

sqlite3_stmt *statement=nil;

NSString *sql=nil;

sql=[NSString stringWithFormat:@"INSERT INTO testtable1 SELECT * FROM newdb.testtable2"];

if(sqlite3_prepare_v2(database, [sql UTF8String], -1, &statement, NULL)!=SQLITE_OK)

{

NSAssert1(0, @"Error: failed to insertstatement with message '%s'.", sqlite3_errmsg(database));

}

int success=sqlite3_step(statement);

if (success == SQLITE_ERROR)

{

NSAssert1(0, @"Error: failed to insert into the database with message '%s'.", sqlite3_errmsg(database));

}

sqlite3_finalize(statement);

return i;

}

@catch (NSException *e)

{

return 0;

}

return i;

}

If you got any new way and get problem, write here.......

Thx,

Add and Remove Tabbar item Run Time

2011-09-18T02:23:00.000-07:00

In ios sdk, some time we need to insert/delete tab bar item run time. So In this case, we can add and remove tab bar items by following below code.

// Remove and Add Tab bar item from tabbar controller at run time:

-(IBAction) RemoveTab:(id)sender

{

UIViewController *itemToRemove = nil;

NSMutableArray *newItems = [NSMutableArray arrayWithArray:self.tabBarController.viewControllers];

for (UIViewController *aView in newItems)

{

if ([[[aView class] description] isEqualToString:@"FirstViewController"])

{

//store this item to remove later

itemToRemove = aView;

}

if (itemToRemove)

{

[newItems removeObject:itemToRemove];

}

// Add Tab bar item in tabbar controller at run time:

-(IBAction) AddTab:(id)sender

{

NSMutableArray *newItems = [NSMutableArray arrayWithArray:self.tabBarController.viewControllers];

//Add New ViewController

UITabBarItem *obj = [[FirstViewController alloc] init];

// or use below

//UITabBarItem *obj = [[FirstViewController alloc] initWithNibName:@"FirstViewController" bundle:nil];

[newItems addObject:obj];

obj.title = @"First";

[obj release];

[self.tabBarController setViewControllers:newItems];

}

This code has worked perfectly for me, but if you have any problem inform me.

Or get any new or more efficient way.

Thanks……………..

HOW TO CREATE PUSH NOTIFICATION CERTIFICATE:

2011-09-18T02:22:00.001-07:00

I follow the below link to create IOS push notification certificate.

http://iphonesdkdev.blogspot.com/2009/04/apns-client-development-certificate.html

Thanks……………………

Horizontal Picker

2011-09-18T02:21:00.000-07:00

use below statement to make picker horizontal:

picker.transform = CGAffineTransformMakeRotation(M_PI+M_PI_2);

picker.frame = CGRectMake(80,10 ,150,44);

Delegate and Data source function of picker:

- (UIView *)pickerView:(UIPickerView *)pickerView viewForRow:(NSInteger)row forComponent:(NSInteger)component reusingView:(UIView *)view

{

UILabel *label = [[UILabel alloc] initWithFrame:CGRectMake(0, 0, 150, 20)];

label.text = @"miles";

label.textAlignment = UITextAlignmentCenter;

label.textColor = [UIColor blackColor];

label.font = [UIFont systemFontOfSize:13];

label.backgroundColor = [UIColor clearColor];

label.opaque = NO;

CGAffineTransform rotate = CGAffineTransformMakeRotation(1.57);

[label setTransform:rotate];

return label;

}

- (CGFloat)pickerView:(UIPickerView *)pickerView widthForComponent:(NSInteger)component

{

return 30;

}

- (CGFloat)pickerView:(UIPickerView *)pickerView rowHeightForComponent:(NSInteger)component

{

return 80;

}

Get String From HTML String

2011-09-18T01:52:00.000-07:00

- (NSString *)flattenHTML:(NSString *)htmlstr
{
NSScanner *theScanner;
NSString *text = nil;
theScanner = [NSScanner scannerWithString: htmlstr];
while ([theScanner isAtEnd] == NO) {
// find start of tag
[theScanner scanUpToString:@"<" intoString:NULL] ;
// find end of tag
[theScanner scanUpToString:@">" intoString:&text] ;
// replace the found tag with a space
//(you can filter multi-spaces out later if you wish)
htmlstr = [htmlstr stringByReplacingOccurrencesOfString:
[ NSString stringWithFormat:@"%@>", text]
withString:@" "];
} // while //
htmlstr=[htmlstr stringByReplacingOccurrencesOfString:@" " withString:@" "];
htmlstr=[htmlstr stringByReplacingOccurrencesOfString:@"\n" withString:@""];
htmlstr=[htmlstr stringByReplacingOccurrencesOfString:@"\r" withString:@""];
NSCharacterSet *set = [NSCharacterSet characterSetWithCharactersInString:@" "];
htmlstr =[htmlstr stringByTrimmingCharactersInSet:set]retain];
return htmlstr;
}

How to Capture Video thumbnail from video URL

2011-09-18T01:49:00.000-07:00

Include the Following Framework in project:
AVFoundation.framework
CoreMedia.framework

- (void) CaptureThumnailImageFromVideoURl
{
// NSURL *url = [NSURL URLWithString:@"http://videos.imotors.com/videos/1onONE/1onONE_intro_new.mp4"];
NSURL *url = [NSURL URLWithString:@"http://videos.imotors.com/videos/Top200/Top200_2010_Audi_A8.mp4"];
AVURLAsset *asset=[[AVURLAsset alloc] initWithURL:url options:nil];
AVAssetImageGenerator *generator = [[AVAssetImageGenerator alloc] initWithAsset:asset];
generator.appliesPreferredTrackTransform=TRUE;
[asset release];
CMTime thumbTime = CMTimeMakeWithSeconds(0,15);
AVAssetImageGeneratorCompletionHandler handler = ^(CMTime requestedTime, CGImageRef img, CMTime actualTime, AVAssetImageGeneratorResult result, NSError *error){
if (result != AVAssetImageGeneratorSucceeded) {
NSLog(@"couldn't generate thumbnail, error:%@", error);
}
thumbImageview.image = [UIImage imageWithCGImage: img];
[generator release];
};
CGSize maxSize = CGSizeMake(100, 90); // define the size of image.
generator.maximumSize = maxSize;
[generator generateCGImagesAsynchronouslyForTimes:[NSArray arrayWithObject:[NSValue valueWithCMTime:thumbTime]] completionHandler:handler];
}

Combine Images In IOS

2011-09-10T00:44:00.000-07:00

Combine two images:
UIImage *firstImage = [UIImage imageNamed:@"a.jpg"];

UIImage *secondImage = [UIImage imageNamed:@"b.jpg"];

CGSize size = CGSizeMake(firstImage.size.width+secondImage.size.width,firstImage.size.height);
UIGraphicsBeginImageContext(size);
[firstImage drawAtPoint:CGPointMake(0,0)];

[secondImage drawAtPoint:CGPointMake(firstImage.size.width,0)];
UIImage *newImage = UIGraphicsGetImageFromCurrentImageContext();
[self saveImage:newImage withName:@"ABC.png"];

UIGraphicsEndImageContext();

Store image in document.

-(void)saveImage:(UIImage *)image withName:(NSString *)name
{
NSData *data = UIImagePNGRepresentation(image);
// NSData *data = UIImageJPEGRepresentation(image, 1);
NSFileManager *fileManager = [NSFileManager defaultManager];
NSString* documentsDirectory=[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory , NSUserDomainMask, YES)
objectAtIndex:0];
NSString *fullPath = [documentsDirectory stringByAppendingPathComponent:name];
[fileManager createFileAtPath:fullPath contents:data attributes:nil];
}

RESULT:

Thanks.............

Add Custom Label in Default Contact Application

2011-09-10T00:37:00.000-07:00

To Add custom label in Default contact, we can try below code.

CFErrorRef error = NULL;
ABAddressBookRef iPhoneAddressBook = ABAddressBookCreate();
ABRecordRef newPerson = ABPersonCreate();
const CFStringRef customLabel = CFSTR( "Nir" );

//phone
ABMutableMultiValueRef multiPhone = ABMultiValueCreateMutable(kABMultiStringPropertyType);
ABMultiValueAddValueAndLabel(multiPhone, @"CUSTOM LABEL", customLabel, NULL);
ABRecordSetValue(newPerson, kABPersonPhoneProperty, multiPhone,nil);
CFRelease(multiPhone);
ABAddressBookAddRecord(iPhoneAddressBook, newPerson, &error);
ABAddressBookSave(iPhoneAddressBook, &error);
ABAddressBookRemoveRecord(iPhoneAddressBook, newPerson, &error);
ABAddressBookSave(iPhoneAddressBook, &error);
if (error != NULL)
{
NSLog(@"Error!");
}

THANKS................

Remove Characters from String

2011-09-10T00:34:00.000-07:00

Remove Character set form string:

NSString *strPhone = @"54564-6556-6-65(113)";

NSCharacterSet *charactersToRemove =[[NSCharacterSet characterSetWithCharactersInString:@"0123456789"] invertedSet];

strPhone = [[strPhone componentsSeparatedByCharactersInSet:charactersToRemove] componentsJoinedByString:@""];

NSLog(@"%@",strPhone);

Result : Get 545646556665113 by removing -,( and ) from string

NSString *strPhone = @"54564-6556-6-65(113)";

NSCharacterSet *charactersToRemove =[NSCharacterSet characterSetWithCharactersInString:@"0123456789"];

strPhone = [[strPhone componentsSeparatedByCharactersInSet:charactersToRemove] componentsJoinedByString:@""];

NSLog(@"%@",strPhone);

Result : Get --() by removing all entry of 0123456789

thanks
Happpppyyyyyyy Pro.....................

Apple Upcoming iPhone 5 Concept Design

2011-07-03T00:14:00.000-07:00

Follow the below link:

http://www.crazynoob.in/news/apple-upcoming-iphone-5-concept-design-inspired-by-6th-generation-ipod-nano/2011070242

iCloud Officially Announced

2011-06-26T00:16:00.000-07:00

Pls, Follow the below link:

http://iphone5release.org/icloud-officially-announced/

Iphone:Trimming whitespace characters from NSString

2011-06-25T02:43:00.000-07:00

If you need to trim whitespace characters at the start and end of a NSString, here’s an easy way:

existingStr = [ existingStr stringByTrimmingCharactersInSet:[NSCharacterSet whitespaceAndNewlineCharacterSet]] ;

iphone:Rotate UI Component.

2011-06-25T00:21:00.000-07:00

We can rotate UI component through CGAffineTransformMakeRotation such as.

Rotate Button:

btn.transform = CGAffineTransformMakeRotation(0.15);

Rotate Label:

lbl.transform = CGAffineTransformMakeRotation(0.15);

New Features In iOS 5 [FULL DETAILS]

2011-06-18T00:14:00.000-07:00

Pls, Follow the Below link:

http://www.ithinkdiff.com/new-features-in-ios-5-for-iphone-ipad-ipod-revealed-at-wwdc-2011-full-details/

Iphone: Use of NSUserDefault

2011-06-11T00:31:00.000-07:00

NSUserDefaults class gives us an opportunity to save values without requiring any database. This class uses Key-value coding structure model for saving and loading values. Key-value coding defines generic properties accessor methods—valueForKey: and setValue:forKey:—which identify properties through Key Value Same As Dictionary.

Object for NSUserDefault:

NSUserDefaults *prefs = [NSUserDefaults standardUserDefaults];

Save Values In NSUserDefault:

// Saving an Object

[prefs setObject:obj forKey:@"keyObj"];

// saving an NSString
[prefs setObject:@"String" forKey:@"keyString"];

// saving an NSInteger
[prefs setInteger:10 forKey:@"KeyInt"];

// saving a Double
[prefs setDouble:4.112 forKey:@"KeyDouble"];

// saving a Float
[prefs setFloat:1.000045 forKey:@"KeyFloat"];

// This is suggested to synch the NS Object,

[prefs synchronize];

Retrieving Value From NSUserDefault:

NSUserDefaults *prefs = [NSUserDefaults standardUserDefaults];

// getting an Object
NSObject *myObj = [prefs objectForKey:@"KeyObj"];

// getting an NSString
NSString *myString = [prefs stringForKey:@"keyString"];

// getting an NSInteger
NSInteger myInt = [prefs integerForKey:@"keyInt"];

// getting an Float
float myFloat = [prefs floatForKey:@"keyFloat"];

Basically NSUserDefault is used to store value for further use when database is not user or store value for any system crash.

thanks

To change the default color of the Tab-Bar

2011-06-05T23:00:00.000-07:00

Add the below code in viewWillAppear of your class

CGRect frame =

CGRectMake(0.0, 0.0,self.view.bounds.size.width, 48);

UIView *v = [[UIView alloc] initWithFrame:frame];

[v setBackgroundColor:[UIColor colorWithRed:0.1 green:0.2 blue:0.6 alpha:0.8]];

[v setAlpha:0.5];

[[self.tabBarController tabBar] insertSubview:v atIndex:0];

[v release];

And we can also image pattern color.

UIImage *i = [UIImage imageNamed:@"abc.png"];

UIColor *c = [[UIColor alloc] initWithPatternImage:i];

And we can also place image in tabbar background.

CGRect frame =

CGRectMake(0.0, 0.0,self.view.bounds.size.width, 48);

UIImageView *v = [[UIImageView alloc] initWithFrame:frame];

[v setImage:[UIImage imageNamed:@”YOUR IMAGE NAME”]];

[v setAlpha:0.5];

[[self.tabBarController tabBar] insertSubview:v atIndex:0];

[v release];

Load Xib at run time

2011-05-28T02:31:00.000-07:00

We Can load the Xib at run time which make easy the work of resetting the frame for Portrait and landscape. Because We can create two Xib , One for portrait and second for landscape and then load at run time.

- (BOOL)shouldAutorotateToInterfaceOrientation:(UIInterfaceOrientation)interfaceOrientation
{
if(interfaceOrientation == UIInterfaceOrientationPortrait || interfaceOrientation == UIInterfaceOrientationPortraitUpsideDown)

{

[[NSBundle mainBundle] loadNibNamed:@"IpadChangeXibAtRunTimeViewController" owner:self options:nil];

}
else
{

[[NSBundle mainBundle] loadNibNamed:@"IpadChangeXibAtRunTimeL" owner:self options:nil]; } return YES;

}

UTF String Convertion

2011-05-28T02:25:00.000-07:00

-(NSString *)encodeString:(NSString *)string
{
NSString *result = (NSString *)CFURLCreateStringByAddingPercentEscapes(kCFAllocatorDefault, (CFStringRef)string, NULL, CFSTR("% '\"?=&+<>;:-"), kCFStringEncodingUTF8); return [result autorelease];

}

or

We Can insert %20 in place on Space in String by below statement:
str =[str stringByAddingPercentEscapesUsingEncoding:NSStringEncodingConversionExternalRepresentation];

Iphone:set badge on tabbar Item

2011-05-28T00:25:00.000-07:00

UITabBarItem *tbi = (UITabBarItem *)[tabBarController.tabBar.items objectAtIndex:2];

UITabBarItem *tbi = (UITabBarItem *)[AppDel.tabBarController.tabBar.items objectAtIndex:2];

tbi.badgeValue = @"2"; // 2 define the value that would be display on tabbar item.

Iphone: Set Image on UIButton

2011-05-22T04:29:00.000-07:00

Iphone: Set Image on UIButton

On UIButton, Image Can be set as Button image or can Button Background Image.

Basically, Button Image Is not useful to set because if we set button image then Button will enlarge

according to the image size.

So it is useful to set Image on background. In this case, the image will fit to button Size.

so it can be use many places where we will have to use button and ImageView both such as Add contact image,etc..................

set Button title:

[imageButton setTitle: @"XYZ" forState: UIControlStateNormal];

Set Button Background image

[imageButton setBackgroundImage:image forState:UIControlStateNormal];

Set Button Image:

[imageButton setImage:image forState:UIControlStateNormal];

thank.........

Download Video from the URL:

2011-05-22T03:33:00.000-07:00

NSMutableURLRequest *request = [[[NSMutableURLRequest alloc] init] autorelease];

[request setHTTPMethod:@"GET"];

NSError *error;

NSURLResponse *response;

NSString *documentFolderPath = [NSHomeDirectory() stringByAppendingPathComponent:@"Documents"];

NSFileManager *fileManager = [NSFileManager defaultManager];

NSString *videosFolderPath = [documentFolderPath stringByAppendingPathComponent:@"videos"];

//Check if the videos folder already exists, if not, create it!!!

BOOL isDir;

if (([fileManager fileExistsAtPath:videosFolderPath isDirectory:&isDir] && isDir) == FALSE) {

[[NSFileManager defaultManager] createDirectoryAtPath:videosFolderPath attributes:nil];

}

NSData *urlData;

NSString *downloadPath = @"http://foo.com/videos/bar.mpeg";

[request setURL:[NSURL URLWithString:downloadPath]];

urlData = [NSURLConnection sendSynchronousRequest:request returningResponse:&response error:&error];

NSString *filePath = [videosFolderPath stringByAppendingPathComponent:@"bar.mpeg"];

BOOL written = [urlData writeToFile:filePath atomically:NO];

if (written)

NSLog(@"Saved to file: %@", filePath);

Integration of Twitter

2011-05-22T03:32:00.000-07:00

some simple step to integrate twitter with iphone sdk.

1. Drag and Drop Libraries folder

2. Drag and Drop yaji folder

3. include libxml2.dylib and also check the it include in General tab framework of target. // otherwise give 8 error

4. Add "/usr/include/libxml2" in header search path
5. Add -lxml2 in other linker flag

6. Add other code for integration.

How to detect the link click in UIWebView

2011-05-21T05:35:00.000-07:00

If App has an Web View and web view has some link and we want to identify the click event and open the link in safari or open mail window, then follow as below code.

- (BOOL)webView:(UIWebView*)webView shouldStartLoadWithRequest:(NSURLRequest*)request navigationType:(UIWebViewNavigationType)navigationType {

//CAPTURE USER LINK-CLICK.

if (navigationType == UIWebViewNavigationTypeLinkClicked) {

NSURL *URL = [request URL];

if ([[URL scheme] isEqualToString:@"http"]) {

[[UIApplication sharedApplication] openURL:URL];

return NO;

}

else if ([[URL scheme] isEqualToString:@"mailto"]) {

[[UIApplication sharedApplication] openURL:URL];

return NO;

}

return YES;

}

Permanent iPhone 4 Unlock, iPad 2 Jailbreak

2011-05-14T06:01:00.000-07:00

To jailbreak use below link:

http://video.ezinemark.com/permanent-iphone-4-unlock-ipad-2-jailbreak-chevronwp7-labs-more-besttechinfo-rumors-21-4852faf1c0c.html

How to find city name and other detail from lat/long

2011-05-14T03:30:00.000-07:00

Here i m detailing, how to get detail information from lat/long.

for .h file.

import framework

implement MKMapViewDelegate and MKReverseGeocoderDelegate

Declare MKReverseGeocoder *reverseGeocoder;

@property (nonatomic, retain) MKReverseGeocoder *reverseGeocoder;

for .m file.

@synthesize reverseGeocoder;

CLLocationCoordinate2D coord2d;

coord2d.latitude =19.3;

coord2d.longitude =73.9 ;

self.reverseGeocoder =[[[MKReverseGeocoder alloc] initWithCoordinate:coord2d] autorelease];

Note: If we get data detail for Current location then we can use below statement:

[[[MKReverseGeocoder alloc] initWithCoordinate:mapView.userLocation.location.coordinate] autorelease];

reverseGeocoder.delegate = self;

[reverseGeocoder start];

- (void)reverseGeocoder:(MKReverseGeocoder *)geocoder didFailWithError:(NSError *)error

{

NSString *errorMessage = [error localizedDescription];

UIAlertView *alertView = [[UIAlertView alloc] initWithTitle:@"Cannot obtain address."

message:errorMessage

delegate:nil

cancelButtonTitle:@"OK"

otherButtonTitles:nil];

[alertView show];

[alertView release];

}

- (void)reverseGeocoder:(MKReverseGeocoder *)geocoder didFindPlacemark:(MKPlacemark *)placemark

{

NSLog(@"Thoroughfare : %@",placemark.thoroughfare);

NSLog(@"Sub-thoroughfare : %@",placemark.subThoroughfare);

NSLog(@"Locality : %@",placemark.locality);

NSLog(@"Sub-locality : %@",placemark.subLocality);

NSLog(@"Administrative Area : %@",placemark.administrativeArea);

NSLog(@"Sub-administrative Area : %@",placemark.subAdministrativeArea);

NSLog(@"Postal Code : %@",placemark.postalCode);

NSLog(@"Country : %@",placemark.country);

NSLog(@"Country Code: %@",placemark.countryCode);

}