如何在laravel中为每个用户生成唯一的随机值并将其添加到数据库中

2021-12-26 00:00:00 random php mysql laravel eloquent

我正在开发一个活动组织网站.在这里,当用户注册活动时,他将获得一个唯一的随机数(10 位),我们用它来生成条形码并将其邮寄给他.现在,

I am developing a event organization website. Here when the user registers for an event he will be given a unique random number(10 digit), which we use to generate a barcode and mail it to him. Now,

  1. 我想为每个注册的活动设置唯一的编号.
  2. 也是随机的

一种解决方案是获取数组中的所有随机数并使用 Php rand(1000000000, 9999999999) 生成一个随机数,然后循环并检查所有值.获取不等于数组中任何值的第一个值并将其添加到数据库中.

One solution is to grab all the random numbers in an array and generate a random number using Php rand(1000000000, 9999999999) and loop through and check all the values. Grab the first value that doesn't equal to any of the values in the array and add it to the database.

但我认为可能有更好的解决方案.有什么建议吗?

But I am thinking that there might be a better solution to this. Any suggestion?

推荐答案

您的逻辑在技术上没有问题.但是,如果您的应用程序吸引了大量用户,那么在资源和计算时间方面,获取所有随机数可能会变得不必要地昂贵.

Your logic isn't technically faulty. However, if your application attracts lots of users, fetching all of the random numbers may well become unnecessarily expensive, in terms of resources and computation time.

我建议另一种方法,即生成一个随机数,然后根据数据库进行检查.

I would suggest another approach, where you generate a random number and then check it against the database.

function generateBarcodeNumber() {
    $number = mt_rand(1000000000, 9999999999); // better than rand()

    // call the same function if the barcode exists already
    if (barcodeNumberExists($number)) {
        return generateBarcodeNumber();
    }

    // otherwise, it's valid and can be used
    return $number;
}

function barcodeNumberExists($number) {
    // query the database and return a boolean
    // for instance, it might look like this in Laravel
    return User::whereBarcodeNumber($number)->exists();
}

相关文章