如果让服务器只是响应请求,那么问题就出在服务器内部,而不是客户端代码。我建议在PHP代码中添加一些错误处理:
<?php// specify that this will return JSonheader('Content-type: application/json');// open database$con = mysqli_connect("localhost","user","password","notify");// Check connectionif (mysqli_connect_errno()) { echo json_enpre(array("success" => false, "message" => mysqli_connect_error(), "sqlerrno" => mysqli_connect_errno())); exit;}// get the parameters$field1 = mysqli_real_escape_string($con, $_REQUEST["firstName"]);$field2 = mysqli_real_escape_string($con, $_REQUEST["lastName"]);// perform the insert$sql = "INSERT INTO user (first_name, last_name) VALUES ('{$field1}', '{$field2}')";if (!mysqli_query($con, $sql)) { $response = array("success" => false, "message" => mysqli_error($con), "sqlerrno" => mysqli_errno($con), "sqlstate" => mysqli_sqlstate($con));} else { $response = array("success" => true);}echo json_enpre($response);mysqli_close($con);?>笔记:
我不建议以身份登录
root
。确保
mysqli_real_escape_string
用于保护自己免受SQL注入攻击(请参阅第1点)。我不知道您的
user
表中是否包含其他字段,但是如果这样,您可能要在insert
语句中指定列名。即使您只有这两列,这也是“确保未来”代码的好方法。注意,我已经更改了它以生成JSON响应。我这样做是因为它使客户端代码更容易解析和处理响应。我留给
NSJSONSerialization
你。



