remote database connection with my iphone application using cocos2d

Posted by Rana on Stack Overflow See other posts from Stack Overflow or by Rana
Published on 2009-02-12T09:21:36Z Indexed on 2010/05/09 6:08 UTC
Read the original article Hit count: 535

Filed under:
|
|

MCPResult *theResult; MCPConnection *mySQLConnection;

//initialize connection string vars

NSString *dbURL = @"192.168.0.16";

NSString *userName = @"";

NSString *pass = @"";
int port = 3306;

//open connection to database
mySQLConnection = [[MCPConnection alloc]    initToHost: dbURL
											 withLogin:userName
											  password:pass
											 usingPort:port];

if ([mySQLConnection isConnected])
{
	NSLog(@"The connection to database was successfull");
}
else
{
	NSLog(@"The connection to database was failed");
}

//selection to database

if([mySQLConnection selectDB:@"blackjack_DB"])	
{

	NSLog(@"Database found");

}

else

{

	NSLog(@"Database not found");

}

//selection to Table

theResult = [mySQLConnection queryString:@"select * from test"];	
//theResult = [mySQLConnection queryString:@"select * from test where id='1'"];
//theResult = [mySQLConnection queryString:@"select id from test"];

//theResult = [mySQLConnection queryString:@"select name from test where pass='main_pass'"];

NSArray *m= [theResult fetchRowAsArray];
NSLog(@"%@", m);
NSLog(@"%@", [m objectAtIndex:2]);

Use this code for connecting & receive information from remotedatabase. And also use some framework. AppKit.framework, Cocoa.framework, Carbon.framework, MCPKit_bundled.framework. But stile i didn't connect my application with remort database.

© Stack Overflow or respective owner

Related posts about cocos2d

Related posts about mysql