如何在Laravel中为每个用户生成唯一的随机值并将其添加到数据库 [英] How to generate unique random value for each user in laravel and add it to database

问题描述

我正在开发一个活动组织网站.在这里，当用户注册事件时，将为他提供一个唯一的随机数(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();
}

这篇关于如何在Laravel中为每个用户生成唯一的随机值并将其添加到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！