Question

我在下面询问,我从我的数据库中选择了一张身份证,然后更新了该身份证的一个领域,其中1个显示这一记录已经处理。现在,我需要以CSV格式选择50份身份证和输出,并再次更新每个记录,其中1份表明这些记录已经处理。任何帮助都受到赞赏,我不相信这样做的最有效方法。

$result = mysql_query("SELECT `id` FROM `t_ids` WHERE `f_fetched` IS null LIMIT 1");
while($row = mysql_fetch_array($result))
$f_id = $row[ id ];
mysql_query("UPDATE t_ids SET f_fetched =  1  WHERE id =  $f_id ");

Answer 1

你们可以使用这样的东西。

$result = mysql_query("SELECT `id` FROM `t_ids` WHERE `f_fetched` IS null LIMIT 50");
$processed_ids = array();
while($row = mysql_fetch_array($result))
{
    //do whatever processing you need to with that id

    //add the id to the $processed_ids array
    $processed_ids[] = $row[ id ];
}

$ids = implode(",", $processed_ids);  //create a comma-delimited string of ids.

//update all rows in 1 query
mysql_query("UPDATE t_ids SET f_fetched =  1  WHERE id IN ($ids)");

Answer 2

为什么不只使用:

mysql_query("UPDATE t_ids SET f_fetched =  1  WHERE  `f_fetched` IS null");

友情链接