我有一些代码可以生成随机数,例如一些折扣券代码。每次生成新代码列表时,我希望将其保存在数据库中,每次生成新列表时,因此我希望将其保存在数据库中。
<?php
$db=new mysqli('localhost','root','','shop');
if(mysqli_connect_errno()){
echo 'Could not connect to database:Plz try After Some time..';
exit;
}
$coupons = 8; //number of coupons
$size = 10; //number of characters
for ($i=0; $i<$coupons; $i++) {
$code=
echo strtoupper(substr(md5(time().rand(10000,99999)), 0, $size));
echo "<br>'n";
$qry="insert into code (code) values ('$coupons')";
$result=$db->query($qry);
}
我假设这段代码没有为你运行 - 试试下面我做了一些更改:
$coupons = 8; //number of coupons
$size = 10; //number of characters
for ($i=0; $i<$coupons; $i++) {
// Note that time() is not a very good random generator...
$code= strtoupper(substr(md5(time().rand(10000,99999)), 0, $size));
$qry="insert into code (code) values ('$code')";
$result=$db->query($qry);
}