I want to create an app with a web form,PHP code and a mySQL database so the user can input some info (like a client database). I want the mySQL database to get syncronized with the database I am having at my server (HOSTGATOR) whenever iphone is connected to internet. Is this able?

if you know what you're doing, yes. Here's how you would send a few form fields to an online php script: NSString *post =[NSString stringWithFormat:@"%@=%@&%@=%@&%@=%@",field1, value1, field2, value2, field3, value3]; NSData *postData = [post dataUsingEncoding:NSASCIIStringEncoding allowLossyConversion:YES]; NSString *postLength = [NSString stringWithFormat:@"%d", [postData length]]; NSMutableURLRequest *request = [[[NSMutableURLRequest alloc] init] autorelease]; [request setURL:phpScriptURL]; [request setHTTPMethod:@"POST"]; [request setValue:postLength forHTTPHeaderField:@"Content-Length"]; [request setValue:@"application/x-www-form-urlencoded" forHTTPHeaderField:@"Content-Type"]; [request setHTTPBody:postData]; NSError *error; NSURLResponse *response; NSData *urlData=[NSURLConnection sendSynchronousRequest:request returningResponse:&response error:&error]; NSString *data=[[NSString alloc]initWithData:urlData encoding:NSUTF8StringEncoding]; NSLog(@"%@", data);

you are the best!!! when I have the app ready I'll post the results here.

happy to help :)

Nice stuff, Chris! Cheers! -- Smug

Awesome share Chris... any idea on how to alert if internet connection is not available so that the user knows nothing is happening?

I use this snippet in my app, with the assumption that 'google' is active... Reachability *r = [Reachability reachabilityWithHostName:@"m.google.com"]; NetworkStatus internetStatus = [r currentReachabilityStatus]; if(internetStatus == NotReachable){ NSLog(@"There's no connection"); UIAlertView *errorAlertView = [[UIAlertView alloc] initWithTitle:@"No internet connection" message:@"Internet connection is required to use this app" delegate:nil cancelButtonTitle:@"OK" otherButtonTitles:nil]; [errorAlertView show]; }else NSLog(@"Internet connection is OK"); } I place this is my "appDidFinishLaunching" code, but if you're just worried about a particular plugin, you can put it in the "viewDidLoad" method, with pretty much the same results. I don't think I had to add any imports or anything... Let me know if it weirds out on you. Cheers! -- Smug

Thank you Smug