以OC作为终端调用PHP代码操作服务器和数据库:
OC部分代码:
+ (void)requestService:(NSString*)url
parameters:(NSDictionary*)parameter
onSuccess:(void(^)(NSDictionary*))successHandler
onFailure:(void(^)(NSError*))failureHandler
{
__blockNSData*httpBody = nil;
NSError*error;
httpBody = [NSJSONSerializationdataWithJSONObject:parameter options:NSJSONWritingPrettyPrintederror:&error];
NSMutableURLRequest*request = [NSMutableURLRequestrequestWithURL:[NSURLURLWithString:url]
cachePolicy:NSURLRequestUseProtocolCachePolicy
timeoutInterval:10];//请求这个地址,timeoutInterval:10 设置为10s超时:请求时间超过10s会被认为连接不上,连接超时
[request setHTTPMethod:@"POST"];//POST请求
[request setHTTPBody:httpBody];//body 数据
[request setValue:[NSStringstringWithFormat:@"application/x-www-form-urlencoded"] forHTTPHeaderField:@"Content-type"];//请求头//application/json
NSOperationQueue*queue=[NSOperationQueuemainQueue];
[NSURLConnectionsendAsynchronousRequest:request queue:queue completionHandler:^(NSURLResponse* _Nullableresponse, NSData* _Nullabledata, NSError* _NullableconnectionError) {
if(data)
{
NSError*jsonError = nil;
NSString*string = [[NSStringalloc]initWithData:data encoding:NSUTF8StringEncoding];
NSDictionary*dic = [NSJSONSerializationJSONObjectWithData:data
options:kNilOptions
error:&jsonError];
NSLog(@"dic: %@, string: %@", dic, string);
if(dic)
{
successHandler(dic);
}
else
{
failureHandler(jsonError);
}
}
}];
}
服务器部分代码:
header("Content-Type: application/x-www-form-urlencoded;charset=utf-8");
// $info = file_get_contents('php://input', 'r');
// if (strlen($info) < 1)
// {
// echo 'error';
// echo '
';
// # code...
// }
// else
// {
// $infoArray = json_decode($info, true);
// if (!$infoArray)
// {
// die('数据格式错误');
// # code...
// }
// else
// {
// $infoJson = json_encode($infoArray);
// echo $infoJson;
// }
// }
// die();
// echo "this is a test";
// echo "helloWorld!
";
$mysql_server_name = "127.0.0.1:3306";
$mysql_username = "root";
$mysql_password = "123";
$mysql_database = "fb";
$connect = mysql_connect($mysql_server_name, $mysql_username, $mysql_password);
$strsql = "select * from MyTable";
$result = mysql_db_query($mysql_database, $strsql, $connect);
$row = mysql_fetch_row($result);
for ($i=0; $i < mysql_num_fields($result); $i++)
{
//显示列名
$name = mysql_field_name($result, $i);
}
//将 data 参数指定的 MySQL 结果内部的行指针移动到指定的行号。
mysql_data_seek($result, 0);
$arr = array();
while ($row = mysql_fetch_array($result))
{
$userinfo = array('id'=>$row['id'], 'name'=>$row['name'], 'sex'=>$row['sex']);
$arr[] = $userinfo;
}
$data = json_encode($arr);
echo $data;
mysql_free_result($result);
mysql_close($connect);
?>
(注:PHP接收Json数据时,当时使用了$GLOBALS['HTTP_RAW_POST_DATA'],虽然能获取到所有的数据内容,但是无法识别数据内容,就将数据原样地填入变量$http_raw_post_data,可以参考http://jingyan.baidu.com/article/455a9950a88eaca16627788e.html,所以最后选择使用file_get_contents('php://input', 'r'),上面例子中直接返回了访问数据库的内容,连接服务器数据库建议初学者使用mamp,操作略微简单,不用配置环境)