PHP 쿠폰 발행 질문 채택완료

<?php

$conn = mysqli_connect("127.0.0.1:3307", "DBID", "DBPW", "buguk9");



 

srand((double)microtime()*1000000);




 

$x=0;

 

while ($x<100){ 

 

   $len = 16;

$chars = 'ABCDEFGHJKLMNPQRSTUVWXYZ123456789';

   $i = 0;

   $str = "";

   

 

 

    while ($i < $len) {

      $num = rand() % strlen($chars);

      $tmp = substr($chars, $num, 1);

      $str .= $tmp;

      $i++;

  }

  

  $str = preg_replace('/([0-9A-Z]{4})([0-9A-Z]{4})([0-9A-Z]{4})([0-9A-Z]{4})/', '\1-\2-\3-\4', $str);

 

        $sql = "INSERT INTO coupon_test ( couponNO, ID) VALUES ( '$x', '$str');";

        echo $str ."<br>";

        //echo $CouponNo."<br>";

 

        $x++;



 

 

 

    

 

} // while 




 

$a = mysqli_query( $conn , $sql );

 

if( $a ){ echo("데이터 입력성공"); }

 

else { echo("데이터 입력실패"); }

 

?>