mysql的post请求

把mysql的php接口定义为宏

#define kWangyiHeadNewsAPI @"http://localhost:8888/job/jobs.php"

.m文件

@interface WhyMainViewController ()
{
    NSMutableArray *jobsArray;
}
@end

- (void)viewDidLoad
{
    [super viewDidLoad];

    [self sendPostForLogin];
}

#pragma mark - 测试NSURLConnection发送POST请求
-(void)sendPostForLogin
{
    NSURL *url = [NSURL URLWithString:@"http://localhost:8888/job/login.php"];
    //发送的POST参数
    NSString *paras = @"username=Fui&password=12345";
    NSData *data = [paras dataUsingEncoding:NSUTF8StringEncoding];
    
    NSMutableURLRequest *request = [[NSMutableURLRequest alloc]init];
    [request setURL:url];
    [request setTimeoutInterval:10];
    [request setCachePolicy:NSURLRequestUseProtocolCachePolicy];
    //POST请求
    [request setHTTPMethod:@"POST"];
    //参数与body一起发送
    [request setHTTPBody:data];
    
    //发送同步请求
    NSData *received = [NSURLConnection sendSynchronousRequest:request returningResponse:nil error:nil];
    
    NSString *result = [[NSString alloc]initWithData:received encoding:NSUTF8StringEncoding];
    NSLog(@"result = %@",result);
    
}

#pragma mark - 使用委托方法发送异步请求
- (void)loadNews
{
    NSURL *url = [NSURL URLWithString:@"http://localhost:8888/job/jobs.php"];
    //根据NSURL创建请求(此处为可扩展请求)
    NSMutableURLRequest *request = [NSMutableURLRequest requestWithURL:url];
    
    //发送异步请求建立连接，同时设置委托对象
    [NSURLConnection connectionWithRequest:request delegate:self];
}

#pragma mark - 基于block发送异步请求
-(void)loadNews2
{
    NSURL *url = [NSURL URLWithString:kWangyiHeadNewsAPI];
    //根据NSURL创建请求(此处为可扩展请求)
    NSMutableURLRequest *request = [NSMutableURLRequest requestWithURL:url];
    [NSURLConnection sendAsynchronousRequest:request queue:[NSOperationQueue mainQueue] completionHandler:^(NSURLResponse *response, NSData *data, NSError *connectionError) {
        if (connectionError == nil) {
            //解析JSON
            NSArray *dataArray = [NSJSONSerialization JSONObjectWithData:data options:NSJSONReadingMutableLeaves error:nil];
            NSLog(@"%@",dataArray);
            
        }
    }];
}

#pragma mark - 请求成功，接收返回数据
-(void)connection:(NSURLConnection *)connection didReceiveData:(NSData *)data
{
    //获取json字符串
    NSString *json = [[NSString alloc] initWithData:data encoding:NSUTF8StringEncoding];
    NSLog(@"%@",json);
    
    //解析JSON
    NSDictionary *dic = [NSJSONSerialization JSONObjectWithData:data options:NSJSONReadingMutableLeaves error:nil];
    NSLog(@"%@",dic);
    NSNumber *status = [dic objectForKey:@"status"];
    if ([status intValue] == 1) {
        NSArray *array = [dic objectForKey:@"result"];
        
        for (NSDictionary *obj in array) {
            jobs *n = [[jobs alloc]init];
            
            NSString *strID = (NSString *)[obj objectForKey:@"job_id"];
            n.jobid = [strID intValue];
            NSString *strAward = [obj objectForKey:@"award"];
            n.award = [strAward intValue];
            n.companyName = [obj objectForKey:@"company_name"];
            n.city = [obj objectForKey:@"city"];
            n.name = [obj objectForKey:@"job_name"];
            
            [jobsArray addObject:n];
        }
        [self.tableView reloadData];
        NSLog(@"请求成功！");
    }
    else{
        NSLog(@"请求失败！");
    }
    
//    NSArray *arr = [dic objectForKey:@"T1348649580692"];
//    for (NSDictionary *obj in arr) {
//        News *n = [[News alloc]init];
//        n.title = [obj objectForKey:@"title"];
//        n.imageUrl = [obj objectForKey:@"imgsrc"];
//        n.detailUrl = [obj objectForKey:@"url_3w"];
//        n.timeConsuming = [obj objectForKey:@"lmodify"];
//        [array addObject:n];
//    }
//    [self.tableView reloadData];
    
}