Remote Mysql database interaction problem

[bhanupriya]

Hi All,

I am trying to interact with remote mysql database with using NSURL.

below is my code :

NSString *mutableUrlString = @"http://mysite.com/testSample.php?userName=";
mutableUrlString = [mutableUrlString stringByAppendingString: firstnameTextfield.text];
[NSURL URLWithString: mutableUrlString];

In php file added code to insert the username into the database.

If i run this code

In console i am getting the below error

2009-07-06 19:03:09.776 gdb-i386-apple-darwin[500:613] _CFGetHostUUIDString: unable to determine UUID for host. Error: 35

I am unable to interact and insert or retieve the values from the mysql database. PHP code is fine. But if i call that url in iphone the values are not inserting into the database. Iam running this code in IPhone simulator 3.0


Please help me. How i need to solve the problem.

Thanks

[bhanupriya]

Please i need a solution for this problem. No body faced this problem.

[Kumulos]

Hi bhanupriya,

If you haven't yet managed to solve your problem, you might want to look at a solution that avoids this kind of development work altogether.

We are doing Beta testing on a new system called Kumulos, which allows you to create hosted databases easily and create API's and Objective-C bindings. It very easy to use and could cut your development time and hassle significantly.

Check out a tutorial at : Kumulos Tutorial With Sample Code | kumulos.com

Thanks

Kumulos

[iphonegamedeveloper]

Originally Posted by bhanupriya

Hi All,

I am trying to interact with remote mysql database with using NSURL.

below is my code :



In php file added code to insert the username into the database.

If i run this code

In console i am getting the below error

2009-07-06 19:03:09.776 gdb-i386-apple-darwin[500:613] _CFGetHostUUIDString: unable to determine UUID for host. Error: 35

I am unable to interact and insert or retieve the values from the mysql database. PHP code is fine. But if i call that url in iphone the values are not inserting into the database. Iam running this code in IPhone simulator 3.0


Please help me. How i need to solve the problem.

Thanks

Try this


mutableUrlString=[NSString stringWithFormat:@"http://mysite.com/testSample.php?userName=%@",firstnameTextfield.tex t];

[NSURL URLWithString: mutableUrlString];

[SoftmasterG]

You need to expose the exact URL that you are sending to the NSURL i.e. you need to see what the string is via NSLog and odds are that there are some spaces or other characters that need to be escaped in order for the URL to be valid.