• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1013
  • Last Modified:

what code i have to use to connect ios programm to a data base server?

what code i have to use to connect ios programm to a data base server?
0
a_sane3
Asked:
a_sane3
1 Solution
 
mad_macCommented:
hi, you will need to be a bit more specific about what you are trying to achieve.  are you looking to run an application on a private network connecting to a DB host, does the app want to work over the internet...?

normall you would place some form of REST based web service in front of the database and connect via those published services.  well that's the model i have followed in my applications.
0
 
SpeedyApocalypseCommented:
Hello,

Could you please specify your type of database server that you have?

Generally, the method of connection to an online program through an iOS Application would be using NSURLConnection.  This allows you to send POST and GET data toward a certain URL and receive information back through NSData.  For example, suppose you have a script that receives a variable and does something.  For example:

<?php

include("database.php");

$myvar = $_GET['v'];
$query = mysql_query("SELECT * FROM table WHERE variable =  '$myvar'");
$array = mysql_fetch_array($query);
echo json_encode($array);

?>

Open in new window


That script simply returns a JSON array of your data... you could call it using a get parameter like so:

http://www.example.com/?v=tom

On the iPhone Side, your NSURLConnection may look like this:

	NSData *data;
    NSURLResponse *response;
    NSError *error;
	NSString *urlString = [NSString stringWithFormat:@"http://www.example.com/?v=tom"];
	urlString = [urlString stringByAddingPercentEscapesUsingEncoding:NSUTF8StringEncoding];
    NSURL *url = [NSURL URLWithString:urlString];
    NSURLRequest *request = [NSURLRequest requestWithURL:url];
    [[UIApplication sharedApplication] setNetworkActivityIndicatorVisible:YES];
    data = [NSURLConnection sendSynchronousRequest:request returningResponse:&response error:&error];
    [[UIApplication sharedApplication] setNetworkActivityIndicatorVisible:NO];
	
	NSString *resultString = [[[NSString alloc] initWithData:data encoding:NSUTF8StringEncoding] autorelease];
    
    NSLog(@"The returned data: %@",resultString);

Open in new window


So, the returned data would be whatever was echo'd or displayed on your server.

Does this help answer your question?
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
a_sane3Author Commented:
Thanx allot
ahmad
0
 
SpeedyApocalypseCommented:
The original asker has said "thanks" but has not assigned any points.  Clearly he has received his answer.
0
 
SpeedyApocalypseCommented:
3) Accept one or more Expert posts as the answer

I have explained the act of connecting to a database, on the site - instead of a simple link. POST ID: 35212227

Thanks,

SpeedyApocalypse
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now