服务器端PHP文件connect.php:
<?php
$q = mysql_connect("localhost","root","");
if(!$q)
{
die('Could not connect: ' . mysql_error());
}
mysql_query("set names utf8"); //以utf8读取数据 mysql_select_db("jasontest",$q); //数据库 $sql = "select * from userinfo";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query)){
$com= $row;
}
echo json_encode($com);
?>
IOS段解析:
- (IBAction)clickbutton:(id)sender {
[NSThread detachNewThreadSelector:@selector(getjasonstring) toTarget:self withObject:nil];
}
-(void)getjasonstring{
NSError *error;
//加载一个NSURL对象
NSURLRequest *request2 = [NSURLRequest requestWithURL:[NSURL URLWithString:@"http://localhost/jasontest/connect.php"]];
//将请求的url数据放到NSData对象中
NSData *response = [NSURLConnection sendSynchronousRequest:request2 returningResponse:nil error:nil];
//IOS5自带解析类NSJSONSerialization从response中解析出数据放到字典中
NSDictionary *jasonDic = [NSJSONSerialization JSONObjectWithData:response options:NSJSONReadingMutableLeaves error:&error]; NSLog(@"person's userid is %@",[jasonDic objectForKey:@"userid"]);
NSLog(@"person's name is %@",[jasonDic objectForKey:@"name"]);
NSLog(@"person's password is %@",[jasonDic objectForKey:@"password"]);
NSLog(@"person's phoneNo is %@",[jasonDic objectForKey:@"phoneNo"]); }