How do I generate numbers that are not duplicated when processing a list in while?

while ($row = mysqli_fetch_array($aa)){

      $public_order_id = date("Ymd", time()).rand(1,999999);

because there will be more than one br in an instant.
my current idiotic approach is to use rand.
, but 1999999 still has a chance to reproduce, because it uses while to generate a list!
so maybe the first generation will be 222, and the 20th will have a chance of 222!
because it is not useful to use time (), the time will be exactly the same, too fast
unless the generated list exceeds 20, the number of digits may be + 1
and it has to be compared with the database. If there is a duplicate, go back to the previous step and reproduce it.?
I have an ID that can be viewed by programmers, so I use AUTO_INCREMENT
but now I want to generate
that I want people to see. Do you want to think about a better way?

Php php7 mysql mysqli

Mar.28,2021

I think it's enough for you to use date ('Ymd'). Uniqid (). Rand (10000 Ymd'). Uniqid (). Rand (999999)

1: uuid
2: use smaller microseconds

// 
for ($i = 0; $i < 10000; PP $
    
    do {
        $time = str_replace('.', '', microtime(true));
        // 
        $key = $time . str_pad(1, 9999, STR_PAD_LEFT);
        
        // 
        if () {
            // 
            break;
        }
        
        //  
    } while(true);
    
}

the order number can be spelled with the user ID (user_id) and the number of user orders.

Previous: What are the problems when compiling and installing gmp?

Next: What does the catalog image:/images/icon-bigger.pn' mean

Batch updates to database?
I have a problem with batch updates hypothetically I am a loop printing out the box and product ID while($row = mysqli_fetch_array($data)){ <input type="hidden" name="cart_prod_id[]" value="<?=$row[ prod_id ];?>&qu...

Php php7 mysql mysqli mariadb

Mar.22,2021
How can a certain KEY be skipped automatically at the same time?
$subtotal = $pdo->query( "SELECT s.quan as quan, s.price as price, p.store_id as store_id FROM `stock` as s JOIN product as p ON s.prod_id = p.prod_id " ); while ($row_ = mysqli_fetch_array($sub...

Php php7 mysql mysqli

Mar.28,2021
How to add up the figures of the same day? Printed as correct json
this is the result of the query this is the php query code SELECT FROM_UNIXTIME(add_time, %Y-%m-%d ) as add_time, count(view_id) as viewTime FROM `view` GROUP BY `add_time` this is the whole php code header( Content-type: application j...

Json php php7 mysql mysqli

May.22,2021
There is no problem with the quantity when printing, but the number is wrong when sum?
SELECT ss.quan FROM `stock` as ss JOIN `order_record` as r ON r.order_id = ss.order_id WHERE ss.from = c AND r.from = c AND r.status = ing AND ss.prod_id = 120 GROUP BY ss.order_id ...

Php php7 mysql mysqli mariadb

Oct.17,2021
How to package some data pens into a collection, click on them, and then expand them according to the ID?
situation: uncertain orders are generated every day suppose there are eight orders generated today id status 1 2 3 4 5 6 7 8 I use loops to change the status of these eight orders to "shipping " . question: how can I tu...

Php php7 mysql mysqli mariadb

Dec.03,2021

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b353b3-40fba.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b353b3-40fba.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?