在php和mysql中生成3000个不同的14位数字 [英] Generate 3000 different 14-digit numbers in php and mysql

问题描述

我想创建14位PIN码.我想插入3000个不同的引脚号，然后将它们插入mysql.以下代码将仅插入120或127个随机数，而不是3000，然后停止.在给出127个数字之前，它还会循环播放更长的时间.我想要的是3000个随机数.

I want to create PINs numbers with 14 digits. I want to insert 3000 different pin numbers and then insert them into mysql. The below codes will insert only 120 or 127 random numbers instead of 3000 and stop. It also loops for longer time before giving that 127 numbers. And what I want is 3000 random numbers.

这是我的代码:

<form method="post" action=""> <table border=1> <tr>

 <td> <input type="text" name="num" placeholder="Enter total number to be generated e.g 3000" required></td>
                </tr>

            <td> <input type="submit" class="btn btn-primary" name="submit" id="submit" value="Generate Pin">  </td>
            <tr>
                <td></table></form>

    <?php
    if (isset($_POST['submit'])){
       $num = $_POST['num'];    
       for ($index = 0; $index < $num; $index++) {    
           $rand1 = rand(1000000, 9999999); 
           $check = mysql_query("SELECT * FROM pins WHERE pin='$pin' ") or die 
          (mysql_error());
          if(mysql_num_rows($check)>0){
          $index-=1; 
          } 
           $sql=mysql_query("INSERT INTO  pins(randi) VALUES('$rand1')"; } } ?> 

推荐答案

再试一次:

<?php 
    if (isset($_POST['submit'])){
    // amount of numbers
    $num = $_POST['num'];
    // array of different numbers    
    $num_ar = [];
         // infinity loop
         for ( ; ; ) {    
             // random number
             $rand1 = rand(1000000, 9999999); 
             // 14-digits
             //$rand1 = rand(10000000000000, 99999999999999);  
             // if it is a different number
             if(!in_array($rand1,$num_ar)) {

                 $sql = mysql_query("INSERT INTO  pins(randi) VALUES('$rand1')";
                 array_push($num_ar,$rand1);
             }
             // stop the loop
             if (count($num_ar) == $num) break; 

         } 

    }
?>

或

<?php 
    if (isset($_POST['submit'])){
    // amount of numbers
    $num = $_POST['num'];
    // array of different numbers    
    $num_ar = [];
         // while loop
         while (count($num_ar) !== $num) {    
             // random number
             $rand1 = rand(1000000, 9999999); 
             // 14-digits
             //$rand1 = rand(10000000000000, 99999999999999);  
             // if it is a different number
             if(!in_array($rand1,$num_ar)) {

                 $sql = mysql_query("INSERT INTO  pins(randi) VALUES('$rand1')";
                 array_push($num_ar,$rand1);
             }

         } 

    }
?>

这篇关于在php和mysql中生成3000个不同的14位数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！