Php 如何为多个表的id列设置不同的值

发布于01月18日

I need to update id column of several tables with php uniqid() values
after running this code - all rows inside each table has the same value
how to set different value for each row ?

$arr = ['lorem', 'ipsum', 'dolor'];  // table names
foreach($arr as $tb){
    $st = $db-> prepare("select * from " . $tb);
    $st -> execute();
    $arrb = $st->fetchAll();
    foreach($arrb as $elb){
        $id = uniqid();
        $sqb = "update " . $tb . " set id = :aid";
        $stb = $db->prepare($sqb);
        $stb->execute([":aid" => $id]);
    }
}

推荐答案

问题是，在外部Foreach循环的每次迭代开始时，您使用由uniqid()函数生成的相同值更新所有行.您需要使用由uniqid()函数生成的唯一值来更新每一行.

Here's one way you can fix this issue:个

$arr = ['lorem', 'ipsum', 'dolor'];  // table names
foreach($arr as $tb){
    $st = $db-> prepare("select * from " . $tb);
    $st -> execute();
    $arrb = $st->fetchAll();
    foreach($arrb as $elb){
        $id = uniqid();
        $sqb = "update " . $tb . " set id = :aid where id = :old_id";
        $stb = $db->prepare($sqb);
        $stb->execute([":aid" => $id, ":old_id" => $elb['id']]);
    }
}

在此代码中，对于内部Foreach循环的每次迭代，uniqid()函数将生成一个新值，并使用该新值更新特定行的id列.