国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

First write an array to store the member ID and modify the p value

$vips = array(
    array(
        'id' => 1,
        'p' => 1
    ),
    array(
        'id' => 2,
        'p' => 2
    ),
    ...
);
foreach ($vips as $vip) {
    執(zhí)行sql語句 update 會員表 set p  = $vip['p'] where id = $vip['id'];
}

The solution currently adopted by @tony_yin is the most basic solution. In actual applications, attention should be paid to enabling the transaction before the for loop starts and submitting the transaction after it ends. Otherwise, not to mention low performance, if there is a problem with the program during the for loop, it is easy to cause only some of the users' p values ??to be updated, while the other parts are not.

I will add another solution here: since it is mysql, you can use INSERT ... ON DUPLICATE KEY UPDATE to batch update. Sample SQL:

INSERT INTO `user`
 ( `id`, `p` ) 
VALUES
 ( 11111, 1),
 ( 22222, 2),
 -- ...
 ( 99999, 9)
ON DUPLICATE KEY UPDATE
  `id` = VALUES(`id`),
  `p` = VALUES(`p`);

update 會員表 set p = xxx

Find out the member’s ID and modify it once.
If the amount of data is large, process it in batches

update table set p = value where uid in(1,2,3)

1. It doesn’t matter if the amount of data is small and it can be placed in a loop

2. Depending on your own needs

I didn’t understand your question. Please describe it clearly when I ask. Otherwise it will be a rubbish question.
I think you want to ask some members to set their p fields at once, right?
`
update table set p = value where uid in(1,2,3)
`

Write the following where condition yourself according to the specific scenario

Or you’d better re-describe your problem