php - 如何通过更新来增值？

Question

如何通过更新增加值(value)？此代码将注册 id 中的值复制到 url。例如，如果 id=1 则 url=1。如何订购更新id=1然后url=id1，id=2然后url=id2。提前致谢!

我需要这样的

url = 'id+".$last_id."'

function register_user($register_data) {
    global $con;

   $con = mysqli_connect('Localhost','social','social','social');

    array_walk($register_data, 'array_sanitize');
    $register_data['password'] = md5($register_data['password']);

    $fields = '`' . implode('`, `', array_keys($register_data)) . '`';
    $data = '\'' . implode('\', \'', $register_data) . '\'';

    $insert = "INSERT INTO users($fields) VALUES ($data) ";
    mysqli_query($con,$insert);
    $last_id = mysqli_insert_id($con);
    $update = "UPDATE users SET url = '".$last_id."' WHERE id = ".$last_id." ";
    mysqli_query($con,$update );
}

Answer 1

试试这个:

$update = "UPDATE users SET url = 'id".$last_id."' WHERE id = ".$last_id." ";

还是我没听懂这个问题？