php如何异步更新mysql,php – 如何将数据更新到MySQL

我在使用多个option_id @ option_name同时更新数据时变得模糊.

当前的数据库

option_id option_name option_content option_status

1 web_url http://localhost.com 1

2 web_name My Website 1

3 web_description Welcome to my website 1

4 web_keywords movies, power, ranger 1

php更新数据

$web_name = $_POST['web_name'];

$web_url = $_POST['web_url'];

$web_desc = $_POST['web_desc'];

$web_keyword = $_POST['web_keyword'];

从DR anwser更新

$query = "UPDATE web_options SET option_content=

'{$db->string_escape($web_name, true)}'

WHERE option_name = 'web_name'";

$db->rq($query);

$query = "UPDATE web_options SET option_content=

'{$db->string_escape($web_url, true)}'

WHERE option_name = 'web_url'";

$db->rq($query);

$query = "UPDATE web_options SET option_content=

'{$db->string_escape($web_desc, true)}'

WHERE option_name = 'web_desc'";

$db->rq($query);

$query = "UPDATE web_options SET option_content=

'{$db->string_escape($web_keyword, true)}'

WHERE option_name = 'web_keyword'";

$db->rq($query);

有一种方法可以使这个更新查询更简单吗？