c mysql更新图片_通过objective-c更新MySQL

我正在创建一个“发布文本”应用程序，并尝试使用名称和正文字段更新我的数据库。 obj-c代码如下所示：

- (IBAction)post:(id)sender

{

NSLog(@"%@", name);

NSLog(@"%@", body);

// create string contains url address for php file, the file name is post.php, it receives parameter :name

NSString *strURL = [NSString stringWithFormat:@"http://www.mywebsite.com/post.php?name=%@&body=%@",name, body];

// to execute php code

NSData *dataURL = [NSData dataWithContentsOfURL:[NSURL URLWithString:strURL]];

// to receive the returend value

NSString *strResult = [[NSString alloc] initWithData:dataURL encoding:NSUTF8StringEncoding];

NSLog(@"%@", strResult);

}和PHP代码看起来像这样：

if (isset($_REQUEST['name']) && isset($_REQUEST['body']) && strlen($_REQUEST['name']) > 0 && strlen($_REQUEST['body']) > 0) {

//get data

$title = $_REQUEST['name'];

$body = $_REQUEST['body'];

mysql_connect("MyServer","username","password") or die(mysql_error());

mysql_select_db("Database_Name") or die(mysql_error());

$date = date("Y-m-d");

//insert data

$insert = mysql_query("INSERT INTO news VALUES ('','".mysql_real_escape_string($title)."','".mysql_real_escape_string($body)."','".mysql_real_escape_string($date)."')") or die(mysql_error());

die("Your text has been posted!");

}

?>有时它可以通过应用程序发布，但是它只是将post(null)作为名称并将null作为正文。但大多数情况下它根本不起作用。它只是在日志中说：

2012-06-26 16:54:49.893 AppName[12444:707]

clipsToBounds = YES; opaque = NO; autoresize = RM+BM; layer = >