Solved

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

Posted on 2011-03-19
8
1,004 Views
Last Modified: 2013-11-25
what code i have to use to connect ios programm to a data base server?
0
Comment
Question by:a_sane3
8 Comments
 
LVL 5

Expert Comment

by:mad_mac
ID: 35180483
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
 
LVL 13

Accepted Solution

by:
SpeedyApocalypse earned 500 total points
ID: 35212227
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
 
LVL 3

Expert Comment

by:gawhemant
ID: 35212941
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

 

Author Comment

by:a_sane3
ID: 35516108
Thanx allot
ahmad
0
 
LVL 13

Expert Comment

by:SpeedyApocalypse
ID: 35517481
The original asker has said "thanks" but has not assigned any points.  Clearly he has received his answer.
0
 
LVL 13

Expert Comment

by:SpeedyApocalypse
ID: 35518131
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

Featured Post

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wanted to watch videos in your computer from the bed without the need of standing up and shutting down the computer?  Is your computers operating system Windows XP, Windows Vista or Windows 7?  Do you own a iOS device? If all the answers were y…
CocoaPods is the best way to manage library dependencies in iOS and OS X projects. By using cocoa pods there is no need of downloading the code from github and copying to your project. There are plenty of open source libraries now available with C…
The goal of this video is to provide viewers with basic examples to understand recursion in the C programming language.
The goal of this video is to provide viewers with basic examples to understand and use switch statements in the C programming language.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question